In this advanced workshop, we cover data security and privacy protection for SQL Server and Azure SQL Database. With demonstrations and several exercises, this workshop uses group labs to cover database and data protection techniques, including threat analysis and remediation.

Modern database systems have introduced more support for security, privacy, and compliance over the last few years. We expect this to increase as compliance issues such as GDPR and other data compliance challenges arise. This session, include newer features from a data modeler/database designer's point of view, including:

Data Masking
End-to-End encryption
Row Level Security
Ledger Tables
Confidential Computing
Data Resiliency
New Data Types
Data Categorization and Classification
Monitoring and Alerting

We'll look at the new database and modeling tool features, why you should consider them, where they work, where they don't. We will also discuss how to negotiate on behalf of data protection in a world of Agile, MVP, Lean and DevOps.