Monthly Archives: November 2010

SQL Server 2008 and 2008 R2 Diagnostic Information Queries

Since Microsoft released SQL Server 2008 SP2 CU1 and SQL Server 2008 SP1 CU11 this week, I thought it would be a good excuse to post the latest version of my Diagnostic Information Queries. You need to have VIEW SERVER … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | 9 Comments

Dynamically Backing Up All User Databases in SQL Server

I recently had a request from a client to come up with a routine to do a full compressed database backup of all of the user databases on an instance of SQL Server 2008. They wanted to be able to … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | 8 Comments

SQL Server 2008 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes in this Cumulative Update, which is meant to get the SP2 code branch in synchronization with SQL Server 2008 SP1 … Continue reading

Posted in SQL Server 2008 | 1 Comment

Handy Hardware Assessment Tools For SQL Server

Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you are interested in, whether it is a database server or a laptop. The first one is CPU-Z, which gives you … Continue reading

Posted in Computer Hardware | 1 Comment

New Path to MCM in SQL Server 2008

Last week, during the first day of the PASS 2010 Summit, Microsoft’s Joe Sack announced the revamped testing program for the Microsoft Certified Master (MCM) for SQL Server 2008. Previously, you had to pay roughly $20K to attend three consecutive … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server 2005 Diagnostic Information Queries (November 2010)

Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are DMV queries that require VIEW SERVER STATE permission in order to run. Some of these queries will also run on … Continue reading

Posted in SQL Server 2005 | 2 Comments

My Conversation with Ted Kummert at the PASS 2010 Summit

For some mysterious reason, I was selected as one of the “official” bloggers/tweeters during the PASS Keynotes last week. This meant that I got to sit at one of the three blogger’s tables in the back of the conference hall, … Continue reading

Posted in PASS | 3 Comments