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

Fix : Server Unable to load user-specified certificate. The server will not accept a connection

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...

How to install SSRS (SQL Server Reporting Service) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...

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 Create MS SQL Database Through SQL Server Management Studio?

This article will assist you to create MS SQL database through SQL Server Management Studio....

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...