[Video] Home Office Hours, Under Construction Edition

Videos

While in the midst of moving my home office into a new room in the house, I stopped to take your top-voted questions from https://pollgab.com/room/brento. About 18.5 minutes into the recording, my camera overheated because I hadn’t set up the fan on it yet, hahaha.

Here’s what we covered:

  • 00:00 Start
  • 02:28 Born to be glowin: Have you ever added a feature to first responder kit that you had hesitation or regrets on? If so, which one?
  • 05:41 Kulstad: Hi Brent. Have you changed your opinion on using Copilot AI inside of SSMS? Your post from May 2025 suggests we steer clear of it, but I wonder if MS has made any improvements to change your mind since then.
  • 08:47 YouTubeFreeLoader: I have a select query that is intermittently timing out after 30s and DPA is showing 98% of the total wait time for this query is PAGELATCH_SH. What query attributes would I be looking for that would be causing this issue? Any tips to mock up this scenario in SQLQueryStress?
  • 14:03 Now I’m shinin’: What’s your opinion of Azure Horizon DB? Does it stand a chance against Amazon Aurora?
  • 15:27 Fey Mood: Have you ever had any surprises with Dynamic Data Masking?
  • 15:40 Q-Ent: Hi Brent, based on the questions during office hours, how do you think SQL Server professionals’ thinking and maturity have evolved over time?
  • 18:30 jrl: Which types of technology workers do you think are least exposed to AI-related job loss?
  • 18:53 SteveE: In one of your PG courses, you say if you are having to ask developers to change code, then you as a DBA or the DB itself has failed. How is this so when you can’t compensate for the work of others? Some of the queries I see others write give the database no chance at all!
Previous Post
Automatic Stats Updates Don’t Always Invalidate Cached Plans

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.