How to implement GDPR with SQL Server &Azure SQL Database
summary
Maps five GDPR articles Article 25, 30, 32, 23, 35 to concrete SQL Server and Azure SQL Database controls and shows live configurations: enables Always Encrypted, TDE, Dynamic Data Masking, Auditing, Temporal Tables and firewall/AD auth, uses Data Discovery & Classification and Threat Detection, and configures key hierarchy and certificates. Demonstrates creating masked columns, a system-versioned temporal table, encrypting columns with symmetric keys and certificates, and turning on auditing — each step is runnable and tied to the specific GDPR obligation it meets.
AI-written summary · about
chapters (22)
- 0:00Introduction
- 2:40Agenda
- 3:55Database hacks
- 5:08User data
- 7:17Data Breaches
- 8:55GDPR Explained
- 11:38GDPR Articles
- 12:41Data Protection by Design
- 16:43Record Processing Activities
- 19:06Security of Processing
- 25:31Notification of Personal Data Breach
- 27:21Impact Assessment
- 32:34Discovery Configuration
- 32:52Data masking
- 34:21Temporal DB
- 35:46Sample Data
- 37:11History Table
- 37:46Encryption
- 38:41Certificate
- 42:01Closing the key
- 43:11Audit
- 44:01SQL Server Audit
related talks
23mThe GDPR impact in database project
39mdev.privacy: GDPR in a nutshell
40mUnderstanding the cryptographic controls in Azure SQL Database
44mEmbedding GDPR into the SDLC
32mDesigning secure Azure SQL Database solutions
23mdev.privacy: GDPR in a nutshell
01h 59mDeep Dive Workshop – Data Security and Data Protection
52mCompliance-as-Code: How to do regulated business using public cloud