Category Archives: SQL Server

SQL Server Released to Manufacturing (RTM)

Posted on March 6, 2012 by sqldavidpsmith

SQL Server was released to manufacturing today, with general availability on April 1, 2012.  If you have not looked at the new licensing model, you should definitely do so – there are significant savings if you purchase your licenses by … Continue reading →

Posted in SQL Server | Leave a comment

SQL 2012 Special Ops Tour cities

Posted on February 10, 2012 by sqldavidpsmith

Microsoft, in partnership with SQL PASS, is traveling around the country with special sessions on SQL Server 2012.  Check out the Special Ops site for a tour city near you. There is a lot new in SQL Server 2012, so … Continue reading →

Posted in SQL Server | Leave a comment

ServiceU – SQL Server 2012 Case Study

Posted on December 14, 2011 by sqldavidpsmith

The case study on ServiceU’s implementation of SQL Server 2012 has just been published.  You can read about our experience with SQL Server 2012 here.

Posted in SQL Server | Leave a comment

SQL Server 2012 Multisite Failover Cluster Instance Enhancements Whitepaper

Posted on December 12, 2011 by sqldavidpsmith

The SQL Server 2012 Multisite Failover Cluster Instance Whitepaper has just been published.  This whitepaper contains some of the many AlwaysOn enhancements available in SQL Server 2012.

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

SQL Server 2012 Release Candidate 0 (RC0) Available for Download

Posted on November 18, 2011 by sqldavidpsmith

Microsoft has now publically released SQL Server 2012 RC0.  If you have not downloaded CTP3, go ahead and download RC0 and start getting familiar with it.  RC0 should be very stable, so I don’t expect that you will find many … Continue reading →

Posted in SQL Server | Tagged , | Leave a comment

SQL Server Licensing Model Overhauled for SQL 2012

Posted on November 3, 2011 by sqldavidpsmith

November 3, 2011 – Today Microsoft announced that the licensing model for SQL Server 2012 will be dramatically different from previous versions of SQL Server. For the first time, Microsoft will start charging for “computing power” – yes, that means … Continue reading →

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

SQL Server “Denali” now officially “SQL Server 2012”

Posted on October 12, 2011 by sqldavidpsmith

This morning, in his keynote address at the SQL PASS Community Summit, Ted Kummert announced that the next version of SQL Server, previously code named “Denali”, will be release in the first half of 2012, and will officially be called … Continue reading →

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

SQL Server Breaking Changes and Deprecated Features (2012, 2008 R2, 2008, 2005, 2000)

Posted on October 4, 2011 by sqldavidpsmith

In a recent discussion, the issue of breaking changes in SQL Server 2012 came up, and I realized that no one in the room had a thorough knowledge of the breaking changes and discontinued features.  Since we were trying to determine … Continue reading →

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

ServiceU is live with SQL Server “Denali”!

Posted on October 1, 2011 by sqldavidpsmith

Today we went live with SQL Server “Denali” for our Tier-1 systems.  We did it with only 3 minutes 45 seconds of downtime, and zero problems.  We will make up that downtime between now and the end of the year … Continue reading →

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

sp_server_diagnostics

Posted on August 16, 2011 by sqldavidpsmith

SQL Server “Denali” has introduced a new way to capture SQL Server health and diagnostic information with the sp_server_diagnostics stored procedure: sp_server_diagnostics [@repeat_interval =] ‘repeat_interval_in_seconds’ The stored procedure runs in “repeat mode” and periodically returns results.  Specifying 0 as the … Continue reading →

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