Episode 163 - When and Why to HADR
05/13/24 • 34 min
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:
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:
Previous Episode
Episode 162 - Backups and Recovery, RTO, RPO, and RCO
Guy and Eitan talk about some interesting news from Microsoft about SQL Server in Azure.
And also discuss the topic of Backups and Recovery, RTO, RPO, RCO, and database Integrity Checks.
Relevant links:
- Microsoft Copilot in Azure extends capabilities to Azure SQL Database (Private Preview) - Microsoft Community Hub
- Regex in SQL DB (microsoft.com)
- SQL Server Regular Expressions Library Sample - Microsoft Community Hub
- STRING_SPLIT (Transact-SQL) - SQL Server | Microsoft Learn
- Do You Have a Proper Backup Strategy? (madeiradata.com)
- CHECKDB From Every Angle: Consistency Checking Options for a VLDB - Paul S. Randal (sqlskills.com)
- Where to Run DBCC on Always On Availability Groups - Brent Ozar Unlimited®
Also, check out our previous episode, if you haven't yet:
Next Episode
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)
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-163-when-and-why-to-hadr-51775016"> <img src="https://storage.googleapis.com/goodpods-images-bucket/badges/generic-badge-1.svg" alt="listen to episode 163 - when and why to hadr on goodpods" style="width: 225px" /> </a>
Copy