Session Title: Two pronged approach to securing sensitive data on Azure SQL
Speaker(s): Sohini Garg

Abstract: Walk through two ways of securing sensitive data on Azure SQL:

  1. Dynamic Data Masking – examples of masking sensitive columns of tables using a SQL script. Include nuances of using the Custom String mask to handle specific email domains (like .gov, .edu etc) or SSN etc.
  2. Utilizing Row-level-Security to hide specific sensitive data in a table from users who are not authorized to see those rows, while all of the the users can see all non-sensitive rows.
  3. We will go one more step in depth about scenario b), where the table itself’s schema cannot be changed due to software constraints, and examine how row level security can still be applied.

Format of session: Slides followed by demo.

500+ sessions are now available on-demand from Data Platform Summit 2022, 2021 & 2020 at no cost. Browse all sessions.

Stay tuned, more learning coming your way.