Home

My Blog Posts

3 simple pipelines for database development with Redgate Deploy – Part 1: Setup & GitLab

“Society must adapt to diamonds, diamonds don’t adapt to society.“– Abhijit Naskar The world is changed… I feel it in the water… I feel it in the earth… smell it in the air. On a totally unrelated note did you know December 2021 marks the 20th Anniversary of the Lord of the Rings films? Just … Continue reading 3 simple pipelines for database development with Redgate Deploy – Part 1: Setup & GitLab

Flyway Desktop: Don’t be afraid of your own Shadow (DB)

“Just don’t hold back. Don’t be afraid to make mistakes and stuff.“– Kristen Stewart <HolidayTalk> Howdy folks! Welcome back! Well, I guess that should be aimed at me – it’s been a few weeks *cough* months *cough* since I last blogged anything on here and this is because I was on a sabbatical – I … Continue reading Flyway Desktop: Don’t be afraid of your own Shadow (DB)

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)


Follow My Blog

Get new content delivered directly to your inbox.