THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Merrill Aldrich

Technical content about Microsoft data technologies. All opinions expressed are purely my own and do not reflect positions of my employer or associates.

Encryption Primer Session

For the November meeting, I was honored to be invited to speak at the Minneapolis PASS user group here in the Twin Cities. I put together a bit of an unconventional session covering the basics of hashing and encryption, but as an introduction for DBAs. We focused on how those techniques work technically, where they appear in SQL Server, and what they protect against - or not - from a security point of view. There was also some good discussion about what issues you confront when recommending which of the many encryption features (TDE, column encryption, encrypted backup, Always Encryped, etc.) to implement in your organization and why.

I did not actually demo the features in SQL Server. Instead we looked at hashing and encryption of values at a lower level using a PowerShell demo.

Deck and demos are attached. Enjoy! 

Published Tuesday, November 22, 2016 7:33 AM by merrillaldrich
Filed under: , ,

Attachment(s): EncryptionPrimer.zip

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Privacy Statement