It is becoming more and more important to protect your data from anyone that should not access it, including the DBA. Learn how you can use column level encryption as well as TDE to protect your data files, with minimal performance impact to your SQL Server instance.

This session will look at securing data

• in flight
• at rest
• inside the database

We do this with

• IPSec/SSL Communications
• Transparent Data Encryption
• Partial Hash Bucket values with symmetric encryption.

Slides:

• SQL Intersection Spring 2014 – EncryptionPerformance.pptx
• DevConnections Fall 2014 – EncryptionPerformance.pptx

Code:

• SQL Intersection Spring 2014 – EncryptionPerf.zip
• DevConnections Fall 2014 – EncryptionPerf.zip