It’s time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento:

Here’s what we discussed:

• 00:00 Start
• 00:17 SteveTV: Hi Brent! Are there solutions for managing SQL Agent jobs that obviate the need for manual updates and write access to Job definitions in SSMS? We need to remove write access to agent jobs, and create a deployment strategy that includes approval, change history and testing.
• 00:36 MyTeaGotCold: I have Query Store enabled on every database and it is overwhelming. Any advice for AUTOMATICALLY monitoring Query Store data across multiple databases? Both sp_BlitzQueryStore and sp_QuickieStore are designed for single databases.
• 00:53 Miles: Hi Brent, Good Morning. Having too many VLFs will cause blocking? if so, why? Also, how many VLF count is a good VLF count to maintain so that database recovery doesn’t take long time. Thank you.
• 01:16 Drew: We send out SQL backups direct to Azure and recently the verify backup is taking hours. Is this an Azure bandwidth issue or a SQL server issue?
• 01:37 22DBA: for how long do you think the DBA full-time position will exist?
• 01:56 NotCloseEnough2RetirementToStopLearning: Hi Brent, are you seeing any signs that Microsoft Fabric is catching on enough to merit career investment or is just another failed repackaging?
• 02:11 Alexey: one of SQL server 2016 enterprise has 3500 opened sleeping sessions when I am running sp_whoisactive. Is it reflect on a performance overall?
• 02:36 Ignacio: Have you read James Serra’s new book on Data fabric, data lakehouse, and data mesh architectures?
• 02:56 Peter: Hi Brent, as and when you update sections of your recorded classes do you plan to email subscribers? I would rather not have to re-watch everything to find useful updates.
• 03:04 Barry Allen: Will we ever see a flash office hours (30 seconds) YouTube short?
• 03:21 Karthik: Have you ever run into the issue where query plan shows warning of a missing statistic for a column but that statistic / index actually already exists? We had to fix this by manually rebuilding stats. Not sure what causes this.
• 03:37 Carrie Jeffries: Does anyone have a work around for applying both CUs and GDRs with sccm? We are told to we can only patch CUs or GDRs with sccm now and we have to pick one branch? https://learn.microsoft.com/en-US/tro…
• 03:54 WhatsNext : Hello Brent. I have been a production DBA on SQL Server for 15 years. Lately, have felt like I want to learn something new. BI and Analytics being popular, do I go with Snowflake or Databrick? Look at AI and ML? I have never been much of an analytics or data visualization guy.
• 04:25 MyTeaGotCold: When should I replace a temp table with a memory-optimised table variable?
• 04:44 Miles: Hi Brent, query is running slow. spid’s waitype is CXPACKET. After digging further one of the thread wait on SOS_SCHEDULER_YIELD. Server has 32 cpu’s,CPU util is under 15% nothing else is running. Why it is had to wait for cpu when it is not a high cpu condition on the server?
• 05:29 Greef Karga: Is there much demand for a PostgreSQL version of constant care? How hard would a port be?
• 05:54 Vittorio: What contingencies do you have in place in the event that Amazon raises prices on Aurora PostgreSQL by 5x? Would you move to another cloud?
• 06:25 Captain Lou: In SQL 2019, Is it ok to leave LIGHTWEIGHT_QUERY_PROFILING turned on or should it only be enabled situationally?
• 06:42 Finch: Brent, what’s your recommendation on when to create a new SQL instance vs. when to just add additional databases in an existing instance.
• 07:14 Miles: Hi Brent, seeing INSERT blocking SELECTs? hoping that SQL inserts data at the end of the table and those r new rows so it shouldn’t block any spid. We have application which INSERTs based on SELECT. eg) INSERT INTO TNAME SELECT.. WHERE …; Does it make a difference? any fix?
• 07:46 GP Geek: What’s best way to analyze a nested query with multiple UNION ALL that runs forever apparently on only one or 2 of the UNION query..
• 08:06 Oswald: What are your thoughts on the newer cloud DB’s that are managed / accessed via API’s? How might this affect the DBA role and required skills?
• 08:25 Does bout nothing: If you were a Microsoft SQL PM, what top things would you do to retake market share from PostgreSQL?
• 08:50 Jr Wannabe DBA: Hi Brent, 3 years later from your blog post, what is your opinion about PolyBase? Would you recommend it as an option to replace Linked Servers?
• 09:30 Ólafur : What do the default transaction isolation level metrics look like for your constant care shops?