SQL 2008

Microsoft 70-433 exam review

In my last post “January Goals Update” I promised that I would write a few lines on my experience of taking the 70-433 SQL Server 2008 Database Development MCTS exam. I know not everybody is a big fan of the certification process but it does have it’s merits, Brad McGehee summed them up very well […]

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 […]

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 […]

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 […]

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 […]

Changing how you view results in SSMS

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