Category Archives: SQL Server 2012

The Fantastic 12 of SQL Server 2012

Posted on May 7, 2012 by Glenn Berry

The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the SQL Server Product team talk about their favorite features and improvements in SQL Server 2012. These videos go up every … Continue reading →

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

SQL Server 2012 Diagnostic Information Queries (April 2012)

Posted on April 26, 2012 by Glenn Berry

It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. … Continue reading →

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

SQL Server 2012 Core Factor Table for AMD Processors

Posted on April 22, 2012 by Glenn Berry

As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can download it here (PDF warning). The complete SQL Server 2012 Licensing Overview is here. The most relevant part of this … Continue reading →

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

SQL Server 2012 RTM Cumulative Update 1

Posted on April 12, 2012 by Glenn Berry

Microsoft has released SQL Server 2012 RTM Cumulative Update 1, which is Build 11.0.2316.0. I count 55 fixes in the public fix list, which is a pretty high number of fixes. This is a good thing, to see the first … Continue reading →

Posted in SQL Server 2012 | Tagged | 2 Comments

Onward and Upward!

Posted on April 9, 2012 by Glenn Berry

As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting on May 1, 2012. I am very excited by this opportunity, since I will have the chance to work with … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Teaching | Tagged | 16 Comments

Second TPC-E Benchmark Result Published For SQL Server 2012

Posted on April 4, 2012 by Glenn Berry

NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is a new record of 4614.22 TpsE. This is for an eight socket system with 2.4GHz Intel Xeon E7-8870 processors, 2048GB … Continue reading →

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

Intel Sandy Bridge-EP Processor Recap

Posted on April 4, 2012 by Glenn Berry

On March 6, 2012, Intel finally released the Xeon E5 processor family, (aka the Sandy Bridge-EP). Sandy Bridge is a Tock release for Intel, and as such, it represents a huge jump in both performance and power efficiency over the … Continue reading →

Posted in Computer Hardware, Processors, SQL Server 2008 R2, SQL Server 2012 | Tagged | Leave a comment

Three Sessions at Spring 2012 Connections Conference

Posted on March 29, 2012 by Glenn Berry

I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one at 8AM! Hopefully enough people will be able to get up by then and join me. It should be a … Continue reading →

Posted in Computer Hardware, Microsoft Training, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Storage Subsystems | Tagged | 9 Comments

SQL Server Database Mirroring Tips and Tricks, Part 3

Posted on March 27, 2012 by Glenn Berry

One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that are dependent on each other will failover together, so they are running on the same side of the database mirroring … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 12 Comments

SQL Server Database Mirroring Tips and Tricks, Part 2

Posted on March 21, 2012 by Glenn Berry

If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common ways to do it involves creating certificates on each instance, creating logins and users for those certificates, and copying the … Continue reading →

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