Office Hours: Ask Me Anything at the Barcelona Pavilion скачать в хорошем качестве

Office Hours: Ask Me Anything at the Barcelona Pavilion

I found myself in front of the Barcelona Pavilion by Mies van der Rohe, one of my Epic Life Quest task goals! Delightful. I took 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?