Cheers

That might be it. Certainly there's a bit of mystery for me in how this actually happens.
I think the SSL implementation is a little hokey in SQL Server and...

Perhaps. I think Excel is great in many ways. More, I think the idea of programming as a part of basic applications is a bad idea.

This doesn't quite make sense. You're using data compression, but you can't install SQL 2016? Or do you mean you want to install SQL 2016, but can't on Windows 7?

Compression takes extra CPU. Typically this loss of CPU cycles is made up for by reducing I/O, but that would be something you'd have to test with your system and...

Big hole. The idea with Always Encrypted is that the server is untrusted, the clients are. If you want to implement something, I'd suggest that you use an external application,...

Can you query sys.availability_databases_cluster?

Do you mean data captured from SQL Audit? Or do you mean track all activity that is executed through SSMS? If it's the latter, you can set up some auditing/extended...

Please script the code for the creation of your database and post it.

This may help you to query the default trace: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

I'm not sure what you mean here. What is the query going to look at? Are you thinking some query can look backward at activity in SQL Server? Are you...

Adding production to VCS is usually a bad idea. Your version control might be in flux, and there are potential issues if you end up syncing production with the VCS....

SET NOCOUNT OFF
;
SET ROWCOUNT 0
;
DECLARE @StartDate DATETIME
;
DECLARE @EndDate DATETIME
;
SET @StartDate
  = DATEADD(
      d
     , DATEDIFF(
          ...

Or PowerShell. Copy-File will help you.

My only suggestion here would be to load this into a table and add a row_number(), which will give you some ordering. As this appears to be a one time...