Trace Id is missing
Read about the performance, security, and Azure-connected features of SQL Server 2022

SQL Server 2022 comparison

Compare SQL Server 2022 features and capabilities with prior versions.

SQL Server 2022: Azure-enabled, with continued performance and security innovation

Get to know the features and benefits now available in SQL Server 2022.

Compare SQL Server versions

Feature availability

  • not supported Not supported
  • supported Fully supported
Pricing and licensing overview
Features
SQL Server 2022
SQL Server 2019
SQL Server 2017
Intelligence across all your data
Data virtualization using PolyBase[1]
Supported
Supported
Supported
Data virtualization for any data lake
Supported
Not Supported
Not Supported
Object storage backup and restore
Supported
Not Supported
Not Supported
Azure Synapse Link
Supported
Not Supported
Not Supported
Database performance
In-memory database: in-memory OLTP
Supported
Supported
Supported
In-Memory Database: Persistent Memory[2]
Supported
Supported
Supported
In-memory database: memory-optimized tempdb
Supported
Supported
Not Supported
Real-time operational analytics
Supported
Supported
Supported
Intelligent query processing[3]
Supported
Supported
Supported
Buffer pool parallel scan
Supported
Not Supported
Not Supported
Query Store on by default with replica support
Supported
Not Supported
Not Supported
Query Store hints
Supported
Not Supported
Not Supported
Integrated acceleration & offloading
Supported
Not Supported
Not Supported
Hybrid buffer pool with direct write
Supported
Not Supported
Not Supported
Advanced Vector Extension (AVX) 512 extension to improve batch mode operations
Supported
Not Supported
Not Supported
Availability
Always on
Supported
Supported
Supported
Accelerated database recovery
Supported
Supported
Not Supported
Read scale-out availability groups
Supported
Supported
Supported
Large memory and concurrency scalability
Supported
Not Supported
Not Supported
Multi-write replication
Supported
Not Supported
Not Supported
Link to Azure SQL Managed Instance - replicas
Supported
Supported
Supported
Link to Azure SQL Managed Instance - unidirectional
Supported
Supported
Supported
Link to Azure SQL Managed Instance - bidirectional[6]
Supported
Not Supported
Not Supported
Contained availability group
Supported
Not Supported
Not Supported
Encryption at rest and in motion
Supported
Supported
Not Supported
Security
Always encrypted with secure enclaves[4]
Supported
Supported
Not Supported
Data discovery and classification
Supported
Supported
Not Supported
Transparent data encryption
Supported
Supported
Supported
Backup encryption support
Supported
Supported
Supported
Encryption at rest and in motion
Supported
Supported
Supported
Dynamic data masking and row-level security
Supported
Supported
Supported
Microsoft Entra ID (formerly Azure Active Directory) authentication[7]
Supported
Not Supported
Not Supported
Microsoft Defender for SQL
Supported
Supported
Supported
Microsoft Purview Integration central governance
Supported
Supported
Supported
Microsoft Purview Integration data owner policies
Supported
Not Supported
Not Supported
SQL Ledger
Supported
Not Supported
Not Supported
Support for PFX certificates and other cryptographic enhancements
Supported
Not Supported
Not Supported
MS-TDS 8.0 protocol and TLS 1.3
Supported
Not Supported
Not Supported
Azure-enabled
Link to Azure SQL Managed Instance - replicas
Supported
Supported
Supported
Link to Azure SQL Managed Instance - unidirectional
Supported
Supported
Supported
Link to Azure SQL Managed Instance - bidirectional[6]
Supported
Not Supported
Not Supported
Optimized virtual machine (VM) images in Azure gallery
Supported
Supported
Supported
Free asynchronous replication on Azure Virtual Machines for disaster recovery
Supported
Supported
Not Supported
Microsoft Defender for SQL
Supported
Supported
Supported
Azure Purview central governance
Supported
Supported
Supported
Azure Purview data owner policies
Supported
Not Supported
Not Supported
Microsoft Entra ID (formerly Azure AD) Authentication
Supported
Not Supported
Not Supported
Azure Synapse Link for SQL
Supported
Not Supported
Not Supported
Management and programmability
Linux support
Supported
Supported
Supported
Container support
Supported
Supported
Supported
Kubernetes support
Supported
Supported
Not Supported
Temporal tables
Supported
Supported
Supported
JSON support
Supported
Supported
Supported
Graph data support
Supported
Supported
Supported
UTF 8 support
Supported
Supported
Not Supported
Java support
Supported
Supported
Not Supported
Azure Data Studio to manage SQL Server including support for T-SQL using notebooks
Supported
Supported
Supported
Database compatibility certification
Supported
Supported
Supported
Bit manipulation functions
Supported
Not Supported
Not Supported
Time series support
Supported
Not Supported
Not Supported
BI and Analytics Support
Integration services managed as a server
Supported
Supported
Supported
Tabular BI semantic model[5]
Supported
Supported
Supported
Master data services[5]
Supported
Supported
Supported
Data quality services[5]
Supported
Supported
Supported
Many-to-many relationships in tabular models
Supported
Supported
Not Supported
End-to-end mobile BI on any device
Supported
Supported
Supported
SQL Server Analysis Services (SSAS) direct query
Supported
Supported
Supported
Calculation groups in tabular model
Supported
Supported
Not Supported
  • [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] See full list Intelligent Query Processing updates by release.
  • [4] See additional SQL Server 2022 secure enclaves updates.
  • [5] SQL Server Enterprise edition only.
  • [6] The bidirectional disaster recovery capability of the Link feature for Azure SQL Managed Instance is available in limited public preview. Learn more.
  • [7] Feature requires connection to Azure Arc agent.

NOTE: See the list of SQL Server 2022 features. 

Available SQL Server 2022 editions

Enterprise

Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 data 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 2022

Follow us

Share this page