I predict useful information posted on June 31

My apologies, as this one had poor wording. I should have specified one connection from one application.

Points awarded back and the question clarified.

Good luck. I'd be interested in what you choose and how it works. We need more information and patterns for good testing.

TDE is an Enterprise only feature, so it cannot be enabled on SQL 2014 Standard.

You need to define that columns, and provide some results that you'd like to see. It's hard to guess exactly what you want. If you give us input and output...

You aren't unit testing if you look at the full load. That's more of a system test.

There are unit testing frameworks, SSISTester and LegiTest...

Easy to test. Have a process, SQLCMD batch works fine, that constantly adds data, maybe every second. Crash VM, see where you are with data. Or see how long to...

If you want to change rights, use a group, the service account group for SQL, not the account.

You'll need to provide a little more information or details, some DDL and data.

TDE will show as encrypted until restart, because part of it may be encrypted. No one will likely check, and evidence will be erased once the instance is restarted.

I'm not sure you can upgrade those SQL 2012 Standard to 2012 Enterprise. If you can, I'd be interested to know. You can upgrade to SQL 2016 Enterprise, though you...