I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones:

Here’s what we covered:

• 00:00 Start
• 01:10 Trushit: You mention in your career internals guide that you focused on high value things for which business are willing to pay. How did you control the temptation of trying to learn everything & focus on just sql server? Btw, looking forward to see you at PASS Summit – fan boy moment.
• 05:17 Keith: I have a vendor application that is creating over 7,000 connections and my concern is potential Threadpool exhaustion. How do I find out how much memory each connection is taking?
• 06:58 Trushit: I have been through your fundamental classes. I write T-SQL for reporting & don’t deal with execution plans that often. I am struggling to choose between your precon, Eric’s and Kendra’s performance tuning internals & conquer SQL Server performance monsters. Any thoughts?
• 08:49 Davros: What’s your opinion of PowerBI and Databricks?
• 09:31 MustangKirby: I was investigating a customer’s query that seemed stuck. Watching with live query stats showed me that it was hung up on a sort operation. Running sp_whoasactive showed the physical reads were climbing and greater than logical reads. What can cause that?
• 10:18 Mattia Nocerino: I want to show my developers the problems of abusing NOLOCK but I’m having problems replicating your demo in my database. I’m updating a varchar column and at the same time i’m doing a select count(*), but I don’t see big swings in the result. There are 0 NCI. Any idea?
• 11:04 Donna Noble: Do you ever see clients with too many SQL cooks in the kitchen (sysadmins)? What misfortunes have you seen from this?
• 13:15 Vinesh: What’s your opinion of SQL 2022 CETaS functionality to export cold data to Azure storage in Parquet format?
• 14:28 Dr Disrespect: I’m thinking about changing careers. How hard is it to become a DBA?
• 15:40 ChompingBIts: I swapped to being a DBA about three years ago now. Your same year of experience over and over comment felt a little too familiar. I’ve been learning to automate more with DBA Tools and finding ways to improve process, but what’s your advice for better experience beyond quiting.
• 17:14 Kate Stewart: What’s the top issue you run into with locating SQL temp DB on the cloud VM’s ephemeral drive?
• 18:11 MyTeaGotCold: What’s your favourite way to sabotage a server? Does sp_Blitz catch it?
• 19:26 WouldLiketoKnow: Is there a way to protect custom SQL from being viewed by others in a Stored Procedure that is being sold? Creating a SP “with encryption” offers some protection but there are still ways to view it. Would storing SP code in a DLL type of file offer any more protection.