Transparent Data Encryption enables data to be stored securely by encrypting the database files. If the disks that contain database files become compromised, data in those files is protected because that data can only be de-encrypted by an authorized agent. SQL Server performs the encryption and de-encryption directly, so the process is entirely transparent to connecting applications. Applications can continue to read and write data to and from the database as they normally would. Backup copies of encrypted database files are also automatically encrypted.
Implements strong encryption keys and certificates to secure data
Applications do not need to be modified to support Transparent Data Encryption
Enables compliance with data privacy regulations
Does not increase the size of the database