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...

You can. I think i'd like to see this broken into a couple of articles that start slow and explain with examples how statistics work WRT distribution. Please let me...

Caching bug. They have deployed a cache buster...

I'm confused. Is this something you want from extended events, or are you trying to capture this in the T-SQL with the try..catch?

It's not quite clear what you're...

I like my crock pot