I wish more people did...

I liked this conversation. It reminded me about the number of hours I spent just watching my dad do something. As a farmer, he touched everything and made anything...

Lol, that's a crazy one.

I've edited the question to move those so it makes more sense.

Added to the explanation to clarify.

All stuff you'd likely not have time to do without an AI assistant, right?

Amazing where you can go using a helper.

Don't use "flavor" here. It confuses the issue. You can set database compatibility, as Jason noted, but that doesn't fix issues. MS doesn't always turn off things with dbcompat and...

Many people aren't allowed DBATools. Not sure why, as it's a great resource.

To be fair, the question asked for T-SQL, so shelling out isn't always the right solution.

No, newer features do not work. Most features are backwards compatible, but if the feature didn't exist in 2019, it won't run there.

And speaking of articles........ anything new on your mind? Maybe an opinion piece/editorial?

Those are good hints to use.

The business case is rework. This is time-consuming and expensive. As Jason noted above, if someone uses a feature that isn't in prod, then this doesn't get detected until a...

I'm not completely sure what you're asking here. In terms of setup, I think you have:

1. Dev - SQL 2022 Standard on a VM (vm doesn't matter)
2. Prod - SQL...

I don't believe so. You might be able to force specific entries are set a certain way, but I don't think you can edit an entry, as you're asking.

If these...

I was an apple person and thought they'd rule the world.

You've incorrectly tested this. The question stores data as strings.

try_parse isn't for numerics