there is a column (password ) in varbinary
MASTER KEY and SYMMETRIC KEY are given.
with that, what is the best standard:
1)should you encrypt the column(using syntax EncryptByKey(Key_GUID('SKName'), PassWordCol)) and let the programmers decrypt from stored procedures or
2)since every data access is done through stored prodcedures in this application, would you suggest not even to encrypt, and that encryption (inserts/updates) and decryption (SELECTs) both happen during DML.