Compare Microsoft SQL Server Versions

In SQL Server there are many SQL Versions available and there are some difference with in those Versions.

Here we are going to have a look for some difference between SQL Versions which are applicable Enterprise Edition.

Features SQL Server 2017 SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008R2
Performance
In Memory OLTP Yes Yes Yes NA NA
In-Memory ColumnStore Yes Yes Yes Yes NA
Real Time Operational Analytics Yes Yes NA NA NA
Buffer Pool Extension to SSD Yes Yes Yes NA NA
Adaptive Query Processing Yes NA NA NA NA
Availability
AlwaysOn Yes Yes Yes Yes NA
Basic Availability Groups Yes Yes NA NA NA
Security
Transparent Data Encryption Yes Yes Yes Yes Yes
Backup Encription Support Yes Yes Yes NA NA
Encription at rest in motion Yes Yes NA NA NA
Dynamic Data Masking and Row Level Security Yes Yes NA NA NA
Separation of duties Yes Yes Yes Yes NA
Cloud- Readiness
Backup to Azure Yes Yes Yes Yes NA
Disaster Recovery to Microsoft Azure Yes Yes Yes NA NA
Optimised virtual machine images in Azure Gallery Yes Yes Yes Yes NA
Stretch Databases Yes Yes NA NA NA
Management and Programmability
Run on Linux and Docker Containers Yes NA NA NA NA
Temporal Tables Yes Yes NA NA NA
JSON Support Yes Yes NA NA NA
Graph Data Support Yes NA NA NA NA
BI and Analytics
Integration Services Managed as Server Yes Yes Yes Yes NA
PolyBase for T-SQL query across Hadoop Yes Yes NA NA NA
Tabular BI semantic model Yes Yes Yes Yes Yes
Master Data Services Yes Yes Yes Yes Yes
Data Quality Services Yes Yes Yes Yes NA
In-Data Advanced Analytics Yes Yes NA NA NA
End-to-end Mobile BI on any device Yes Yes NA NA NA

 

Leave a Reply

Your email address will not be published. Required fields are marked *