I never empathize enough how much the welfare of my family relies on StackOverflow. Every time I receive help I…
Read MoreT-SQL
How to export all Views from a database
Friends don’t let friends use INFORMATION_SCHEMA, but… I know the whole diatribe about INFORMATION_SCHEMA and I would not join the…
Read MoreDROP and CREATE All Constraints
Notes This blog has become a notebook where I can write down queries that I will reuse later on. Have…
Read MoreOne size fits all Dynamic Data Masking
One size doesn’t fit all I can now define myself as an expert in Dynamic Data Masking. I’ve used all…
Read MoreObfuscating data through Data Scramble in Bulk
PROBLEM And we arrive to the last chapter of this session about how to mask and obfuscate data. This time…
Read MoreObfuscating data through Data Shuffle in Bulk
PROBLEM When Dynamic Data Masking is not an option you can go for Data Shuffle. Data Shuffle is when you…
Read MoreHow to export Dynamic Data Masking
PROBLEM One day or another you arrive to the point where you have to mask your database. You pass days…
Read MoreHow to export Data Classification
PROBLEM In my previous post I described how Data Discovery and Classification is a half done tool. Personally I loved…
Read MoreData Discovery and Classification with Data Preview
PROBLEM I’m currently working on a project that is a sort of spaghetti monster. On all sides. The databases are…
Read MoreSQL Server :: How to query a whole Data Center
Few days ago I had the time to update one of my too called SQL_Spring_Cleaning. This made me figure out…
Read More