Support Encrypted Columns
15
votes
1 comment
-
Howard Hoffman
commented
The built-in T-SQL encryptbykey() and decryptbtkeyautocert() functions (including also decryptByKeyAutocert/DecryptdByKeyAutoAsymKey/DecryptByPassPhrase) are used by applications that need to store highly sensitive information.
We have an application that indeed uses these mechanisms to store highly sensitive information; we have some small customers that would benefit from cloud-based deployments. We cannot deploy all our features to SQL Azure without this functionality.