SQL Server 2019: Your modern data platform
Get to know the features and benefits now available in SQL Server 2019.
Compare SQL Server versions
Feature availability
-
Not supported
-
Fully supported
| Features |
SQL Server 2019
|
SQL Server 2017
|
SQL Server 2016
|
|---|---|---|---|
| Intelligence across all your data |
|
|
|
| Data virtualization using PolyBase[1] |
|
|
|
| Database performance |
|
|
|
| In-memory database: in-memory OLTP |
|
|
|
| In-Memory Database: Persistent Memory[2] |
|
|
|
| In-memory database: memory-optimized tempdb |
|
|
|
| Real-time operational analytics |
|
|
|
| Intelligent query processing |
|
|
|
| Intelligent performance |
|
|
|
| Availability |
|
|
|
| Always on |
|
|
|
| Accelerated database recovery |
|
|
|
| Read scale-out availability groups |
|
|
|
| Security |
|
|
|
| Always encrypted |
|
|
|
| Always encrypted with secure enclaves |
|
|
|
| Data discovery and classification |
|
|
|
| Transparent data encryption |
|
|
|
| Backup encryption support |
|
|
|
| Encryption at rest and in motion |
|
|
|
| Dynamic data masking and row-level security |
|
|
|
| Cloud readiness |
|
|
|
| Backup to Azure |
|
|
|
| Disaster recovery to Azure |
|
|
|
| Optimized virtual machine (VM) images in Azure gallery |
|
|
|
| Free asynchronous replication on Azure Virtual Machines for disaster recovery |
|
|
|
| Management and programmability |
|
|
|
| Linux support |
|
|
|
| Container support |
|
|
|
| Kubernetes support |
|
|
|
| Temporal tables |
|
|
|
| JSON support |
|
|
|
| Graph data support |
|
|
|
| UTF 8 support |
|
|
|
| Java support |
|
|
|
| Azure Data Studio to manage SQL Server including support for T-SQL using notebooks |
|
|
|
| Database compatibility certification |
|
|
|
| BI and Analytics Support |
|
|
|
| Integration services managed as a server |
|
|
|
| Tabular BI semantic model[3] |
|
|
|
| Master data services[3] |
|
|
|
| Data quality services[3] |
|
|
|
| Many-to-many relationships in tabular models |
|
|
|
| End-to-end mobile BI on any device |
|
|
|
| SQL Server Analysis Services (SSAS) direct query |
|
|
|
| Calculation groups in tabular model |
|
|
|
Available SQL Server 2019 editions
Enterprise
Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.
Standard
Get rich programming capabilities, security innovations, and fast performance for mid-tier applications. Easily upgrade to the Enterprise edition without changing any code.
Express
Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free.
Developer
Build, test, and demonstrate applications using all the features of the Enterprise edition in your non-production dev/test environments. Available for free.
Follow us
Share this page