[Video] Office Hours in Zhengzhou, China

I’m back at the People’s Park in Zhengzhou, Yves’ hometown, watching retirees be active while I lounge around and take your top-voted questions from https://pollgab.com/room/brento.

Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are sold.

Here’s what we discussed:

• 00:00 Start
• 01:15 DBAInAction: Hi Brent, is running DBCC CHECKDB on a sync secondary in AG safe for a 25TB DB, or will it delay trans commits? We run on async now, but keep hitting tempdb full errors on full CHECKDB vs PHYSICAL_ONLY. Any recommendations for running integrity checks at this scale? Thank you!
• 04:05 G Dog!: Any advice on DBAs laid off right now? How do we make sure we stand out and what can we potentially transition into or focus on learning to keep us resilient.
• 05:43 chris: Hi Brent! As a development DBA, how would you recommend I leverage AI to make myself more valuable to my employer?
• 07:35 This question got me out of bed: What metric reveals that my user workloads are bottlenecked on tempdb? I already know that my tempdb latency is high, but I can’t see that it is impacting users.
• 09:21 Gary: What is your sense of how popular Dynamic Data Masking is across companies? Does it get good adoption or is it another dead feature?
• 11:23 Bibi: What new stuff can we expect to see in the new Mastering Server Tuning class over the previous version?
• 13:45 DBA: Been a DBA, fixing servers proactively for 10+ yrs. How to explain to my supervisors that I will be able to provide better value to the company if I move under BI team since I have experience with a proprietary ETL tool for healthcare which BI team uses, SSIS packages along? TY.
• 15:56 Sir Index Alot: Have you used AI to build SSRS / Power BI reports? What was your experience like?
• 17:35 Lazarus: Will we see a Brent Ozar chat bot that answers SQL DBA questions?
• 19:20 Jersey: I found a very long running query on my SQL server using SP_WhoIsActive @get_plans = 1. The results from WhoIsActive did not include an execution plan the bad query but did for other queries that were running. What does that mean? (Query runtime:
• 30:14, CPU: 1,786,805, READS 4)
• 20:23 Elwood Blues: Migrating from SQL 2019 Ent single server to 3 node SQL AG. Worried about write performance in AG. How do we perform a realistic perf test in AG before rollout? We peak out at 12000 transactions per second
• 22:29 Zeno: When were you first introduced to stoicism? How has it helped you?