Episode 115 - How can UPDATE STATISTICS cause HADR disconnections?
Release Date: 04/13/2020
SQL Server Radio
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: Also, check out our previous episode, if you haven't yet:
info_outline Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)SQL Server Radio
Niko Neugebauer and Vladimir Ivanovic are our esteemed guests for today, and they have a HUGE announcement to make about Azure SQL Managed Instances. Extra! Extra! 🗞 Hear all about it on this exclusive scoop here at the SQL Server Radio podcast! Relevant links: (2 min video)
info_outline Episode 160 - OPTION RECOMPILE and the magical Turbo buttonSQL Server Radio
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info:
info_outline Episode 159 - Select * Wastes MoneySQL Server Radio
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: Also, Happy New Year! 🎉🎈🥂
info_outline Episode 158 - Reverse Engineering Table Relations based on SQL PlansSQL Server Radio
Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads. Relevant links:
info_outline No episode this monthSQL Server Radio
SQL Server Radio is going on a short break this month. Please tune in next month for when we'll be coming back! In the meantime, check out some of our favorite past episodes:
info_outline Episode 157 - Let's Talk Some Hardcore SQL ServerSQL Server Radio
Guy and Eitan go back to their SQL Server roots and go hardcore into execution plan analysis and database corruption. Relevant links:
info_outline Episode 156 - Back to School with Encryption as a ToolSQL Server Radio
Guy and Eitan celebrate resuming the school year with some learning of their own. This time, focusing on encryption types in SQL Server. Relevant links: and And also, don’t forget to register for the upcoming !
info_outline Episode 155 - Kevin ChantSQL Server Radio
Today we have Kevin Chant as our guest! We talk about Kevin’s favorite topics: Microsoft Fabric, Azure DevOps, SQL Server, and more. Relevant links:
info_outline Episode 154 - Beavers and very loud fartsSQL Server Radio
Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about! Relevant links:
info_outlineEitan does his worst Donald Trump impression, and talks SQL Server stuff with Guy Glantser:
- Ola Hallengren's maintenance solution
- SQL Server Index Maintenance – You’re Doing It Wrong | Sean Gallardy
- Because Your Index Maintenance Script Is Measuring The Wrong Thing | Erik Darling
- How can UPDATE STATISTICS cause HADR disconnections?
- Eitan's File Size Maintenance Solution
- MCSA, MCSD, MCSE certifications retire; with continued investment to role-based certifications
- Azure SQL Managed Instance Performance Considerations | Tim Radney
- Azure Windows VM Sizes
- And more
This episode was recorded on March 8th, at the Microsoft for Startups podcast room in Tel-Aviv