SQL Server Features and Components

SQT02 Encrypting Data in SQL Server


9:30am - 10:45am

Level: Introductory to Intermediate

David Dye


Cape Coral Police Department

What steps do you take to secure your data at rest in SQL? Are you bound by governance or oversight that requires you to secure data in SQL? Do you store credit card numbers, social security numbers, medical information, or any other sensitive private information? If you answered yes to any of these questions, then this session is for you.

Cryptographic services were integrated into SQL Server in 2005. With this functionality, we were first introduced with the ability to natively encrypt data within a SQL Server database. This session will focus on the technologies native to SQL Server that help you protect your data "at rest." You'll get an overview of SQL Cryptographic Services, as well as step-by-step instructions on encrypting column level data as well as transparent data encryption for an entire database.

You will learn:

  • About Cryptographic Services in SQL Server
  • How to backup and alter the service master key
  • How to create asymmetric keys, symmetric keys, and certificates
  • How to encrypt and decrypt column level data
  • How to enable and disable transparent data encryption