Click here for TechEd North America 2014 Video Prep Sessions now available online.
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 […]
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 […]
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 […]
Very good article on Koydaz website – click here, on how to format SQL Date using T-SQL Convert Function
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 […]