Episode 164 - The Good the Bad and the Ugly Transactional Replication
06/10/24 • 35 min
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)
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)
Previous Episode
Episode 163 - When and Why to HADR
Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them.
Relevant links for further reading:
Next Episode
Episode 165 - News in Azure SQL and Woes of Excel
Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correctly in AlwaysOn Availability Groups.
Relevant links:
- SQLBits Free Videos - YouTube
- JSON data type (preview) - SQL Server | Microsoft Learn
- Efficient Time-Based Audit Log Filtering for Azure SQL Database - Microsoft Community Hub
- UNISTR and ANSI SQL concatenation operator (||) (microsoft.com)
- SQL Server on Azure VMs: I/O analysis (preview) - Microsoft Community Hub
- Announcing the retirement of SQL Server Stretch Database - Microsoft SQL Server Blog
- 30 SQL Server Security Checks in 30 Days Archives - Straight Path Solutions
- Use Sparse Columns - SQL Server | Microsoft Learn
- SQL Server Jobs & AlwaysOn Interoperability | HADRMyJobs
If you like this episode you’ll love
Episode Comments
Generate a badge
Get a badge for your website that links back to this episode
<a href="https://goodpods.com/podcasts/sql-server-radio-165092/episode-164-the-good-the-bad-and-the-ugly-transactional-replication-54040617"> <img src="https://storage.googleapis.com/goodpods-images-bucket/badges/generic-badge-1.svg" alt="listen to episode 164 - the good the bad and the ugly transactional replication on goodpods" style="width: 225px" /> </a>
Copy