I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

• 00:00 Start
• 05:41 LongRunningBackups: You say to use SAN snapshot backups on larger DBs (multi-TB). I have searched “Ozar SAN Snapshot”, but your article has a broken link. Other searches don’t provide relevant results because “snapshot” is a common/overused term. Is this a Fundamentals or Mastering level topic?
• 06:52 Asking For a Friend: Follow up on the “Are cloud databases overrated” question Dec 1. No, the on-prem VM is not “free”, but it is a sunk cost since it already exists with many DBs, is licensed, is here to stay. Moving the db on prem simply eliminates monthly cloud costs. Does that change your answer?
• 09:17 TheMooneyFlyer: How often do you come across performance issues that cannot be solved by index, queries or server optimization but requires an application redesign? How do you manage this so your client is happy with your report?
• 13:22 Xavier R: If the software vendor is using inefficient coding techniques that impact application/DB performance. Where would you draw the line in helping them? I went as far as giving them a query (which solved a network timeout) to replace their nested stored procedures
• 15:37 Montro1981: Hi Brent, do you listen to music while working, and what is your favorite type of music you listen?
• 16:54 Renzi: Do you see any specific A.I. skillsets complementing SQL DBA?
• 19:27 Ömer: What are the top performance related features that you get in boxed SQL Enterprise that you don’t get in standard version?
• 21:03 Kemal: Do you have any suggestions for how to load test TempDB on a prospective new cloud VM?