Do you know to encrypt in SQL SERVER? #sql #sqlserver #database #dba #data #ssms #developer #encrypt

Do you know how to encrypt data in SQL SERVER ?
Check this out:

ENCRYPTBYKEY () - Encrypts data by using a symmetric key.

KEY_GUID () - Returns the GUID of a symmetric key in the database.

OPEN SYMMETRIC KEY () - Decrypts a symmetric key and makes it available for use.