SQL Server will automatically uncompress the files. This is to ensure compatability.

As a near-senior citizen, I’d like to know how one goes about protecting and remembering 30 or 40 different accounts/passwords. Password vaults are only as secure as the password...

Enjoy. I think native intellisense is...

Hmm....seems we (or at least I) don't have the ability to flag posts as spam anymore. Other posts on that thread can be reported. What's the deal here???...

Seems like that works for me.

I think Eddie has it correct. Check with MS, but the general rule of thumb is that

a) you need SA

b) you cannot use the secondary for anything. No reads, no...

I think this will work, but you'd need to have named instances. You can't have things fail from 2016-> 2014. This should be like any other cluster that has multiple...

Might also look at sp_Blitz. These scripts are sometimes more helpful in debugging things: https://www.brentozar.com/first-aid/

I lean towards what bmg002 said. Without more info, hard to know what's wrong. Have you added other fields? When you get this message, do you check the PK/FK violations?...

Voted and commented.

No reason to push back on TDE. It's low impact, easy, and it prevents incredibly silly losses of data due to someone copying a backup file to the wrong place.

If the data is loaded and the log files keep growing to 100GB in Simple mode, there's not much you can do. Shrinking them makes no sense because they'll grow...

dbatools can do this, but SQL Server doesn't really have this. I guess the Data Tier Applications and the .bacpac extrat/import do this as well. I'd lean towards dbatools.

http://dbatools.io

I'd lean towards merge here as well, even though it feels like overkill. Doing this with triggers is complex, as you'd likely need linked servers and some sort of merge...

This help? https://social.msdn.microsoft.com/Forums/vstudio/en-US/a9f57da1-a3b2-48c5-b6f7-856a2222df22/fox-pro-odbc-driver-for-windows-10-use