Home

My Blog Posts

When the unused become used: Using SQL Data Catalog to spot the pitfalls of a data classification process

“The surprise is that you continue to be surprised.”– Jill A. Davis But what surprise am I alluding to? Of course it is the surprise that “all of a sudden” you have sensitive data in tables where there ought not be! What I mean is; we have a fantastic process in place: we have completely … Continue reading When the unused become used: Using SQL Data Catalog to spot the pitfalls of a data classification process

SQL Data Catalog, Data Masker and your DevOps pipeline: How do I make sure everything is being masked?

“However fast regulation moves, technology moves faster. Especially as far as data is concerned.”– Elizabeth Denham You’re probably sick of me constantly talking about how the cataloging of columns should be part of the DevOps upstream deployment process. I’ve blogged about it. I’ve even produced a video demonstrating this in action. But one question that … Continue reading SQL Data Catalog, Data Masker and your DevOps pipeline: How do I make sure everything is being masked?

Configuring Dynamic Data Masking in Azure SQL Database from SQL Data Catalog using PowerShell

“Horror is the removal of masks.”– Robert Bloch I spend a great deal of my time talking about Data Masking, don’t believe me? Checkout here, here, here and even here. I talk about it a LOT, but I’m always talking about Static Data Masking (SDM), which is the process of masking the data at the … Continue reading Configuring Dynamic Data Masking in Azure SQL Database from SQL Data Catalog using PowerShell

Automating best practice checks at build time using the SQL Code Analysis cmdline (and failing the build)

“Quality is not an act, it is a habit.”– Aristotle I’ve always been thoroughly impressed with the static analysis code report that you can get from SQL Change Automation when it creates a Release Artifact prior to deploying upstream, and the fact we can use SQL Prompt to carry out on-the-fly static analysis as we … Continue reading Automating best practice checks at build time using the SQL Code Analysis cmdline (and failing the build)

“But I don’t wanna INSTALL it!”: Data Masker on the fly in Azure DevOps (with an Azure SQL DB)

“There is always a way to go if you look for it.”– Ernest A. Fitzgerald As many of you know, I really enjoy talking about Data Masking. I fundamentally believe it is an absolutely ESSENTIAL part of Test Data Management and specifically the provisioning of Pre-Production environments. If you hold sensitive PII/PHI/PCI in your Production … Continue reading “But I don’t wanna INSTALL it!”: Data Masker on the fly in Azure DevOps (with an Azure SQL DB)

Moving teams and users between multiple SQL Clone Servers

“Portability should be the default.”– Larry Wall Greetings one-and-all! It’s been a long time hasn’t it? Well – I’ll be honest. I’ve not been great… I’ve been struggling. With the pressures of everything going on; from National Lockdown 3: The Lockdown Strikes Back, to working hard, and trying to lose weight it’s all been a … Continue reading Moving teams and users between multiple SQL Clone Servers

Creating rollback scripts automatically with SQL Compare and SQL Data Compare in Azure DevOps (migrations approach)

“Life’s under no obligation to give us what we expect.”– Margaret Mitchell Hello everyone and happy 2021! Wait, what? It’s FEBRUARY!?! Oops. You may well have noticed I have not been around for a couple of months. That is because I’ve been struggling. A lot. We’ve had some home worries, and with the state of … Continue reading Creating rollback scripts automatically with SQL Compare and SQL Data Compare in Azure DevOps (migrations approach)

Refreshing SQL Server Development workflows with Redgate SQL Provision

“If you quit on the process, you are quitting on the result.“– Idowu Koyenikan SQL Provision is really cool. But you knew that didn’t you? It’s obvious – we get teeny-tiny clones, based on an image with completely sanitized data we can use for just about anything in dev and test, and if we break … Continue reading Refreshing SQL Server Development workflows with Redgate SQL Provision

3 RDBMS’, 3 models, 3 end-to-end deployment pipelines with Azure DevOps and Redgate Deploy

“Choice is the most powerful tool we have. Everything boils down to choice. Every choice we make shuts an infinite number of doors and opens an infinite number of doors.”– Lori Deschene (https://tinybuddha.com/) Picking a Set-Up One of the hardest parts of my job is that at any moments notice we could be asked to … Continue reading 3 RDBMS’, 3 models, 3 end-to-end deployment pipelines with Azure DevOps and Redgate Deploy


Follow My Blog

Get new content delivered directly to your inbox.