Trace Id is missing

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

 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

[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.

Get started with SQL Server 2019

Follow us

Share this page