Join Pete Zerger for an in-depth discussion in this video What is SQL "Always Encrypted"?, part of Microsoft Cybersecurity Stack: Securing Enterprise Information.
- [Instructor] Now we're going to dive into…protections for structured data.…That is data stored in various types…of Microsoft SQL databases.…SQL database secures data…by providing encryption for data in use,…using Always Encrypted.…Always Encrypted is a client-side encryption capability…that enables the application to encrypt data…so the SQL server,…or the service if using Azure SQL,…can never see the data.…This is particularly useful for protecting content such as…social security numbers,…credit card data,…and private health identifiers.…
As a result, Always Encrypted provides a separation…between those who own the data and can view it…and those who manage the data…but should have no access.…By ensuring on-premises database administrators,…cloud database operators,…or other high-privileged but unauthorized users…cannot access the encrypted data,…Always Encrypted enables customers…to safely store sensitive data…outside their direct control.…This allows organizations to encrypt data…at rest and in use for storage in Azure,…
In this course—the third installment in the series—Microsoft MVP Pete Zerger demonstrates how to leverage the Microsoft cybersecurity stack to more effectively protect corporate information—on any device and in any cloud. Pete explains how to use Azure Information Protection (AIP) to protect information, as well as how to secure data on mobile devices. Plus, he covers identifying and controlling shadow IT, securing structured data in Azure, and more.
- Securing information on any device
- What is Azure Information Protection (AIP)?
- Configuring classification and labeling
- Classifying and protecting data in bulk
- Challenges of securing data on mobile devices
- Data loss prevention (DLP) on mobile devices
- Identifying and controlling shadow IT
- Securing collaboration and DLP
- Configuring dynamic data masking
- Protecting Azure SQL with SQL Threat Detection