SQL server comparison

Comparison between versions of SQL Server

Features SQL Server 2014 SQL Server 2012 SQL Server 2008 R2 SQL Server 2008
Performance In-memory OLTP*
In-memory Column Store*
Buffer pool extension to SSD
Resource Governor
Availability Always On
Enhanced virtualization support and migration
Security Transparent data encryption
Backup encryption support
Fine-grained auditing
Seperation of dutites
Cloud-readiness Backup to Microsoft Azure
Disaster recovery to Microsoft Azure
Optimized VM images in Microsoft Azure gallery
Management & programmaility Distrubuted reply
Policy-based management
Enhanced programmability
BI & analytics PowerPivot for Excel
Integration services managed as a server
Hadoop connector via Apache sqoop
Tabular BI semantic model
Master data services
Data quality services