Comparison tech is the way to do this. I'd suggest SQL Compare, but any tool that does this will help.

Disclosure: I work for Redgate Software

If diffs are every day, then this would cover things. If there is a break between the full and first diff, which is how I see people set things up...

I have habits to use plural, but I've come to think singular makes more sense, especially in cases like Aaron listed where you create a join table.

This should be fixed.

12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.

In terms of your last question, changing logins makes changes in master. Changing users...

This help? Low memory? https://dba.stackexchange.com/questions/141236/failed-allocate-pages-fail-page-allocation-1

A few other links point to this.

It's such a wide platform now, I constantly find things that I've either forgotten were added, or never knew because of the changes.

Definitely an exciting time to work with data,...

You'd be wrong. You can change the data type of an identity property column to one of the types in the error. What you cannot do is remove the identity...

It can be a weird line here.

...

Now, is that being a hero, or just helping out where it was pretty obvious that help was needed? I could see arguments...

To be a "hero" means to never be able to take a proper vacation. Even if you're lucky enough to be granted permission to leave, there's always the risk...

This is one of the few places I have worked where that cannot happen (as stated) because all work is done by release.

The release dates are scheduled before that...

There is nothing "heroic" about establishing yourself as a lynchpin, keeping your co-workers in the dark about how things work, and then bailing one day for a better job.

Of...

You've got different configs or permissions in the instances. That's where things aren't working. I'm guessing the top one has some permissions on public revoked

Culture is the hardest part to change in DevOps, which is people. Process is hard, but getting people to question how they do things and adapt to what others do,...

What does myLogin look like as a login?

You're describing things, but many of us have seen for years, that descriptions can be incomplete, and you might do something, or have...