• Article Topics

  • Become a member of the SQLDBASupport community and receive notifications of new posts by email

    Join 82 other followers

  • Are you writer? Become an Author! Mail to

    amitvaid81 @ gmail dot com

  • Founder

    This is journey of a SQL DBA. I now work as a Sr. Database Architect and Solution Consultant, generally in performance tuning, clustering or high availability. The opinions expressed herein are my own personal opinions through real time experience.

    Amit Vaid

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