Sql Server Radio

Episode 144 - Getting Locked Outside Without Your Keys

Informações:

Sinopsis

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