Episode 187 - Transactional Replication Between Availability Groups

Episode 187 - Transactional Replication Between Availability Groups

May 13, 2026 · 30 min · Episode 188

About this episode

Guy and Eitan discuss new features in SSMS and peculiar use cases involving transactional replication and deletion triggers.

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

More episodes of SQL Server Radio

Explore listener stats, chart rankings, contacts and more on the SQL Server Radio podcast page.