I'm a baseball guy. Played a good portion of my life, including 10 years as an adult. I've enjoyed the game, and while I appreciate the history, there are things...

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.