Uploaded September 2026 | Updated September 2026, 2 weeks ago
With the new regex support for Dynamic Data Masking, you can now provide better customized masks, protecting sensitive data while still meeting data requirements with minimal impact on performance.
✅ Resources:
Blog: DataModel.com
Newsletter: Data Security Notes linkedin.com/newsletters/teamdata-security-notes-7079878047797051392
About Karen Lopez: Karen is a senior project manager and architect with an extensive background in development processes and information management. She specializes in taking practical approaches to systems development. She has 20+ years of public speaking (keynotes, speeches, and demonstrations). She wants attendees to have fun, gain insights and take away inspiration for working with new technologies and methods.
She's known for her slightly irreverent and practical approach to IT training and speaking. She wants you to be part of #TEAMDATA.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram
📌 Let's connect:
LinkedIn: Karen Lopez, linkedin.com/in/karenlopez
Twitter: Anna Hoffman, twitter.com/AnalyticAnna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps
To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQLServer
✅ Chapters:
0:20 Intro to Karen Lopez
0:47 Scenario introduction - Bobbie Lookup, customer service representative
2:25 What is Dynamic Data Masking
3:22 How to decide between encryption and masking?
4:32 How it works
5:03 Demo of it in action
5:40 Dynamic Data Masking functions
6:35 New Regex masking capabilities
8:30 Masked with defaults
9:00 Masked with Regex
11:35 Demo with Regex
13:20 Best practices for how to set at user levels, etc
14:35 Beware - adhoc query access would still work
16:30 How it works with reporting, define it once
17:20 Wrap up
With the new regex support for Dynamic Data Masking, you can now provide better customized masks, protecting sensitive data while still meeting data requirements with minimal impact on performance.
✅ Resources:
Blog: DataModel.com
Newsletter: Data Security Notes linkedin.com/newsletters/teamdata-security-notes-7079878047797051392
About Karen Lopez: Karen is a senior project manager and architect with an extensive background in development processes and information management. She specializes in taking practical approaches to systems development. She has 20+ years of public speaking (keynotes, speeches, and demonstrations). She wants attendees to have fun, gain insights and take away inspiration for working with new technologies and methods.
She's known for her slightly irreverent and practical approach to IT training and speaking. She wants you to be part of #TEAMDATA.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram
📌 Let's connect:
LinkedIn: Karen Lopez, linkedin.com/in/karenlopez
Twitter: Anna Hoffman, twitter.com/AnalyticAnna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps
To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQLServer
✅ Chapters:
0:20 Intro to Karen Lopez
0:47 Scenario introduction - Bobbie Lookup, customer service representative
2:25 What is Dynamic Data Masking
3:22 How to decide between encryption and masking?
4:32 How it works
5:03 Demo of it in action
5:40 Dynamic Data Masking functions
6:35 New Regex masking capabilities
8:30 Masked with defaults
9:00 Masked with Regex
11:35 Demo with Regex
13:20 Best practices for how to set at user levels, etc
14:35 Beware - adhoc query access would still work
16:30 How it works with reporting, define it once
17:20 Wrap up
