Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

The Encryption Primer

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


Filed under: Presentations Tagged: encryption, presentations, sql server, syndicated

Comments

Leave a comment on the original post [voiceofthedba.wordpress.com, opens in a new window]

Loading comments...