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.
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. We'll look at the new features, why you should consider them, where they work, and where they don't.
Discussion topics will include:
• Data Categorization and Classification
• Encryption; Transparent Data Encryption, Always Encrypted
• Data Masking
• Row-level Security
• Security Center and Scores
• SQL Assessment API
• Azure Defender for SQL
• Vulnerability Assessments
• Advanced Threats
○ SQL Injection
○ Data Exfiltration
○ Information Protection
○ Anomalous Login attempts
• Monitoring and Alerting with Azure Services
• Azure Data Explorer

Attendees will leave this session with an understanding of the following:
• How to find and assess data assets, using modern tools and techniques
• How to identify and tag sensitive data
• How to perform cost, benefit, and risk analysis on threats and solutions
• How to deploy features in the right location to best protect data
• How to leverage security services to protect data
• The day will include lecture style format as well as interactive discussions and lab exercises.