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
- 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
