Melbourne SQL Server User Group


The Melbourne SQL Server User Group is a group for people interested in all things related to the Microsoft Data Platform. We run meetings every 3rd Tuesday of the month on topics ranging from traditional on-premises DBA topcis, to Business Intelligence topics to Azure and even the occasional Machine Learning topic. Or meetings normally run for around 90 minutes, with an initial half hour of networking and Pizza followed by one hour technical presentation.

Next Meeting




Data Classification and Masking: the What and How of Data Protection

Melbourne SQL Server User Group Meeting for October 2019

Featured Presentation:

Data Classification and Masking: the What and How of Data Protection

Martin Cairney, Lead Consultant Readify

As organisations make greater use of their data assets across multiple systems and environments, there is an increased risk of exposing unmasked sensitive data. This is particularly a concern when regulations such as GDPR are also in play. However, copies of data used in dev/test or in analytics need to be an accurate representation of the primary data so omitting, or doing a simple replacement of sensitive values, may skew any results. This session will introduce tools and processes that can be used to help protect your data. It will firstly show how the Data Classification utility in SSMS and SQL Server can identify and categorize your sensitive data. We will then see how dynamic and static Data Masking can be used to either hide sensitive data from selected users or to completely replace specific classifications of data with new values that both protect the source

About Martin:
Martin has 20 years’ experience in SQL Server technologies. His experience spans both the Database Engine and infrastructure requirements, and Data Warehousing and BI implementations. He's worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He is a SQL Server MVP, MCT and an experienced conference presenter, having presented at PASS Summit, SQLBits, and SQL Saturday events and User Groups round the world

Back to Top