Monday 9:00 AM - 5:00 PM · Room 340-341

Advanced Data Protection Strategies with SQL Server: A Hands-on Workshop

John Sterrett

CEO of ProcureSQL

This workshop equips developers and database professionals with the practical skills needed to implement robust data protection in their SQL Server environments. It creates systems where sensitive information remains secure even from privileged users like database administrators.

Through structured, hands-on exercises, participants will:

Discover and Classify sensitive data using SQL Server's built-in tools—establishing the foundation for a comprehensive security strategy

Implement Column-Level Protection through Dynamic Data Masking and Always Encrypted, including advanced scenarios with secure enclaves that maintain query performance while protecting data confidentiality

Deploy Row-Level Security to enforce granular access controls based on user context, ensuring proper data isolation and visibility

Establish Audit Trails to monitor and track all interactions with classified data, supporting compliance requirements and enabling security incident investigations

Throughout the day, participants will progressively build a secured database and a .NET web application, integrating each security feature into a cohesive solution. By the session's end, attendees will have developed a proof-of-concept that demonstrates enterprise-grade data protection techniques that satisfy security requirements while maintaining application functionality.