Office Hours: Ask Me Anything About Azure and SQL Server

Forgive my hoarse voice, recovering from sickness this week. I went through your top-voted questions from pollgab.com/room/brento. Here's what we covered:
00:00 Start
03:03 DBANoob: We have EF code that creates randomly generated temp table names every time it runs, while the rest of the logic remains the same, giving thousands of single use plans. I've tried warning the devs about this, but no luck. Any classes cover this? Any fixes I can try on my end?
03:35 Dom: Hi Brent, you often mention San backup for VLDB. I googled but wasn't able to find information about how we could do PIT recovery with San Snapshot backup. Is it possible ? Thanks ! P.s. Big fan of your work !
04:14 Bruno: Is it safe to install the microsoft ace ole db provider on SQL Server so that SSIS packages targeting excel files will function?
04:59 MyTeaGotCold: Do you still send out the 6-Month DBA Training Plan on Wednesdays? I don't think I've seen one in months.
05:13 KyleDevDBA: Hi Brent, You recently mentioned Cercle for when you need to focus. Does it ever have the opposite effect and you end up staring at the beautiful scenery for an hour?
05:58 Pepé Le Pew: What are the top smells that a given sql agent job is really application logic that should be moved elsewhere?
07:05 Scooby: Is that Beany in your mastering slide deck?
07:24 Ezra: How do you perform automated tests with the first responder kit?
08:22 Persephone: How would you rate ChatGPT's ability to explain what a complicated piece of TSQL code is doing? Will this end the need for users to document their TSQL code?
09:17 Darth Insidious: Inline TSQL comments using -- syntax instead of /* are insidious since the extracted single line TSQL can't be auto formatted for multi-line. Do you know of any good tools that can strip the -- comments and replace with /* comments ?
09:56 Montro1981: Hi Brent, Happy New Year to you and your loved ones.
Are there any things to look out for or "gotchas" when a database has both RCSI and Snapshot Isolation enabled?
10:47 RacerX: Do the parallel racing stripes in estimated query plan operator indicate that parallelism will also be used in actual query plan operator as well?
11:25 Guðmundur: Hierarchyid appears to be a CLR data type. Do you see any common performance issues with this data type on large tables?
12:27 Bruno: Thanks for all the tooling / training you provide for the SQL community. Looking forward to future training.
12:40 DBA_Todd: Hey Brent! When enabling Accelerated Database Recovery, is it best to change the location of the PVS to a different filegroup? If so, why, and should I put it on separate storage from the primary filegroup? I have a 4TB db running SQL 2022 on Azure VM.
14:59 Prisha: What are the best methodologies for adhoc copying a single (hundred million rows) SQL table from production to development?
15:29 Giannis M: sp_Blitz is reporting system db's located on C drive (master, model, msdb). Is it low or high risk to move these DB's?
17:05 kansas4444: Hi Brent, What's your opinion on _UTF8 collation to replace nvarchar by varchar ? I've translations tables where the PK is composed of the culture code and the parent key. Copying the table with a varchar column in UTF8 reduced its size from 10 GB to 4 GB for ~4 million rows.
17:59 Sigrún: We update stats nightly but even still there are some tables that will auto update stats during the next day due to high frequency of activity. Do you have guidance as to when you should you should disable auto update stats for a given table and do it manually?
18:53 The Blame Bus Driver: Is there a good way to know who last modified a given SQL agent job?

[@MiningForPies]

Ran ACE OLEDB on SQL box for last 12 years. No issues

[@TS-kb6sd]

You often indicate just how expensive SQL Server is, so I was surprised to hear you recommend running SSIS on a separate VM since that will require it's own SQL licensing.

[@BrentOzarUnlimited]

Yes, but you can use Standard Edition and license SSIS by the core, or you can license SQL Server at the VM host layer and then run tons of VMs on it.

[@rebornfenix4412]

3:03 I use that same sort of pattern when making large updates/ inserts of data through EF. Before EF 7, the best way to get performance was to create temp table then merge since ef would update one row at a time. Want to update 200 rows and get any performance? Use a temp table then use set based update queries to join the temp and actual data table.

[@Kane0123]

Giannis is in shambles right now.

[@BUY_YOUTUB_VIEWS_d0dd115]

I played this at my job orientation, and now it's part of the company culture