[Video] Office Hours in the Backyard

It’s a beautiful Saturday morning in Las Vegas, and I’m in the backyard taking your top-voted questions from https://pollgab.com/room/brento. At about 10 minutes in, Beni comes to say hi, and I was confused as to why he wouldn’t come closer. Yves reminded me that usually when I bring Beni to the edge of the pool, I pick him up and pull him into the water with me, and swim around with him, hahaha, and he knows better than to come near me by the pool these days.

Here’s what we discussed:

• 00:00 Start
• 01:06 Bar next to the office does the breakfast tequila: What is your estimate for how many people in the English-speaking world are performance tuners at a level either at or beyond where your Mastering classes get them? Judging by YouTube and blog view counts, I worry it’s far under 20,000.
• 04:55 If gamers can…: If you somehow obtained a SQL Server 2025 decompile, what things would you look up first?
• 06:37 Fable 2: In the Postgres community, I hear a lot about sharding. In the SQL Server community, I do not. Why?
• 08:49 MyTeaGotCold: I see offerings that use cloud-managed Postgres for OLTP and their own software for OLAP. Databricks calls it their “lakebase” and ClickHouse just calls it “ClickHouse Managed Postgres”. Do you know of any collective nouns for these dbs and do you have any opinions on them?
• 10:41 TheCosmicTrickster: SQL Server has any number of parameters that can be tweaked. How often do you find you have to tweak any of them to resolve an issue? What is the most esoteric thing you’ve had to tweak?
• 13:51 TeaEarlGrayHot: I vaguely remember undocumented AAG tuning guidance (guidance in support case?) that helped AAG replication latency with low trans log bytes size, high trans rate, but without CPU, Disk or Network contention. I think it was “railcars” or “rails.” Do you know a blog I can find it?
• 16:47 Burnt out DBA: How do you deal with an enviro where users write reports against the DWH but it’s completely overwhelmed. We are always tuning queries/indexes and get good results but it feels like no sooner have we fixed it, users are throwing in new queries at a pace we can’t keep up with
• 22:52 Ethiopiawi: Hi Brent ,do you have any plan to add more advanced Postgres courses like we have for mastering sql server ? Thanks!