SQL Server has a number of encryption features that allow you to better secure your data. This session will examine the basics of encryption and cover the various ways in which you can encode and decode your data to protect it from unauthorized access. Cell level encryption, Transparent Data Encryption, and backup encryption will all be discussed. This session is designed for those who want to learn the basics of how to protect their data.
This talk looks at the encryption options in SQL Server that are available, including the changes in SQL Server 2012. The agenda is:
- What is Encryption
- Encryption in SQL Server
- Transparent Data Encryption
- Hashing
- Symmetric Keys
- Asymmetric Keys
- Certificates
- SSL Communications
The presentation features basic demos of how these features are implemented in SQL Server.
Level: 200
Length: 60-75 minutes
Demo code: EncryptionPrimer.zip
Slides: EncryptionPrimer.ppt
Related Blog Posts
- Restoring a Certificate on March 5, 2012
- Backing up a Certificate on February 27, 2012
- Creating Your Own Certificates on February 16, 2012
- Backing up the Service Master Key on December 26, 2011
- Creating a Service Master Key in SQL Server on December 19, 2011
Filed under: Presentations Tagged: encryption, presentations, sql server, syndicated