Level: Intermediate

Bradley Ball

Sr. Consultant – Premier Support for Developers

Microsoft

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