Here is the December 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. There is also one new query at the very end, adapted from Erin Stellato.

To go with it is an updated, blank…

Read more

Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

Here are a couple of the more important hotfixes:

SQL…

Read more

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 4, which is Build 10.50.4270. I count 34 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

This Cumulative Update is only for SQL…

Read more

Microsoft has released SQL Server 2008 R2 Service Pack 1 Cumulative Update 10, which is Build 10.50.2868. I count 15 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

This Cumulative Update is only for… Read more

I started blogging back on August 9, 2006, so I have been at it for quite a while. I am pretty proud that I have stayed pretty active with relatively frequent posts over the past six-plus years. I don’t plan on changing that anytime soon. I will occasionally write about… Read more

Here is the December 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements. I dropped a couple of redundant queries, and added a new query at the end.

To go with it is an updated, blank results spreadsheet, where the tabs…

Read more

I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after that, I can remember drawing pictures of Saturn V rockets blasting off, with smoke billowing on either side. It is hard to describe how much so many people were inspired… Read more

Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. To go with it is an updated, blank 2008 results spreadsheet, where the tabs in the spreadsheet are labeled and in…

Read more

As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly half of all of the SQL Server courses on Pluralsight have been produced by the SQLskills team, and more are on the way.

Just in case you would like… Read more

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. If you already have SQL Server 2012 installed, you… Read more

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 for Query #36.

To go…

Read more

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 seemed to be pretty well received. Here is the abstract: Read more

A new book that I wrote a couple of chapters for has just been released. It is Professional SQL Server 2012 Internals and Troubleshooting from Wrox. I really believe this is a high quality book from a collection of great authors (who somehow let me on the project) that I… Read more

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 typical, since SQL Server Service Packs undergo longer and more… Read more

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, Bill Graziano started out the keynote, running through what PASS… Read more

Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in Lone Tree, Colorado at 8AM to see what kind of line they had for the new Microsoft Surface RT. This is a relatively new, attractive mall that is only… Read more

My first training course from Pluralsight, Understanding Server Hardware has just gone live. It is listed in the SQL Server section of the course catalog, even though it is not really SQL Server specific. It is meant as a foundational course to give you the basic concepts that are… Read more

Here is the October 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 results spreadsheet, where the tabs in the spreadsheet…

Read more

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 all had relatively high numbers of fixes, which shows… Read more

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 redundant.

To go with it is an updated, blank…

Read more