THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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.

SSMS

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.

Catalog

Figure 2. Integration Services Catalogs.

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

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

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is both a Registered Nurse and a Microsoft SQL Server MVP experienced in Microsoft 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. Experienced in systems integration and workflow analysis, John is passionate about combining his IT experience with his nursing background to solve difficult problems in healthcare. He sees opportunities in using business intelligence and Big Data to satisfy healthcare meaningful use requirements and improve patient outcomes. John graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement