Encrypt and Decrypt the columns in table – SQL Server 2005

In a company have been asked to encrypt the few critical table columns contains containing sensitive data like Credit Card No, SSN even monthly generated payslip amount. Using SQL Server 2005 or 2008 we can encrypt data using different algorithms by creating symmetric and asymmetric keys. Continue reading


Understanding and Implementing Transparent Data Encryption (TDE) – SQL Server 2008

Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery.

Continue reading