Choosing Between SQL Server 2012 and SQL Server 2014

If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to advanced version. Currently, your choices will be SQL Server 2012 and SQL Server 2014. Before picking one of these SQL servers, perhaps you would like to know what enhancements you will get by upgrading to these SQL versions. In this article, we’ll compile the list of new features introduced in SQL server 2014 compared to it’s predecessor SQL server 2012.


Performance and Scale
  • In-Memory OLTP
  • Enhanced In-Memory ColumnStore for DW
  • Buffer Pool Extension to SSDs
  • Enhanced Query Processing
  • Resource Governor adds IO governance
  • SysPrep at cluster level
  • Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2
 High Availability
  • Enhanced AlwaysOn, with 8 secondaries and Replica Wizard
  • Delayed Durability
  • Clustered Shared Volume support, VHDX support (Windows Server 2012 R2)
  • Manage on-premises and cloud apps (System Center 2012 R2)
  • Enhanced separation of duty
  • CC certification at High Assurance Level for 2014
  • Backup encryption support
  • Query optimization enhancements
Easy Access to Data
  • Power Query
  • Windows Azure HDInsight Service
  • Analytics Platform System (PDW V2)
Powerful Insights with Familiar Tools 
  • Power BI in Office 365
  • Power Map for Excel
  • Mobile interfaces for Power BI
Hybrid Cloud Solutions
  • Simplified backup to Windows Azure
  • Support for backup of previous versions of SQL Server to Windows Azure
  • Cloud back-up encryption support
  • Simplified cloud Disaster Recovery with AlwaysOn replicas in Windows Azure VMs
Easy on ramp to the Cloud
  • New Windows Azure Deployment UI for SQL Server
  • Larger SQL Server VMs and memory sizes now available in Windows Azure


Looking upon the new features introduced with the SQL Server 2014, certainly you'll find SQL Server 2014 as the better choice. It’s possible that not all of the features may be applicable to you today, but you should also consider that taking advantage of them later will be easier if you're already on that version. By choosing SQL Server 2014 right away, you will get advantage of several hidden improvements and performance enhancements that you'll get without having to touch a line of code.

Was this answer helpful?

« Back


/* */