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 |
Learn about SQL Server detecting logical consistency based issues and how to resolve them.
Learn about SQL Server error 1222 and how to resolve the lock request time out…
Discover the new features of Microsoft SQL Server 2022 and how they compare to previous…
SQL Server Error 1222 lock request time out period exceeded Lock request time out…
SQL Server Error : 427, Severity: 20. Could not load the definition for constraint ID…
SQL Server Error : 204, Severity: 20. Normalization error in node %ls.
This website uses cookies.