I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I ended up walking right past it while visiting Barcelona! It’s one of the most important beginnings of modern architecture, and I loved it. I brought you along with me and talked through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

• 00:00 Start
• 02:22 James: Hi Brent, I noticed in your last Office Hours session that your shoes looked huge! Do you have big feet? Just curious—what shoe size do you wear?
• 03:30 Jerry: You mentioned a professional association for SQL Server during your last Office Hours. I’ve also heard about the PASS Summit—are they related?
• 04:40 MyTeaGotCold: Are Availability Groups the hardest thing in all of SQL Server? It’s as if you can’t debug them without a very deep knowledge of SQL Server’s internals.
• 07:02 Raja: Hi Brent! How do you create a nonclustered index or alter a clustered index on a large table where blocking is unacceptable to the system?
• 08:17 DataBarbieAdministrator: Hi Brent! What was your worst experience with a customer – and how did you handle it? Thank you for all the (great!) free work you do for the community!
• 12:28 Caught Brent’s Cold: Are CAL licences permanent? The official licensing guide was no help.
• 13:41 Q-Ent: Hi brent, during your consulting career have you ever faced a satiation where a client or a department by the client challenged your knowledge or your competency?
• 16:02 Dankula Flow: Should I treat the Blocked Process Report like Query Store and turn it on by default? I’m unclear on its performance costs.
• 17:15 BA with DBA Hobby: I have separate disks for the database, log files and TempDB. When I switch our production DB from Simple to Full recovery mode the latencies on the database disk go wild. I would expect the latencies on the log files to go up not on the database. What could this be?
• 18:40 World Peace: Hello dar Brent! The following scripts need xp_cmdshell: sp_allNightLog, sp_AllNightLog_Setup, sp_Blitz, sp_DatabaseRestore. xp_cmdshell is not a supported feature in AZURE Serverless and SQL Server Managed Instances. Is there a work around or a plan to fix this in the future?