Building Defense in Depth Using the Full Spectrum of SQL Server Encryption
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.