[Video] Office Hours Overlooking Rome

I was in Rome to attend a teaching conference, and my AirBnB had the most beautiful view overlooking Rome and Vatican City. While having my morning coffee, I went through your top-voted questions from https://pollgab.com/room/brento – and I didn’t go through many questions because some of them required really long answers, and I had a great time with those.

Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are sold.

Here’s what we discussed:

• 00:00 Start
• 01:03 Friendly Viking: 1 of 3: Have you heard of anyone using sharding in Azure SQL DB in production?
• 04:44 Friendly Viking: 2 of 3: My company wants to make their SQL databases “active / active” across Azure regions for HA. Rather than relying on failover groups
• 08:04 Rambling about my AirBnB
• 08:50 Friendly Viking: 3 of 3: I don’t see this as a mature solution and open to all sorts of issues.
• 10:24 Bad Hunch: Does Resource Governor cause parameter sniffing emergencies?
• 11:47 A_Big_Fan_of_your_work: Hi dear mentor, You often mention that snapshot backup for large database works fine but you never (at least to my knowledge) went into the details. How do it work ? How does log backup works with them ? Commun gotcha ? Thank you!
• 13:17 Sheikh Amed: How often should you update stats? We were updating stats nightly but our nightly maintenance window is too small and customer complained about db performance when stats were being updated.