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