A Techie's View on Meeting Compliance - The New World of Data Privacy

Explore a techie's perspective on meeting compliance in this 57-minute conference talk from PASS Data Community Summit. Delve into key terms and technical solutions to ensure organizational compliance. Examine what audit and compliance focus on, understand different types of controls, and learn about data classification, security, and encryption options. Discover SQL Server-related encrypted options, data obfuscation techniques, and dynamic data masking. Gain insights into structural changes and SQL Server's compliance options. Learn important points to remember when implementing compliance measures in your organization.

Intro
Technical Assistance
Agenda
What Audit and Compliance Focuses On
Controls - What are They
Verifying Controls
Important points to Remember
Types of Controls
The Three As
Data Classification Example
Data Classification - Deeper Dive
Data Security - Permissions Check
SQL Server Related Encrypted Options
Data Encryption - What Else?
Data Obfuscation
Dynamic Data Masking
What Do You Mean Structural Change?
What are SQL Server's Options?