SQL Server 2014 Compared to older versions
Features | Feature Description | SQL Server 2014 | SQL Server 2012 | SQL Server 2008ÿR2 | SQL Server 2008 |
Performance | In-memory OLTP* | Yes | No | No | No |
In-memory ColumnStore* | Yes | Yes | No | No | |
Buffer pool extension to SSD | Yes | No | No | No | |
Resource Governor | Yes | Yes | Yes | Yes | |
Availability | AlwaysOn* | Yes | Yes | No | No |
Enhanced virtualization support and live migration | Yes | Yes | Yes | No | |
Security | Transparent data encryption* | Yes | Yes | Yes | Yes |
Backup encryption support | Yes | No | No | No | |
Fine-grained auditing | Yes | Yes | Yes | Yes | |
Separation of duties | Yes | Yes | No | No | |
Cloud-readiness | Backup to Microsoft Azure | Yes | Yes | No | No |
Disaster recovery to Microsoft Azure | Yes | No | No | No | |
Optimized VM images in Microsoft Azure gallery | Yes | Yes | No | No | |
Management & programmability | Distributed replay | Yes | Yes | No | No |
Policy-based management | Yes | Yes | Yes | Yes | |
Enhanced programmability | Yes | Yes | Yes | Yes | |
BI & analytics | PowerPivot for Excel | Yes | Yes | Yes | No |
Integration services managed as a server | Yes | Yes | No | No | |
Hadoop connector via Apache Sqoop | Yes | Yes | Yes | Yes | |
Tabular BI semantic model* | Yes | Yes | Yes | No | |
Master data services* | Yes | Yes | Yes | No | |
Data quality services* | Yes | Yes | No | No |