TechEd North America 2014 Video Prep Sessions Available
Click here for TechEd North America 2014 Video Prep Sessions now available online.
Powershell – Stopping a Microsoft Windows Service
In this example, l will attempt to get and stop a windows service for say, SQLdefragmanagementservice. First open a windows powershell console, using the run as administrator below. Use the get-process to get the process id. Use the stop-process to kill the windows process/service. Then run the code shown in the screenshot below, modify as […]
The database owner SID recorded
Issue: A restored database from one instance to the other keeps showing below when attempting to say, alter a stored procedure. The database owner SID recorded in the master database differs from the database owner SID recorded in database Solution applied: Assuming XYZ is the name of the database and contosoadmin is the name of […]
Microsoft SQL Server Merge Replication Client Status Information
Below is a select statement which can be placed in a view, for providing information on core merge replication status information usually seen using Microsoft SQL Server Replication Monitor GUI tool. SELECT TOP 1000 [subscriber_server] ,[db_name] ,SubStatus = CASE [status] WHEN 0 THEN ‘Inactive’ WHEN 1 THEN ‘Active’ WHEN 2 THEN ‘Deleted’ ELSE ‘N/A’ END […]
How to – SQL Format Date and Format Datetime using T-SQL Convert Function
Very good article on Koydaz website – click here, on how to format SQL Date using T-SQL Convert Function
My 24 hours of wait stats
Below is excellent feedback and links received from Paul Randal of SQLSkills on 24 hours of wait stats data captured from several of SQL Server instances l help manage, labeled for this post, instance1,instance2 etc. I will update this as l go through the suggestions. INSTANCE1 For the LATCH_EX, you’ll need to drill in with […]