Features
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
Performance
In Memory OLTP
In-Memory ColumnStore
Real Time Operational Analytics
Buffer Pool extension to SSD
Adaptive Query Processing [2]
Availability
Always On [2]
Basic Availability Groups
Security
Transparent data encryption [2]
Backup encryption support
Encryption at rest and in motion
Dynamic Data Masking and Row Level Security
Separation of duties
Cloud-readiness
Backup to Azure
Disaster recovery to Microsoft Azure
Optimized virtual machine images in Azure gallery
Stretch Database
Management and programmability
Runs on Linux and Docker Containers
Temporal tables
JSON support
Graph data support
BI and analytics
Integration services managed as a server
PolyBase for T-SQL query across Hadoop
Tabular BI semantic model [2]
Master data services [2]
Data quality services [2]
In-database advanced analytics
End-to-end Mobile BI on any device