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).
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
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.
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/
7:45 I didn't get it, who can explain?
Me neither
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).
HA!
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
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.
9:00 I suspect this will change soon. It's enabled by default in databases made as of SQL Server 2022.
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/
@@BrentOzarUnlimited Darn. You're right. Long live 2025!
Brent, your look in this video is awesome.
Aww,t hanks!
7:26 If you like both broccoli and cheddar cheese I have a very nice recipe for you.
WHO DOESN'T LIKE THOSE TWO THINGS TOGETHER?!? That's awwwwwwesome.