Episode 187 - Transactional Replication Between Availability Groups

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

People in this episode

Hosts: Guy Glantser, Eitan Blumin

Topics covered

• transactional replication
• AlwaysOn Availability Groups
• SSMS update
• deletion triggers
• SQL Server 2025

Keywords

• transactional replication
• AlwaysOn Availability Groups
• SSMS update
• deletion triggers
• SQL Server 2025

Mentioned in this episode

Organizations: Microsoft Learn, Brent Ozar Unlimited®, Microsoft Community Hub

Products: SSMS 22.5.2, SQL Server 2025 CU4

More episodes of SQL Server Radio

• Episode 188 - Virtualization pitfalls and best practices with SQL Server · June 8, 2026 · 30 min
• Episode 186 - Automatic Index Compaction and New DB DevOps Tooling · April 13, 2026 · 31 min
• Episode 185 - The Liar's Dividend · March 9, 2026 · 36 min
• Episode 184 - The Role of the DBA is Dead (Again) · February 9, 2026 · 36 min
• Episode 183 - Azure SQL Managed Instance Next Gen · January 12, 2026 · 36 min
• Episode 182 - Matan Yungman's Show-and-Tell of Rapido · December 8, 2025 · 41 min