Episode 164 - The Good the Bad and the Ugly Transactional Replication

Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases.

Also, some important announcements from Microsoft about Azure SQL!

Relevant links:

• Data API builder General Availability (microsoft.com)
• Build REST API with Azure Data API Builder (DAB) (mssqltips.com)
• Zero ETL, Near-real time replication, Mirroring Azure SQL Databases in Fabric (microsoft.com)
• Announcing EAP for Vector Support in Azure SQL Database - Azure SQL Devs’ Corner (microsoft.com)
• Update Policy for Azure SQL Managed Instance - Microsoft Community Hub
• Transactional Replication - SQL Server | Microsoft Learn
• MadeiraData/ReplicationManagementMechanism: Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures (github.com)