• Australia: 1300 553 313
  • New Zealand: 0800 450 168

Microsoft SQL Server 2022

The most Azure-enabled release yet, with continued performance, security, and availability innovation.

Watch video
Home / Microsoft Products / Microsoft SQL Server 2022

Explore SQL Server 2022 capabilities

Business continuity through Azure

Help ensure uptime with fully managed disaster recovery in the cloud through the link feature in Azure SQL Managed Instance. Continuously replicate data to and from the cloud.2

Seamless analytics over on-premises operational data

Drive insights in near real time by breaking the wall between operational and analytical stores. Analyze all your data using both Spark and SQL runtimes in the cloud with Azure Synapse Link.

Visibility over your entire data estate

Manage and govern your entire data estate to overcome data silos with Microsoft Purview.

The most secure database over the last 10 years

Achieve your security and compliance goals using the database rated as least vulnerable over the last 10 years.1 Use an immutable ledger to help protect data from tampering.

Industry-leading performance and availability

Take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required. Keep multi-write environments running smoothly for users across multiple locations.

Featured SQL Server 2022 resources

SQL Server 2022 datasheet

Learn about all the latest features in this free SQL Server 2022 datasheet.

Download now

SQL Server 2022 documentation

Dive into the technical details including installation guidance and stay up to date on the latest release notes.

Learn more

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.

Compare SQL Server versions

FeaturesSQL Server 2022SQL Server 2019SQL Server 2017
Intelligence across all your data
Data virtualization using PolyBase[1]yesyesyes
Data virtualization for any data lakeyesnono
Object storage backup and restoreyesnono
Azure Synapse Linkyesnono
Database performance
In-memory database: in-memory OLTPyesyesyes
In-Memory Database: Persistent Memory[2]yesyesyes
In-memory database: memory-optimized tempdbyesyesno
Real-time operational analyticsyesyesyes
Intelligent query processing[3]yesyesyes
Buffer pool parallel scanyesnono
Query Store on by default with replica supportyesnono
Query Store hintsyesnono
Integrated acceleration & offloadingyesnono
Hybrid buffer pool with direct writeyesnono
Advanced Vector Extension (AVX) 512 extension to improve batch mode operationsyesnono
Availability
Always onyesyesyes
Accelerated database recoveryyesyes
Read scale-out availability groupsyesyesyes
Large memory and concurrency scalabilityyesnono
Multi-write replicationyesnono
Link to Azure SQL Managed Instance – replicasyesyesyes
Link to Azure SQL Managed Instance – unidirectionalyesyesyes
Link to Azure SQL Managed Instance – bidirectional[6]yesnono
Contained availability groupyesnono
Security
Always encrypted with secure enclaves[4]yesyesno
Data discovery and classificationyesyesno
Transparent data encryptionyesyesyes
Backup encryption supportyesyesyes
Encryption at rest and in motionyesyesyes
Dynamic data masking and row-level securityyesyesyes
Azure Active Directory authentication[7]yesnono
Microsoft Defender for SQLyesyesyes
Microsoft Purview Integration central governanceyesyesyes
Microsoft Purview Integration data owner policiesyesnono
SQL Ledgeryesnono
Support for PFX certificates and other cryptographic enhancementsyesnono
MS-TDS 8.0 protocol and TLS 1.3yesnono
Azure-enabled
Link to Azure SQL Managed Instance – replicasyesyesyes
Link to Azure SQL Managed Instance – unidirectionalyesyesyes
Link to Azure SQL Managed Instance – bidirectional[6]yesnono
Optimized virtual machine (VM) images in Azure galleryyesyesyes
Free asynchronous replication on Azure Virtual Machines for disaster recoveryyesyesno
Microsoft Defender for SQLyesyesyes
Azure Purview central governanceyesyesyes
Azure Purview data owner policiesyesnono
AAD Authenticationyesnono
Azure Synapse Link for SQLyesnono
Management and programmability
Linux supportyesyesyes
Container supportyesyesyes
Kubernetes supportyesyes
Temporal tablesyesyesyes
JSON supportyesyesyes
Graph data supportyesyesyes
UTF 8 supportyesyesno
Java supportyesyesno
Azure Data Studio to manage SQL Server including support for T-SQL using notebooksyesyesyes
Database compatibility certificationyesyesyes
Bit manipulation functionsyesnono
Time series supportyesnono
BI and Analytics Support
Integration services managed as a serveryesyesyes
Tabular BI semantic model[5]yesyesyes
Master data services[5]yesyesyes
Data quality services[5]yesyesyes
Many-to-many relationships in tabular modelsyesyesno
End-to-end mobile BI on any deviceyesyesyes
SQL Server Analysis Services (SSAS) direct queryyesyesyes
Calculation groups in tabular modelyesyesno

Footnotes:

  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. Sign up for early access. General availability will occur at a future date.
  7. Feature requires connection to Azure Arc agent.


NOTE: See the list of SQL Server 2022 features.