Episode 144 - Getting Locked Outside Without Your Keys

Guy and Eitan discuss a few new features in SQL Server 2022, and Guy tells a story about an interesting use case where a customer accidentally dropped their encryption keys in production.

Relevant links:

• SQL Server 2022 RC0 is now available!
• Azure Active Directory authentication for SQL Server 2022
  • Tutorial: Set up Azure Active Directory authentication for SQL Server
• Bidirectional Transactional Replication in SQL Managed Instance
• Considerations on Bidirectional Transactional Replication
• Azure Data Studio August release with SQL Server 2022 support
• Create identical symmetric keys on two servers - Microsoft Docs
• BACKUP SYMMETRIC KEY (Transact-SQL) - New SQL Server 2022 Syntax
• Troubleshooting Long-Running Shrink Operations - Eitan Blumin
• Shrink_Database_File_in_Specified_Increments.sql - Madeira Toolbox
• Too Many Plans for the Same Query Hash - Eitan Blumin