Launch week: the Season Pass & Fundamentals Week are 50% off — ends in 19d 14h 34mSee the sale

[Video] Home Office Hours, Under Construction Edition

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.

Home Office Hours: Under Construction Edition

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!

Free, 3× a week

Get my new posts by email

Three posts a week, plus a Monday roundup of the best database news from around the web.

4 comments

  1. YouTubeFreeLoader, not sure if this is your issue but there was a bug in SSMS 21 that caused your queries to timeout after 30-seconds. It has since been fixed.

  2. @YouTubeFreeLoader, I have hit the same timeout issue and was able to overcome it by setting the Command Timeout value to 0 (unlimited). Check on the Connection Properties -> Advanced -> Command Timeout value.

  3. Was it difficult to get the Anthony Bourdain portrait off the wall? The last time you mentioned it, you couldn’t move it.

Leave a comment

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