Skip to content

The Encryption Primer

March 28, 2012

This talk deals with SQL Server encryption options. I have given a few variations, and you can get the different decks below.

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:

Slides:

Presentation Schedule

You can view the my speaking schedule here. The upcoming and past deliveries of this session are:

  1. Apr 27, 2013 – SQL Saturday #175 – Fargo
  2. Apr 10-12, 2013 – SQL Intersection, Las Vegas, NV
  3. Apr 9, 2013 – SQL Saturday #197
  4. Mar 9, 2013 – SQL Saturday #187
  5. Mar 7, 2013 – Richmond SQL Server User Group
  6. Nov 15, 2012 – Denver SQL Server Users Group
  7. Nov 13, 2012 – Boulder SQL Server Users Group
  8. Nov 5, 2012 – SQL in the City Seattle, WA 2012
  9. July 28, 2012 – SQL Saturday #144 Sacramento, CA
  10. June 9, 2012 – SQL Saturday #132 – Pensacola
  11. Apr 28, 2012 – SQL Saturday #131 – Phoenix
  12. Mar 26-29 – SQL Connections, Spring 2012

Related Blog Posts

About these ads

From → Presentations

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 4,636 other followers

%d bloggers like this: