Hello,
We have a database that will store PII and obviously want this data encrypted. I've looked at various methods of handling this, using keys in SQL Server itself, or encrypting/decrypting data at the application level. Is there a way to do both? For example,
if we encrypt data at the application level, we would want to be able to decrypt it at the database level for use in reports on SSRS, for example.
What would you recommend we do?
Thanks!
Go to the complete details ...