Some of SQL Server 2022 new features requires an entire session for them, such as the Intelligent Query Processing, , SQL Ledger and Azure SQL Link.

But there are many more features in SQL Server 2022 that would be almost forgotten. WE will talk about them:

Concurrent GAM and SGAM
Auto Drop Statistics
XML compression
Dynamic Data Masking Granular Permissions

and more!