Registered Servers Error in SSMS

Last week I needed to repair my installation of Windows and ended up reinstalling completely over the top of the existing OS, this lead to an error is SSMS when I wanted to use Registered Servers, I have added the error in it’s entirety below:

See the end of this message for details on invoking

just-in-time (JIT) debugging [...]

Unexpected results with sys.dm_exec_procedure_stats

This morning I was writing a script to identify some stored procedures that I felt may benefit from tuning as part of this script I referenced the very useful DMV sys.dm_exec_procedure_stats. (I will post the script later)

If you have not used this DMV before I suggest that you take a look in BOL as it returns some [...]

Installing SQL Server with Slipstream

Many thanks to Christian Bolton for telling me about “Slipstream” and how it can streamline your installation process.

Wikipedia defines slipstreaming as:

In computer jargon, to slipstream updates, patches or service packs means to integrate them into the installation files of their original software, so that the resulting files will allow a direct installation of the updated software.

If not [...]

Installing Anti Virus on a SQL Server

It’s been quite a while since I last posted anything on this site, there’s been a lot of change behind the scenes and have a number of entries to post based on things that have happened in the last few weeks.

Earlier this week I was asked by one of our infrastructure guys when would be a [...]

Changing the display of results in SSMS

Richard Douglas describes how you can make viewing your data results easier for others in SSMS in a few easy steps. [...]