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.

Related Articles

How to use MSSQL Activity Monitor to find the most expensive query?

A slow and long running SQL query execution consumes much processor, memory, and disk of your...

Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...

How to change password for MS SQL admin user?

Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you...

How to Backup MSSQL Database from SQL Server Management Studio?

To take MS SQL database backup, first you need to connect to MS SQL Server through SQL Server...

How to assign particular permissions to SQL server database user from SQL Server Management Studio?

We can restrict SQL database users to fire some critical queries, e.g. Update, Delete, etc....

  • 0 Users Found This Useful

Was this answer helpful?