How much overhead does encryption add to a SQL Server query

If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.

Symmetric Key Use

Understanding the importance of key length with the SQL Server asymmetric encryption algorithms

K. Brian Kelly is trying to use SQL Server's built-in encryption and sees there are three different options available for an asymmetric key, corresponding to key length. What's the impact of the key length?

TDE Setup

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.