[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.
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!
Related

Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Get Free SQL Stuff
"*" indicates required fields

4 Comments. Leave new
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.
@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.
Was it difficult to get the Anthony Bourdain portrait off the wall? The last time you mentioned it, you couldn’t move it.
Yeah, hahaha, the 3M Command strips took the paint off the wall!