SQL Server Cryptology – A Primer
So, you got told you need to encrypt "the database". Now what? There are many reasons to encrypt your database. You might have to comply with HIPAA or PCI DSS, or you might just have generally sensitive data. Correctly implemented Encryption is one of the best protection mechanisms available today. But, how do you do it "correctly"? Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the beginning DBA, you will learn the difference between symmetric and asymmetric encryption and discover what a cryptographic one-way hash function is. After exploring the different encryption types and their definitions, you will be able to observe SQL Server cryptography in action, including encryption, decryption, transparent data encryption (TDE) and hashing. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies. After attending this session, you will be able to: • Explain the difference between symmetric and asymmetric encryption. • Select the right cryptographic technology for your special security requirement. • Implement these in your SQL Server environment. To benefit from this introductory session, you should feel comfortable writing simple SELECT statements.
- Not Interested