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

I think as Drew mentioned, you need a key created from your EKM provider. That would be something your EKM system gives you sample code on how to do this....

Two ideas here, but first, was SSMS installed with a different account than yours?

1. Your account lacks access to the RDL files used by SSMS
2. Your account lacks access to...

I'll certainly update the article with the link, as this might not be an issue, but still, exposing dev databases live is an issue. These are refreshed, and it's entirely...