SQL Server 2017 comparison

Compare Microsoft SQL Server versions

Feature availability
  • Feature not supported Not supported   
  • Feature supported Fully supported   

Features

Performance features of SQL Server by SQL Server version
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2
Performance features of SQL Server by SQL Server version
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 2014
Real Time Operational AnalyticsIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
Buffer Pool extension to SSDIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Adaptive Query Processing[1]Included in SQL Server 2017Not included in SQL Server 2016Not included in SQL Server 2014
Availability features of SQL Server by SQL Server version
Always On[1]Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Basic Availability GroupsIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
Security features of SQL Server by SQL Server version
Transparent data encryption[1]Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
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 2016Not included in SQL Server 2014
Dynamic Data Masking and Row Level SecurityIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
Separation of dutiesIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Cloud-readiness features of SQL Server by SQL Server version
Backup to AzureIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
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 2014
Stretch DatabaseIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
Management and programmability features of SQL Server by SQL Server version
Runs on Linux and Docker ContainersIncluded in SQL Server 2017Not included in SQL Server 2016Not included in SQL Server 2014
Temporal tablesIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
JSON supportIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
Graph data supportIncluded in SQL Server 2017Not included in SQL Server 2016Not included in SQL Server 2014
BI and analytics features of SQL Server by SQL Server version
Integration services managed as a serverIncluded in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
PolyBase for T-SQL query across HadoopIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
Tabular BI semantic model[1]Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Master data services[1]Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
Data quality services[1]Included in SQL Server 2017Included in SQL Server 2016Included in SQL Server 2014
In-database advanced analyticsIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014
End-to-end Mobile BI on any deviceIncluded in SQL Server 2017Included in SQL Server 2016Not included in SQL Server 2014

[1] SQL Server Enterprise edition only.

Back To Top