Got database questions? Post 'em at https://pollgab.com/room/brento and I answer the top-upvoted ones. Here's what we covered today:

00:00 Start
03:15 Mattia Nocerino: I've always ignored database t-sql snapshots. What are good use cases, if any?
05:12 All.. Night.. Log..: Any recommendations for what to do when we hit high Tlog VLF count on our SQL AG cluster?
06:06 ProochingMan: Do you think learning R and/or Python can be useful for DBAs who function as production DBAs and who have to occasionally help with data validation for new systems?
06:54 TiredDBA: How do you feel about Multi-Factor Authentication connecting to SQL Server databases? Does this become a nuisance if a user wants to connect to multiple servers to run a query against?
07:57 InTheNameOfGod: Can you explain how to use SET XACT_ABORT ON; and should we use it with BEGIN TRY and also BEGIN TRANSACTION; ? Am I the only one confused here?
09:17 Help Help Me BrentO: We have an issue where plan age in the plan cache is less than 30 seconds. When this exists, performance is poor. When the cache cleared, the plan cache age continually grows and performance is good. This lasts for 10 min before the issue starts again. What should be looked at?
10:45 Pseudo Echo: Now that ChatGPT can answer many coding questions, will this impact the quality / difficulty of the fewer questions that actually make it to Stack overflow and DBA stack exchange?
11:44 Rebel Girl: What are your thoughts on putting the SQL system DBs on their own dedicated non C drive? Good, bad, overkill?
12:45 Mattia Nocerino: I've inherited a server where previous full backups are restored once a day. BI asked me to improve restore times, so I've left dbs in standby and restore diff + logs (basic tlog-shipping I guess). I'm noticing high variance in restore time, from 90 to 30 min. Is this expected?
14:50 MyTeaGotCold: Have you recommended DBCC CLEANTABLE at any point in the last ten years? Even if you truly need it, why not rebuild the indexes instead?
15:12 Coffee Badger: What are your thoughts on Amazon's 5 day in office work week policy?
16:11 Queen B: Does anything bad happen if you don't prune your backup history for boxed SQL? What job normally does this?
16:59 boersp: With Veeam and all the other SQL backup agents, do you still recommend SQL backups via maintenance plans? Or are the 3rd party backups good?
17:58 Maximus: What are your recommended resources for learning stoicism?
19:02 Hal: Will we see AI mental health counseling in the near future?
20:01 StatsDontLie: My friend is getting an error on updating statistics on a read-only copy of the database on a user-defined table. Updating stats on the read/write database doesn't fix the issue, neither does more coffee, help!
21:06 Tommy Tutone: What are the top issues you see when migrating SQL FCI VM from single subnet to multi subnet?
23:07 DBA-Team: Are you frequently using the Vision Pro? Or was it nice at first but not so useful now?