Di8l34scpsgr0loqnopu
SkillsCast

DevOps, Dev Data and Data Breaches: 5 Solutions

25th April 2019 in London at CodeNode

This SkillsCast was filmed at London SQL Server April

SkillsCast coming soon.

It’s an age-old problem: developers want prod data for dev and test purposes. It helps them to write better code and to test it effectively. Self-service access to usable test-data aligns well with DevOps principles that encourage teams to adopt a shift-left mentality to testing. Unfortunately, in the age of data breaches and tighter regulation it's unwise to give developers access to some types of sensitive production data.

So what do you do? In this session I’ll talk about the GDPR, anonymization, pseudonymization and 5 techniques you can use to provide appropriate data that is as “production-like” as possible (within the legal and technical constraints). I’ll demo these techniques both in raw T-SQL and using some of the Microsoft and third party tools that are available to make the task easier. After this session you’ll be equipped to discuss the problem with your colleagues in an informed manner and you’ll be able to suggest several solutions and their relative pros and cons.

YOU MAY ALSO LIKE:

Thanks to our sponsors

DevOps, Dev Data and Data Breaches: 5 Solutions

Alex Yates

Alex Yates Director, DLM Consultants Alex Yates has been helping organizations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organizes SQL Relay, is the founder of www.SpeakingMentors.com and has been recognized as a Microsoft Data Platform MVP since 2017.

SkillsCast

SkillsCast coming soon.

It’s an age-old problem: developers want prod data for dev and test purposes. It helps them to write better code and to test it effectively. Self-service access to usable test-data aligns well with DevOps principles that encourage teams to adopt a shift-left mentality to testing. Unfortunately, in the age of data breaches and tighter regulation it's unwise to give developers access to some types of sensitive production data.

So what do you do? In this session I’ll talk about the GDPR, anonymization, pseudonymization and 5 techniques you can use to provide appropriate data that is as “production-like” as possible (within the legal and technical constraints). I’ll demo these techniques both in raw T-SQL and using some of the Microsoft and third party tools that are available to make the task easier. After this session you’ll be equipped to discuss the problem with your colleagues in an informed manner and you’ll be able to suggest several solutions and their relative pros and cons.

YOU MAY ALSO LIKE:

Thanks to our sponsors

About the Speaker

DevOps, Dev Data and Data Breaches: 5 Solutions

Alex Yates

Alex Yates Director, DLM Consultants Alex Yates has been helping organizations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organizes SQL Relay, is the founder of www.SpeakingMentors.com and has been recognized as a Microsoft Data Platform MVP since 2017.