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

Fix :: Reporting Service Error After Upgrade From MS SQL server from 2008 to 2012

Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities....

Can I create unlimited MS SQL databases with unlimited database size?

Shared/Reseller Hosting: In Windows Shared/ Windows Reseller hosting you can create MS SQL...

Unable to launch SQL Server Configuration Manager – Invalid class [0x80041010]

You may receive the below image while you access the server configuration manager on your windows...

How do I connect to MSSQL Server 2008 from SQL Server Management Studio?

This article will guide you on how to connect to MS SQL Server 2008 from SQL Server Management...

How to change user access mode in MSSQL Server?

MSSQL Server provides a feature to restrict your Database access for users. It can be performed...

  • 0 Users Found This Useful

Was this answer helpful?