Kyoto feels like a timeless, classic version of historical Japan with quiet tree-lined streets, giant temples, and bubbling brooks. It’s the exact opposite of last week’s experience in noisy Osaka! Last year, I filmed in Kyoto outside a temple, and this year, I’m at another temple just after New Year’s, the time when Japanese folks traditionally go to visit their many gorgeous temples.

Let’s chill here and go through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

• 00:00 Start
• 01:52 Hany: Hi Brent, have you ever seen Table Partitioning cross the finish line for database performance problem? If no, then what could be the best case that suits Partitioning?
• 02:45 DBA in the Mirror: What problem does Database Mirroring solve that AGs without clusters do not?
• 03:42 Gonna be golden: How many DBAs do you typically see at a shop when running SQL AG? Can it be done with one DBA?
• 05:23 SQLSerenader: Hi Brent, is there any benefit to using distributed availability groups (2 two-node AGs in different DCs) for DR over just adding an additional third asynchronous node to an already existing two-node AG? The third node would be in a different data center.
• 06:55 AccidentalDBA: What causes SQL to hold a buffer latch?I’m working with devs to fix a query that causes a buffer latch on one table and holds it until we restart the instance. Trying to rewrite and add an index in hopes of fixing (MSSQL 2019).
• 08:08 Dopinder: Do you like any of the AI engines for decoding the SQL Server xml deadlock graph and making remediation recommendations?
• 08:58 MyRobotOverlordAsks: My company announced during some AI training that within the next 12 months we won’t be writing any of our own code. Instead, we’ll be babysitting agents. What’s your opinion on this from a DB dev / DBA POV? MSSQL Dev tends to lag, so I’d personally be surprised.
• 09:55 Brave Sir Robin: What’s your opinion of the open source SQL monitoring system, SQL Watch?
• 11:19 DBAGreg14: We have a sp that runs 6-8x per min, getting compile waits resulting in occasional rolling blocking from 10 secs to 2 mins in duration. How can I find the root cause about why the SP is getting compile waits? no specific stmt is blocking, getting the plan for the whole SP blks.