I’m on a Med cruise, and I stopped the boat today in Corsica to make sure your questions from https://pollgab.com/room/brento got the answers they deserve. I started by mentioning that I’m using a 360 degree camera, but the file size on that video was so huge that I couldn’t upload it from the cruise ship, so you just get the 180 version.

Here’s what we covered:

• 00:00 Start
• 01:36 chandwich: Hey, Brent. At what point in your career did you start to feel truly confident in your ability to solve problems you have not seen before? Was there a specific “aha!” moment? Did that contribute to your decisions to move into consulting?
• 04:35 Erez Yaar: Hi Brent, following your course i have ran sp_blitz on a freshly recovered database. I have got around 450 messages “Leftover Fake Indexes From Wizards” but no indexes to delete (only the statistics shows the same index names. The script on the URL return nothing.
• 05:48 TechDB: Hi Brent could you pls brief the use case of CDC and Change data capture
• 07:11 Ricardo: What are your recommended questions to ask the potential employer in a DBA interview?
• 07:47 AG Avoider: Is it any kind of bad practice to use the same file share as an FCI Quorum witness and as your log shipping storage?
• 09:02 Daniel: A third party application inserts millions of rows to mssql one by one. How to optimize the speed export process if a client code cannot be changed? I’m considering using memory optimized non durable tables and then move data to standard ones.
• 10:26 gserdijn: Hello Brent. One of my servers has almost 20% stolen memory. Any pointers how I can find the culprit? A friendly person suspects it might have something to do with large, mostly unused, memory grants.
• 11:58 MyTeaGotCold: How can I keep on top of columnstore maintenance when measuring fragmentation takes too long? My columnstore indexes are partitioned and huge, so Niko’s scripts take 20+ minutes per index to report fragmentation.
• 12:54 Srinivas: In Query Store reports , large number of system queries (Microsoft related) shows up . For example queries with high CPU . Is there a way to bypass these in GUI . Is there any way to improve system queries by creating indexes or statistics ? Require more filtering options in QS
• 14:47 Ben: Hey Brent, What are your thoughts on SQL Server on Linux? Have you seen much adoption, and do you think it’s a good direction for SQL Server?
• 15:41 NotARealDBA: My app has an EF query that pages on a complex subquery. SQL will produce a Top N Sort operator if I inline the paging variables, but parameterized it requires a Top-Sort which spills and kills performance. Is there anything I can do that doesn’t require fighting EF? Thanks 🙂
• 17:15 Jonathan: Hey Brent! Just curious—do you have a college degree, or did you go a different route into tech?
• 19:20 chris: The company I work for blocks all of the AI providers as well as Copilot and even sites such as Notion which have a paid AI option available. Do you think their stance on these tools may change as they become more embedded with the way people work?
• 20:14 I’mTrying: Given that new versions of SSMS and drivers are opting for security by default, are companies moving towards using CA signed certificates on their SQL Server instances? If it is best practice how are enterprises managing hundreds of SQL Servers and expiring certs?
• 21:27 Potato with an e: I’m a new employee(a dev, not dba) and the DB’s have nolock hints all over the place. Eww. No RCSI. I brought up implementing RCSI and they said you can’t implement RCSI without removing all no locks first. Any techniques for continuing the conversation?