Search This Blog

SQL Server 2008 Top New Features : Transparent Data Encryption

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