Compare Microsoft SQL Server versions

Compare Microsoft SQL Server versions
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2
Performance
Performance
In Memory OLTPIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
In-Memory ColumnStoreIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
Real Time Operational AnalyticsIncluded in SQL Server 2017Included in SQL Server 2016
Buffer Pool extension to SSDIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Adaptive Query Processing*Included in SQL Server 2017
Availability
Availability
Always On*Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
Basic Availability GroupsIncluded in SQL Server 2017Included in SQL Server 2016
Security
Security
Transparent data encryption*Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012Included in SQL Server 2008 R2
Backup encryption supportIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Encryption at rest and in motionIncluded in SQL Server 2017Included in SQL Server 2016
Dynamic Data Masking and Row Level SecurityIncluded in SQL Server 2017Included in SQL Server 2016
Separation of dutiesIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
Cloud-readiness
Cloud-readiness
Backup to AzureIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
Disaster recovery to Microsoft AzureIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Optimized virtual machine images in Azure galleryIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
Stretch DatabaseIncluded in SQL Server 2017Included in SQL Server 2016
Management and programmability
Management and programmability
Runs on Linux and Docker ContainersIncluded in SQL Server 2017
Temporal tablesIncluded in SQL Server 2017Included in SQL Server 2016
JSON supportIncluded in SQL Server 2017Included in SQL Server 2016
Graph data supportIncluded in SQL Server 2017
BI and analytics
BI and analytics
Integration services managed as a serverIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
PolyBase for T-SQL query across HadoopIncluded in SQL Server 2017Included in SQL Server 2016
Tabular BI semantic model*Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012Included in SQL Server 2008 R2
Master data services*Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012Included in SQL Server 2008 R2
Data quality services*Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014Included in SQL Server 2012
In-database advanced analyticsIncluded in SQL Server 2017Included in SQL Server 2016
End-to-end Mobile BI on any deviceIncluded in SQL Server 2017Included in SQL Server 2016

*SQL Server Enterprise edition only.

Back To Top