[Video] Office Hours: Ask Me Anything About SQL Server at the Volcano Hekla

I drove up the volcano Hekla in central Iceland – also known as the Gateway to Hell – and parked the Defender here:

While my travel companions hiked up higher (and took that photo), I set up the tripod and camera, then went through your highly-upvoted questions from https://pollgab.com/room/brento.

Here are the questions I covered:

• 00:00 Introductions
• 00:40 Mehdi: How do I check progress of a long-running query before I kill it?
• 02:29 Viking: Why is CHECKDB taking so long?
• 04:41 James: When I fail over my AG to a secondary, a random database gets stuck in a resolving state. Why?
• 05:45 Joe Gleason: Should developers be allowed to run traces in production?
• 07:27 Stanislav: How do I reduce blocking?
• 09:17 Jaden: How do I understand big, complex queries quickly?
• 10:16 Rent-a-Balloon: What’s the optimal way to run stored procedures one row at a time?