SQL Server Administration and Maintenance

SQH06 Column Level Encryption in SQL Server

11/21/2013

9:30am - 10:45am

Level: Introductory

David Dye

Sergeant

Cape Coral Police Department

This session focuses on using T-SQL to natively encrypt data in a SQL Server database. SQL Server 2005 introduced cryptographic services native to SQL Server which provides the ability to encrypt data natively without having to rely on client side code or extended stored procedures. The primary focus of this session will be to provide real life examples of when and how to encrypt data natively in SQL.

You will learn:

  • Architecture of cryptographic services in SQL Server
  • To create and back up a master key
  • To create a certificate using T-SQL
  • To encrypt and decrypt data using T-SQL