Category Archives: Microsoft

Scaling SQL Server 2012 in Lisbon, Portugal

I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon, Portugal. This was the first time I have spoken at a SQLSaturday outside of the United States, and I really … Continue reading

Posted in Microsoft, PASS, SQL Server 2012, Teaching, Travel | Tagged | 2 Comments

SQL Server 2012 Standard Edition Licensing Limits

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware. As a DBA and consultant, I would like to … Continue reading

Posted in Computer Hardware, Microsoft, SQL Server 2012 | Tagged , | 12 Comments

SQL Server 2012 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2012 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 my … Continue reading

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

SQL Server 2008 Diagnostic Information Queries (Dec 2012)

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 … Continue reading

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

SQL Server 2012 Cumulative Update 5

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 … Continue reading

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

SQL Server 2008 R2 SP2 Cumulative Update 4

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 … Continue reading

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

SQL Server 2008 R2 SP1 Cumulative Update 10

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 … Continue reading

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

Free One Week Passes to PluralSight

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 … Continue reading

Posted in Microsoft, Pluralsight, Teaching | Tagged | 1 Comment

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

Book Signing at SQLSentry Booth at PASS Summit 2012

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 … Continue reading

Posted in Microsoft, PASS, Teaching | Tagged | 2 Comments