THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

SQL Server 2012–what it is and what it isn’t

After SQL Azure was introduced, I made a side by side view of SSMS when connected to SQL Server and also when connected to SQL Azure. Somebody asked me if I was going to do the same to compare SQL Server 2008 R2 to SQL Server 2012, so here it is. Where there is a gap on one side and not on the other, that’s a feature unique to one of the two versions of SQL Server being compared. There are more differences than are shown here – these are the major differences. SQL Server has additional facets and more system views, among other things.


Figure 1. SQL Server 2008 R2 on the left and SQL Server 2012 on the right.

The SQL Writer Service works with the Volume Shadow Copy Service. Winmgmt works with WMI.

Database Mirroring is deprecated and is replaced by AlwaysOn Availability Groups. In the side by side comparison shown above, I abbreviated the 14 AlwaysOn system policies and 14 AlwaysOn system conditions into single line entries.

Notice that Data Transformation Services and SQL Mail, which were previously deprecated, do not appear in SQL Server 2012 at all. Did you know that SQL Server Profiler is deprecated in SQL Server 2012? A list of all deprecated features is found here.  In the future, you will use Extended Events to collect and replay traces.

There are many changes to SSIS including new Integration Services Catalogs.


Figure 2. Integration Services Catalogs.

Published Monday, February 25, 2013 7:52 PM by John Paul Cook



Sunil Boga said:

thank you John for such a nice post which gives differences between sql 2008 and 2012 in brief..

February 26, 2013 9:41 AM
Anonymous comments are disabled

About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a registered nurse recently completed the education to become a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement