Column level Encryption

Gagan Sharma

8y1k

What are the different ways to encrypt columns in sql server?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
Not sure what you want to do? but one of the best ways specially in the BI world is
HasgByte MD5
https://docs.microsoft.com/en-us/sql/t-sql/functions/hashbytes-transact-sql

Good luck
Sagar Pandurang Kap8y ago
Hi,
Try below links :-

https://msdn.microsoft.com/en-us/library/ms179331(v=sql.105).aspx
https://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/
http://www.c-sharpcorner.com/article/implement-column-level-encryption-decryption-in-sql-server-2016/
https://info.townsendsecurity.com/sql-server-column-level-encryption
https://www.databasejournal.com/features/mssql/article.php/3922881/Column-Level-Encryption-in-SQL-Server.htm
https://stackoverflow.com/questions/15093775/encrypt-the-data-in-a-column-in-sql-server

Hope it helps.....
Guest User8y ago
https://www.red-gate.com/simple-talk/sql/sql-development/encrypting-sql-server-using-encryption-hierarchy-protect-column-data/
Guest User8y ago
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data