Mostly, habit. datetime comes up first in intellisense, shorter to type, old habits.

I  go back and forth. I'm trying to be better with declarations like explicitly using datetime2(3),...

SQL Server Data Tools from MS has a cut down version of SQL Compare.

Erikur has a quick solution, but there isn't a easy way to determine match quality or partial matching of different lengths.

How do you decide when 123 matches 1234...

I'm not completely sure what your setup is. You've written some ambiguous pronouns in your description. Can you set up a repro at all? what if you leave the existing...

We used to do something similar here. We tested DBMail, and it works, but it's not a great use of the server resources if you need them for queries.
There...

Resources added to the article at the bottom

I'm torn here. On one hand, I think we need updates, and need some forcing of updates. Far, far too many people don't update and let systems languish for years....

I think you want to do this the other way. From what I know, which isn't a ton on the Temporal side, you want to join the tables first, then...

You're engaging in a technology version of insanity. Doing the same thing over and over, but expecting different results. Given a certain log backup strategy, you need a certain amount...

True, it could have been worse. And fortunately the tractor box scraper helped

While you lot were having fun, camping and cooking, I was out slaving in the driveway, replacing drain pipe. Digging through gravel is not fun.