Category Archives: SQL Server 2008

DMV Emergency Room!

I had the opportunity to present DMV Emergency Room! at SQLSaturday #169 in Denver, Colorado on September 22, 2012. I had a nice, full room with about 40-50 people, which is pretty good for a local event. I want to … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 3 Comments

SQL Server 2008 Diagnostic Information Queries (August 2012)

Here is the August 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and one new query. To go with it is an updated, blank 2008 … Continue reading

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

Two New Cumulative Updates for SQL Server 2008

On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server 2008 SP2 CU11, which is Build 10.00.4333. There are two fixes listed in the public fix list. The second cumulative … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged , | Leave a comment

SQL Server 2008 Diagnostic Information Queries (July 2012)

Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and one new query. To go with it is an updated, blank 2008 results … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 14 Comments

Win A Free Registration to SQLskills Immersion Event 1

You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training class in Bellevue, WA on August 6 – 10, 2012, sponsored by SQLSentry.  This is really a great chance to … Continue reading

Posted in Microsoft, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Teaching | Tagged | Leave a comment

SQL Server 2008 Diagnostic Information Queries (June 2012)

Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements, including query numbering and one new query at the end. To go with it is an updated, blank results spreadsheet, where … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 13 Comments

SQL Server 2008 SP3 Cumulative Update 5 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3 CU5, which is Build 10.00.5785.00. There are only four fixes listed in the public fix list. The second Cumulative Update … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged | 1 Comment

SQL Server 2008 Diagnostic Information Queries (May 2012)

Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic Information Queries. This version works on SQL Server 2008 and SQL Server 2008 R2. There are a few queries that … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 13 Comments

Onward and Upward!

As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting on May 1, 2012. I am very excited by this opportunity, since I will have the chance to work with … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Teaching | Tagged | 16 Comments

Three Sessions at Spring 2012 Connections Conference

I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one at 8AM! Hopefully enough people will be able to get up by then and join me. It should be a … Continue reading

Posted in Computer Hardware, Microsoft Training, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Storage Subsystems | Tagged | 9 Comments