[Video] Office Hours: Desert Database Q&A

I’m in the Lake Mead National Recreation Area today, hanging out in the triple-digit heat, to answer your top-voted questions from https://pollgab.com/room/brento.

Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are sold.

Here’s what we covered:

• 00:00 Start
• 01:25 SQLSerenader: We incurred an outage due to a poor plan that we couldn’t flush from cache. The resolution was to disable Parameter Sensitive Plan Optimization on that database. Due to the shortcomings outlined in your PSPO article, should we disable this by default for all databases on SQL2022?
• 03:05 Best of both worlds: How can I pass collections in from an application without either heavy parameter sensitivity on the collection’s size or the “option random recompile” downside of temp tables? The only way that I’ve found is TVPs with dynamic SQL injecting comments based on the collection’s size.
• 04:40 MeName: I’m a DBA. My manager is technically competent but shouldn’t be a manager. They’re abrasive, disingenuous, spin their mistakes, holds grudges, hoards knowledge, won’t approve training etc. Is this typical of tech managers, a tech culture issue, or found across all industries?
• 06:44 Bifido: When configuring SQL Maxdop should you look at Total logical cores or only total physical cores? This is SQL on azure Windows VM.
• 07:02 Jake: What are the consequences of having a table with too many columns? Is there a column count we should strive to stay under?
• 09:10 Chris Stoll: As a dba(mostly performance tuning), how can I best use AI in my workflow? Are there any blogs/videos on dbas using ai that would be informative?
• 10:23 Vinay: As a DBA, I’m facing reliability issues with SentryOne (false alerts, data gaps, and agent failures). What do you consider the best monitoring tool for SQL Server environments today? Can an AI-driven monitoring platform be built using SQL Server 2022 and modern AI capabilities?
• 11:33 Miku: Does server memory size become less important to SQL Server, if storage is on NVME SSD’s?
• 12:30 EagerBeaver: Hi Brent, thanks a lot for all your free help. Question – with DWH on separate server, what would be the best way to get data from multiple source databases from different server. Ideally not only once a day, but either continuously or in small chunks and from selected tables.
• 13:30 Notorious B.I.G.: What issues / risks do you see with multi terabyte SQL Server VM databases? Does compression solve these issues?
• 14:27 Sir Index Alot: Have you exposed SQL Server to AI via a model context protocol server? What was your experience like?
• 16:42 Bibi: When should you use plan guides vs query store force plans?
• 17:30 Miku: What are the top SQL Server issues you run into with filter drivers?
• 17:47 Make Backups Fun Again : Would you ever consider using FileTable over S3 type storage for a multi terabytes of documents and images?