TDE Setup

Securing SQL Server: Vulnerabilities You Might Not Have Considered

A short look at the vulnerabilities your data may be susceptible to outside of the database tables.

Data Insecurity: A Perspective on Data Encryption

The focus of this paper is on the protection of PII data stored within a database using encryption technologies.

Encryption

SQL Server Column Level Encryption Example using Symmetric Keys

With data stored in tables, you have a few options to protect data. Check out this tip to learn more about column level encryption.

Column-Level Encryption in SQL Server

Beginning with SQL Server 2005, column-level encryption and decryption capabilities were made available within the database, providing a solution for situations where one-off types of data need to be secured beyond your existing authorization, authentication or firewall settings. This article provides an overview and example of securing a column using native SQL Server cryptography functions.

Encryption

TDE, EKM and the Asymmetric Key

A look at how you might recover from a disaster using encryption and an HSM module in SQL Server 2008.

SQL Server Encryption Symmetric vs. Asymmetric Keys

I need to encrypt my data within SQL Server and I plan on using the built-in encryption functionality in SQL Server 2005 and 2008. However, I'm looking at symmetric and asymmetric key algorithms and while I see information saying to use symmetric keys, I don't understand why. What's the difference between the two and why is a symmetric key algorithm preferred over the asymmetric key ones?

Encryption