Office Hours: Lumberjack Edition

We go through your top-voted questions from pollgab.com/room/brento. Here's what we covered:
00:00 Start
02:53 MyTeaGotCold: Is BCP dead for both exporting and importing? When exporting, people seem to prefer not using SQL. When importing, people seem to prefer BULK INSERT or OPENROWSET.
03:51 ParanoidDBA: Hi Brent, Do you think query tuners need to have a background in SQL development in order to be effective? If so, what the is the best book or course in order to get up to speed?
06:01 mailbox: I'm currently a production DBA. I'm looking to increase Salary and Career prospects without moving to a consulting position. Should I try to get on a very big company, as they might have more high level positions available (Architects for example).
08:28 BobTheLobster: Good day, Brent! Have you seen any interesting forks of the First Responder Kit?
09:38 JanPL: Let's imagine for a minute a very unlikely scenario where users/devs blame DB for an issue with app performance without any proof. What would you share with them (other than error log from sql) to prove that db is working fine.
11:29 mailbox: Hey Brent, Are you planning on releasing a Fundamentals or mastering class on Stored Procedures? Also, What hotel do you recommend in Vegas?
13:13 Pytzamarama: Hi Brent. When we update our customers, we drop/create all procedures and triggers. Does this affect performance? If so, a stats update after that, could fix it? Thanx
13:47 Ricardo: What is a cheap cloud based sql server for demo's? We use chromebooks onto windows servers for work ... and this isn't for work.
14:47 Heiða S: For SQL Connect strings, what are the top app naming conventions you have seen in the wild?
14:57 RobDB: Hi Brent! I cant seem to find guidance for MAXDOP on a SQL Instance with multiple databases! E.g. box with 10 dbs, 4 cores. If MAXDOP is set to 4 can one query to potentially block all others from CPU time? Is MAXDOP 1 better for contention? Albeit we cant go parallel.
16:27 pete: Morning great Guru: I have a execution plan where everything works real fast and in a hurry EXCEPT the two place where Repartition Streams happens. Those nodes show .027s going into and 1:38s coming out and later 3:20s coming in and 5:09s going out. What should I do?
17:25 Stu: Do you pick your intro music songs or are they randomly selected?
18:10 Owl Kitty: How would you compare the SQL Community to the PostgreSQL community? Anything comparable to SQL Bits from PostgreSQL?
20:23 mailbox: Hey Brent, How Do I watch your streams live? How do people know when you are going to stream?
20:50 Pétur: Which SQL product is best for implementing query execution charge back to each customer in a multi tenant cloud environment: Azure SQL, Azure SQL VM, Aurora PostgreSQL?
21:44 Najibah : In canned SQL Server, what is the best way to determine which apps are writing to a given table?
23:14 Mr. Bean: Found a strange scenario where we paste the SSMS message pane stats into statisticsparser.com and after parsing it shows elapsed time of 00:01:36.615 but SSMS 19.2 shows elapsed time of 00:00:48 in lower right corner. What can cause this kind of discrepancy for elapsed time?
23:56 Dimitris: Currently using 'Optimize for Ad Hoc Workloads' on canned SQL. Can this hide high memory grant single use queries? If so, does SQL monitoring software overcome this blind spot?
24:47 BobTheLobster: Hello again, Brent. I read that the FRK isn't supported on Azure SQLDB, due to (I suspect) Microsoft reserving the right to change things whenever they want. Do you know of people that maintain at least some of your excellent scripts on Azure SQLDB and how they do it?
25:10 Kirk Saunders: Do you have a preferred method for tracking changes in a table that the app can then read (Order Status: Placed, Shipped, Delivered)? I am aware options in the top voted answer here (stackoverflow.com/questions/2...)
26:48 Kirk Saunders: Do you have any functions/keywords/tricks/tips you have learned recently that you find fun/cool/useful?
31:37 Nazanin H: Who is the Brent Ozar of Microsoft Fabric?
32:27 Alexey: sp_blitzfirst question. I am getting Forwarded Fetches/Sec High: TempDB Object. What is the best way to find those temp tables location in SPs on queries? the same issue with a heaps in DB. I would like to know which heaps are heavily used. Thank you!
32:32 Alexey: Is it possible to identify which query is hitting which CPU core?

[@FlaggedStar]

05:20 As I recall, Izkit's books are getting a little bit out of date now. T-SQL Querying is from 2015 so it's missing a lot (e.g. its chapter on In-Memory OLTP is based on the 2014 version). His easier book, T-SQL Fundamentals is still a good read but it's so basic that you should only touch T-SQL Querying regularly.
Have you read his book on Window Functions? I've had it unopened on my desk for years.

[@BrentOzarUnlimited]

I have indeed! I still need to reopen it whenever I do windowing functions though, heh.