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)
Security
  • Enhanced separation of duty
  • CC certification at High Assurance Level for 2014
  • Backup encryption support
Programmability 
  • 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.



  • 0 Users Found This Useful

Was this answer helpful?


Related Articles

Comparison of MS SQL Server 2016 Express Edition V/S. MS SQL Server 2016 Web Edition

Following is a brief comparison between MSSQL Server 2016 Express Edition and MSSQL Server 2016...

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 Increase the MS SQL Remote Query Timeout?

MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a...

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

How to configure MSSQL server default language configuration option?

Recently, we faced strange issue wherein one of our customers was capturing error messages coming...