Industry leading performance and security with SQL Server 2019
Regardless of where your data is stored, query and analyze it with the data platform known for performance, security, and availability.
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
| 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 |
|
|
|
[1] For HDFS and Azure Blob Storage only(For SQL Server 2017, SQL Server 2016 only).
[2] For tail of the log only (For SQL Server 2017, SQL Server 2016 only).
[3] SQL Server Enterprise edition only.
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