SQL Server 2022 Engine Deep Dive Part 2 by David Pless & Kevin Farlee

Session Title: SQL Server 2022 Engine Deep Dive Part 2
Speaker(s): David Pless & Kevin Farlee

Abstract: In this session we will focus on many of the storage improvements with advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power.
The storage engine features and capabilities we will highlight are tempdb improvements, Always On Availability Group improvements, accelerated database recovery, shrink database with low priority, xml compression and more.

We will touch on availability improvements such as Intel QAT backup compression to offload backup overhead and multi-write replication

for multi-master writes users across multiple locations.

Finally, we will review the security capabilities with SQL Server ledger, encryption enhancements, improvements to dynamic data masking, and more.