You don't encrypt columns. Get that idea out of your head, it's probably causing your confusion. There...

Jeff Moden (7/15/2014)

---

Lynn Pettis (7/15/2014)

---

OMG, how can someone who has been working with SQL Server for over 9 years still behave like an entry level DBA/Developer??

Whose turn with the silver...

Sorry, mine's already packed.

That's the exact article I would have given you as an example. See the other examples that it links to.

Bear in mind this isn't something you implement without a fair...

Why all the DISTINCTs Aspirant?

No. T-SQL, with the T-SQL encryption functions like EncrypByKey and DecryptByKey, or whichever of the similar functions you identify as meeting your requirements for protection, key management and all the...

They probably test on two rows.

Good luck. This isn't a technical problem, maybe get management involved. Yours and theirs.

There's nothing about the column which makes it encrypted. You would need to encrypt the values when you insert (eg with EncryptByKey) and decrypt the values when you select then...

Little better in some ways in 2014. Still should probably be avoided.

TDE is entire database encryption. Transparent encryption, data encrypted on disk, decrypted in memory. It protects against the theft of the data files or the backups. It doesn't protect columns....

Don't use the import/export wizard.

Script the objects, some will probably fail. Query the data bit by bit (filter on the clustered index of each table), some will probably fail. Recreate...

Might drop into the pub quiz briefly, but I won't be staying late. Will be way too tired (don't sleep on planes)

This is not repairable. You need to restore from backup....

Did the DB correctly switch into Emergency Mode?

There will be a message in the error log saying who did it (what login). And it probably is 'who'. SQL doesn't automatically switch databases to single user, either someone...

I'm on a plane. 🙁 Company wouldn't pay for the pre-con and wouldn't give me an extra day off to attend it.