In the context of the GDPR and data breach epidemic, I spent about 50% of my time from Nov 2017 until May 2018 supporting Redgate customers to manage their data privacy concerns. It was a great learning experience for me and I’m looking forward to doing plenty more “compliant DevOps” work during the rest of 2018 and 2019. I’ve also…
Data Privacy
Simple query to return columns that have been classified as sensitive in SQL Server
A few months back, in response to new regulations like the GDPR and a growing concern about data breaches and other data privacy issues, Microsoft released a new data privacy feature in SQL Server Management Studio (SSMS). Since SSMS 17.5, users have been able to use new classification functionality that sniffs out any of the columns on your database with…