Office Hours: Database Q&A in Akihabara, Tokyo

[@corykeilig5183]

This guy just doesn't miss

[@sprtracing]

7:45 I didn't get it, who can explain?

[@francescomantovani3936]

Me neither

[@dameneko]

Oooh, my internal anime factory is getting all sorts of idea prompts now! There could be a Brent manga, about a sarcastic database sensei who dispenses SQL Server and life advice whilst traveling the world., The art style would be very Showa-era aesthetic. Then an anime adaptation, and then he could star in the "dorama" live-action version. I miss Japan. I want to go back and ride some trains, pet some cats, and visit where my mom used to live (Shizuoka).

[@BrentOzarUnlimited]

HA!

[@nedgrady9301]

Re the second question: 'Is it sensible to use query hints to stagger or test a migration to a newer compatibility level?' Answer: No because you'd have to hint all queries What I thought the questioner was getting at was 'doing it the other way around' e.g. * Pick out a few CRITICAL queries, add a hint for the current compat level (so they are "guaranteed" to stay stable after the upgrade) * Upgrade server compat level Now you're able to see how a compat upgrade would generally go with less risk to critical queries, and can migrate the more critical queries one-by-one ... which sounds like a good idea to me

[@BrentOzarUnlimited]

If you only have a few critical queries, that might work. I'd be interested in hearing more about an application that only has a few critical queries. Man, that'd be a fun job to have.

[@FlaggedStar]

9:00 I suspect this will change soon. It's enabled by default in databases made as of SQL Server 2022.

[@BrentOzarUnlimited]

Even today, years after 2022's release, it has less than 10% of the market share: www.brentozar.com/archive/2024/11/sql-constantcare-population-report-fall-2024/

[@FlaggedStar]

@@BrentOzarUnlimited Darn. You're right. Long live 2025!

[@ncoalhw]

Brent, your look in this video is awesome.

[@BrentOzarUnlimited]

Aww,t hanks!

[@AndrewCoffman-jq9ld]

When you're as big of a celebrity as Brent you have to dress the part too.

[@caparn100]

7:26 If you like both broccoli and cheddar cheese I have a very nice recipe for you.

[@BrentOzarUnlimited]

WHO DOESN'T LIKE THOSE TWO THINGS TOGETHER?!? That's awwwwwwesome.