Home » SQL Server 2014 Compared to older versions

SQL Server 2014 Compared to older versions

sql server DBA 999

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *