Category Archives: SQL Server 2012

SQL Server 2012 Diagnostic Information Queries (April 2013)

Posted on April 15, 2013 by Glenn Berry

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the … Continue reading →

Posted in SQL Server 2012 | Tagged , | 3 Comments

New SQL Server Cumulative Updates

Posted on April 15, 2013 by Glenn Berry

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for SQL Server 2012. The first one is SQL Server 2008 R2 SP1 CU12, which is Build 10.50.2874. This CU has … Continue reading →

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

Scaling SQL Server 2012 in Lisbon, Portugal

Posted on March 16, 2013 by Glenn Berry

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 Diagnostic Information Queries (March 2013)

Posted on March 3, 2013 by Glenn Berry

Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the … Continue reading →

Posted in Diagnostic Queries, SQL Server 2012 | Tagged , | 3 Comments

Hardware 301 Presentation

Posted on February 14, 2013 by Glenn Berry

I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times in one day yesterday! First was a virtual presentation for the PASS Virtual DBA chapter at 12PM, and then I … Continue reading →

Posted in Computer Hardware, Processors, Sandy Bridge, SQL Server 2012 | Tagged | 3 Comments

SQL Server 2012 Diagnostic Information Queries (Feb 2013)

Posted on February 1, 2013 by Glenn Berry

Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. There is also one new query that looks for missing indexes for all databases … Continue reading →

Posted in Diagnostic Queries, SQL Server 2012 | Tagged , | 2 Comments

SQL Server 2012 Diagnostic Information Queries (Jan 2013)

Posted on January 12, 2013 by Glenn Berry

Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries mainly focusing on collecting some information about whether Change Data Capture (CDC) is enabled. … Continue reading →

Posted in SQL Server 2012 | Tagged , | 3 Comments

SQL Server 2012 Standard Edition Licensing Limits

Posted on December 28, 2012 by Glenn Berry

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)

Posted on December 28, 2012 by Glenn Berry

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 2012 Cumulative Update 5

Posted on December 17, 2012 by Glenn Berry

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