MS SQL Server 2022 (16.x) Hosting Available Now!

Tweet

Feature highlights

The following sections identify features that are improved or introduced in SQL Server 2022 (16.x).

• Analytics
  • Azure Synapse Link for SQL
  • Object storage integration
  • Data Virtualization
• Availability
  • Link to Azure SQL Managed Instance
  • Contained availability group
  • Distributed availability group
  • Improved backup metadata
• Security
  • Microsoft Defender for Cloud integration
  • Microsoft Purview integration
  • Ledger
  • Microsoft Entra authentication
  • Always encrypted with secure enclaves
  • Access Control: Permissions
  • Access Control: Server-level Roles
  • Dynamic data masking
  • Support for PFX certificates, and other cryptographic improvements
  • Support MS-TDS 8.0 protocol
• Performance
  • System page latch concurrency enhancements
  • Buffer pool parallel scan
  • Ordered clustered columnstore index
  • Improved columnstore segment elimination
  • In-memory OLTP management
  • Virtual log file growth
  • Thread management
  • Reduced buffer pool I/O promotions
  • Enhanced spinlock algorithms
  • Improved virtual log file (VLF) algorithms
  • Instant file initialization for transaction log file growth events
• Query Store and intelligent query processing
  • Query Store on secondary replicas
  • Query Store hints
  • Memory grant feedback
  • Parameter sensitive plan optimization
  • Degree of parallelism (DOP) feedback
  • Cardinality estimation feedback
  • Optimized plan forcing
• Management
  • Integrated setup experience for the Azure extension for SQL Server
  • Manage Azure extension for SQL Server
  • Max server memory calculations
  • Accelerated Database Recovery (ADR) improvements
  • Improved snapshot backup support
  • Shrink database WAIT_AT_LOW_PRIORITY
  • XML compresion
  • Asynchronous auto update statistics concurrency
  • Backup and restore to S3-compatible object storage
• Platform
  • SQL Server Native Client (SNAC) has been removed
  • Hybrid buffer pool with direct write
  • Integrated acceleration & offloading
  • Improved optimization
• Language
  • Resumable add table constraints
  • CREATE INDEX
  • Transactional replication
  • CREATE STATISTICS
  • SELECT ... WINDOW clause
  • IS [NOT] DISTINCT FROM
  • Time series functions
  • JSON functions
  • Aggregate functions
  • T-SQL functions
  • Bit manipulation functions