GilaMonster (7/15/2014)
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 amount of thought, consideration and design. Otherwise you can end up compromising performance without actually gaining anything security-wise. You also need to have analysed threats and identified exactly what you're trying to protect against.
ok, I need to find a link for dummies. One that has an example of encrypting and decrypting the same column.
Sorry.
Has anyone done this? Does anyone have any code that they can share?
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/