Prevent Tampering of Encrypting Data Using add_authenticator Argument of EncryptByKey

This article is one of several articles discussing some of the best practices for encrypting data. This article demonstrates how the @add_authenticator argument of the ENCRYPTBYKEY function can help prevent tampering with encrypted data.   Imagine the following scenario: The DBA is encrypting the salary column for all employees in such a way that people with authorization to access the table, but