Skip to main content

Compare Microsoft SQL Server versions

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

[1] SQL Server Enterprise edition only.

Back To Top