Run SQL Server on your favorite platform

It's all about choice. Now, you can get SQL Server 2017's industry-leading performance and security on Windows, Linux, and Docker containers.

Compare Microsoft SQL Server versions

Feature availability Feature not supported

Not supported Feature supported

Fully supported

Performance

Performance
Features	SQL Server 2017	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2
In Memory OLTP
In-Memory ColumnStore
Real Time Operational Analytics
Buffer Pool extension to SSD
Adaptive Query Processing^[1]

Availability

Security

Security
Features	SQL Server 2017	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2
Transparent data encryption^[1]
Backup encryption support
Encryption at rest and in motion
Dynamic Data Masking and Row Level Security
Separation of duties

Cloud-readiness

Cloud-readiness
Features	SQL Server 2017	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2
Backup to Azure

Disaster recovery to Microsoft Azure
Optimized virtual machine images in Azure gallery
Stretch Database

Management and programmability

Management and programmability
Features	SQL Server 2017	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2
Runs on Linux and Docker Containers
Temporal tables
JSON support
Graph data support

BI and analytics

BI and analytics
Features	SQL Server 2017	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2
Integration services managed as a server
PolyBase for T-SQL query across Hadoop
Tabular BI semantic model^[1]

Master data services^[1]
Data quality services^[1]
In-database advanced analytics
End-to-end Mobile BI on any device

[1] SQL Server Enterprise edition only.