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.

don't worry about shuttles. You can take the train from the airport to downtown in the middle of all hotels. Easy to walk from there. Or super shuttle or Uber,...

There likely won't be side effects any different at 2017 with a straight upgrade v go to 2016 then 2017. When you upgrade, the compat level ought to say down...

I'd think you crossed some threshhold for the optimizer as well. These are the maddening problems in SQL Server. Positive no code has changed? I assume you have an older...

+1 to what Grant said. For the most part, pick the one you are comfortable with.

ADS is really nice as it's quick to start and use. Lacking some things I...