What's New in SQL Server 2012, For Database Administrators, For IT Professionals

SQT05 Transparent Database Encryption Inside and Out in SQL Server 2012


2:00PM - 3:15PM

Level: Intermediate

Bradley Ball

Sr. Consultant – Premier Support for Developers


Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out what it does and what it doesn't do, how it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), what the X.509 Encryption Standard is and why you should be careful of what you store and where, and other Advance Features as well as some tips on how to manage it.

You will learn:

  • What Transparent Data Encryption does and does not do within SQL Server
  • Tips and Tricks on how to maintain a large scale SQL Server Environment using Transparent Data Encryption
  • Scripts that will allow you to use and manage Transparent Data Encryption in your Environment