[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:

Brent on Volcano Hekla

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?
Previous Post
[Video] Office Hours: Ask Me Anything About SQL Server at Vestrahorn
Next Post
What Should We Change About This Year’s Data Professional Salary Survey?

2 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.