[Video] Office Hours: Car in the House Edition

Today I’m hanging out in the dining room, or what would normally be a dining room, but we use it to store a 1992 Honda Beat. I explain why, and then take your top-voted questions from https://pollgab.com/room/brento. The audio on this one is a little tinny – the room is super-echo-y and I don’t think the camera picked up my lapel microphone. Sorry about that!

• 00:00 Start
• 01:37 RollbackIsSingleThreaded: Hi Brent! The editor says my articles are “edge cases” and prefers topics with mass appeal. I enjoy writing advanced SQL Server articles, such as “Avoiding Plan Cache Bloat,” rather than beginner articles like “How to Download SSMS 22.” How should I proceed?
• 03:06 Rey Q&A: I recently watched one of your videos where you said that enabling in-memory OLTP on a database is a bad idea because it causes persistent performance issues. Does that mean that there’s no practical use cases for the feature?
• 04:42 retired dba: My last employer wanted to consolidate several vendor supplied db’s under 1 server. My previous employers never did this (possible resource contention, security issues, upgrade issues, problem/bug reporting/resolution etc.). What say you?
• 06:02 Bibi: Do you think regular SQL Server will ever get the auto index tuning that Azure SQL DB has or is this feature more of an enticement to get users off traditional SQL Server and into Azure SQL DB?
• 07:15 AllOnSSDs: Under what conditions, for a database on all SSDs, would you recommend reducing the fillfactor on an index?
• 08:15 Logzilla: Our OLTP app runs on AWS RDS SQL Server Multi-AZ. Transactions take ~40 ms, but every 5 minutes latency spikes to nearly 1 second for all requests, apparently during log backups. How can we confirm the cause and reduce the impact?
• 10:33 Serhat: Our dev team put too many NC indexes on a given table despite DBA warnings. Is there a good way to quantify the impact of too many NC indexes for a table?
• 11:36 Lazarus: Do you see many clients with certs on their SQL Server? Is it really necessary behind the firewall?
• 12:40 Sir Index Alot: What are your favorite use cases for Copilot in SSMS?
• 14:19 Dopinder: Does upgrading from SQL standard edition to enterprise edition require a reinstallation? Any risk in doing this?
• 15:35 Bibi: What was your experience with natural language query for SQL Server back in the day? How was it secured? Will we see it make a comeback now that AI is more mature?