March 2018
Intermediate to advanced
816 pages
19h 35m
English
SQL Server encryption options start with backup encryption. This encryption was introduced in version 2014. You can encrypt data while creating a backup. You need to specify an encryptor, which can be either a certificate or an asymmetric key, and define which algorithm to use for the encryption. The supported algorithms are AES-128, AES-192, AES-256, and Triple DES. Of course, you also need to back up the encryptor, and store it in a different, probably even off-site, location from the backup files. Without the encryptor, you can't restore an encrypted backup. You can also use EKM providers to store your encryptor safely outside SQL Server. Actually, if you are using an asymmetric key as an encryptor ...