Guy and Eitan discuss a few new things in the latest SSMS update, and Eitan tells about a very peculiar use case involving transactional replication and AlwaysOn Availability Groups, and Guy talks about a use case involving deletion triggers.

Important note: The part about SQL Server 2025 CU4 adding automatic update was an April 1st joke :)

Relevant links:

• SSMS 22.5.2 Release
• Migrate SQL Server to Azure SQL | Microsoft Learn
• Introducing optimized locking v2 | Microsoft Community Hub
• SQL Server 2025 CU4 Adds Automatic Updates - Brent Ozar Unlimited® (April 1st joke)
• Hot Patching SQL Server Engine in Azure SQL Database | Microsoft Community Hub
• Configure Replication with Always on Availability Groups