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

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

Create a PK on all tables. Really, do this. There are exceptions, but 99.99% of the time, just make sure a PK exists.

ALTER TABLE dbo.audit ADD CONSTRAINT...

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...

What have you tried?

A few things to think about. When you note that something is in more than one  country, you're considering that it has appeared in more than one...

apart from the items above, begin and end are controversial. I like them, many do not. In any case, if you use them, you still want to ensure you have...

Good to hear. I'm getting stretched on some of these.

Luke, happy to have you submit some vendor neutral content if you'd like.

Sheesh, I don't know half the gents on my team. #$%#@#$ Autodraft. At least get me people who I've heard of before.

Work is seriously getting in the way of my...