Category Archives: SQL Server 2012

SQL Server 2012 Service Pack 1 CU1 is Available

Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 1, which is Build 11.0.3321. I count 44 fixes in this Cumulative Update. You will need SQL Server 2012 Service Pack 1 installed before you install this Cumulative Update. … Continue reading

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

SQL Server 2012 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. I want to thank Mike Fal (blog/Twitter) who made a very useful suggestion … Continue reading

Posted in SQL Server 2012 | Tagged , | 3 Comments

Migrating to SQL Server 2012

I had the opportunity to deliver my Migrating to SQL Server 2012 presentation at the PASS 2012 Summit last Friday in Seattle. Although I was in the TCC annex of the convention center, I had pretty good attendance, and it … Continue reading

Posted in PASS, SQL Server 2012, Teaching | Tagged | 3 Comments

SQL Server 2012 Service Pack 1 Released

Microsoft has released SQL Server 2012 Service Pack 1 for general availability. SQL Server 2012 SP1 includes all of the fixes from SQL Server 2012 RTM CU1 and CU2, but not the fixes from CU3 and CU4. That is pretty … Continue reading

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

Day One Key Note at PASS 2012 Summit

This is the 14th PASS Summit, and there are nearly 4000 attendees from 57 countries. There are 127K members in PASS now. Those figures are really pretty amazing, showing very good growth over the past several years. SQL PASS President, … Continue reading

Posted in Microsoft, PASS, SQL Server 2012 | Tagged , | Leave a comment

SQL Server 2012 RTM Cumulative Update 4

Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25 fixes in the public fix list for this cumulative update. The first four cumulative updates for SQL Server 2012 have … Continue reading

Posted in Microsoft, SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

SQL Server 2012 Diagnostic Information Queries (October 2012)

Here is the October 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries.  I also removed three of the existing queries, since they seemed a little … Continue reading

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

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 2012 Diagnostic Information Queries (September 2012)

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

Posted in SQL Server 2012 | Tagged | 1 Comment

Interview on RunAsRadio #281 with Richard Campbell

I recently had a chance to record a 33 minute podcast interview on RunAs Radio #281 with Richard Campbell, where I talked about the licensing changes in SQL Server 2012 and how to select your new hardware to minimize your … Continue reading

Posted in Computer Hardware, Haswell, Processors, Sandy Bridge, SQL Server 2012, Windows Server 2012 | Tagged , , | Leave a comment