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

XBox 360 250GB and Kinect Bundle

I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best Buy yesterday. Getting the bundle saves you about $100 over getting the 250GB XBox 360 and the Kinect sensor separately, … Continue reading

Posted in Games | 1 Comment

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS 2010 Summit. It will be the first session after the keynote address, and I will be going against some very … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

Full-Text Search Enhancements in SQL Server Denali

Since Microsoft announced the existence of CTP1 of SQL Server Denali during Ted Kummert’s keynote address at PASS 2010 yesterday, they have made Books Online available in both Online form and as downloadable content that you can view offline.  The … Continue reading

Posted in Microsoft | Leave a comment