That certainly needs some pressure from users to stop the practice

HA/DR can lower uptime with complexity. Loose coupling and independence can help. We could argue that spending time on a broken secondary v a broken primary might increase downtime, but...

I added a note to that effect, but since I just had numbers in the date, I was just thinking just numbers for the result.

We have a...

User blocked. Spam starts to catch up as we report things and Askimet learns what to get rid of. I'll try to look through a few posts and mark them.

Depending on tool ;). Redgate has a product that has a...

yw. It can be crowded during busy times, and certainly it's not quick, though in traffic it can be as fast as a taxi. I've had Ubers charge $22 from...

I don't know everything in there, and I keep finding things when I talk with developers. It's been an amazing product and I'll pass along the thanks.

LOL, Steve, for you I'd just keep logs and only delete those that had an end stamp > 12months old 😉

CREATE OR ALTER should be your syntax in 2016+

https://www.sqlservercentral.com/search/gaps+and+islands

No magic here. Version the rows, which creates a different resource load, or fix code.

Yes, you can add files. moving/removing, IIRC, takes a restart

Password management is still an issue. You can use one with a certificate as well, and use a similar schema.

You can also have code create a temp symm key for...

I'd set to 90 and cycle daily. Easiest and simplest way to find a file for a date.