SQL Server 2008 Transparent Data Encryption
Transparent data encryption encrypts the database file at the page level. The pages are encrypted before they are written to disk and decrypted when read into memory.
TDE provides the ability to comply with many laws, regulations, and guidelines in various industries. This enables software developers to encrypt data by using AES and 3DES algorithms without changing existing applications.