Microsoft SQL Server 2022 is the most Azure-enabled release of SQL Server yet*, with continued innovation across performance, security, and availability.
- Integrates with Azure Synapse Link and Microsoft Purview to drive deeper insights, predictions, and governance from their data at scale
- Most secure database over the last 10 years per NIST**
- Fully integrated with the new link feature in Azure SQL Managed Instance***
- New and enhanced features, including Ledger and Query Store hints
- Next generation Intelligent Query Processing features in the database engine to accelerate performance with no code changes
- Time-series database support
- New JSON functions to increase ability to query and manipulate JSON data
Help ensure uptime with fully managed disaster recovery in the cloud through the link feature in Azure SQL Managed Instance. Deliver seamless analytics and insights in near real time by breaking the wall between operational and analytical stores with Azure Synapse Link. Manage and govern an entire data estate through SQL Server integration with Microsoft Purview and Microsoft Defender for SQL assessments and alerts.
Faster performance, no code changes
New Intelligent Query Processing scenarios and Query Store enhancements mean accelerated performance and tuning with no code changes required.
Expanded security
The database rated as least vulnerable over the last ten years gets even more security with SQL Server 2022’s always-encrypted enhancements and SQL Ledger, and immutable ledger to track evidence of tampering.
Multi-write environment availability
Keep things running smoothly with users across multiple locations. When a conflict is detected, SQL Server 2022 automates the last write wins rule to ensure the most recent modification time is chosen to be persisted on all replicas.
