Detecting Data Masking Gaps in a CI Pipeline

If you use Redgate Test Data Manager to anonymize production-derived test data and Flyway to manage schema changes, you need a way to keep masking rules aligned with schema evolution. The most reliable approach is to validate masking coverage in CI: run a masking drift check as part of the Flyway pipeline and fail the build if schema changes introduce sensitive columns that aren’t yet covered by the masking configuration. This article shows how the check works, what it validates, and where it can fit into a typical delivery workflow. Read more

Safe Database Change at Scale with Flyway Enterprise

How do teams keep database change safe, controlled, and traceable as AI-assisted coding increases the pace of delivery? Redgate Flyway Enterprise builds the necessary controls, visibility, security checks, and traceability, directly into the database change process, so every change follows a controlled and verifiable path from commit to deployment. Read more

A Practical Guide to Refactoring Production Databases with Redgate Data Modeler

Refactoring a production database is rarely just a schema cleanup exercise. Once a system is live, even sensible improvements can have consequences for existing data and for the applications, reports, and integrations that depend on the current design. This article shows how Redgate Data Modeler can help teams redesign more safely by making those changes visible, documented, and easier to plan. Read more

Test Data Management and SOC 2 Compliance

Using live data outside production is one of the fastest ways to create compliance risk, because it quickly becomes harder to control who can access it, how it is handled, and how long it is kept. A Test Data Management (TDM) approach provides exactly the kind of controls SOC 2 auditors look for in this situation: an automated, traceable end-to-end process for protecting, provisioning, and removing customer data so it can be used safely in non-production environments. Read more

One-click SQL Prompt Using a Stream Deck

SQL Prompt is full of features that make it easier to write and maintain SQL, improve code quality, and keep team coding standards consistent. But when you're busy writing code, can you always remember the shortcut you need, right when you need it? If not, a Stream Deck can turn them into simple, one-button keyboard actions. Read more

Control your dependencies in Flyway Desktop for Oracle and SQL Server Databases

One of Flyway’s biggest strengths is its ability to track your database schema as individual SQL DDL scripts on disk. This gives you full version control over every object, along with a complete audit trail of what changed, who changed it, when it changed, and why. For teams working with Oracle and/or SQL Server, this Read more

Mastering AI Prompts: How to Get the Best Out of SQL Prompt AI

Most frustrations with AI tools stem from unclear prompts. This article uses realistic SQL examples to show how to get more predictable, useful results with SQL Prompt AI in day-to-day work, from writing reporting queries to improving the performance of existing SQL. Read more

Two Small Steps to Measurable Flyway Value

Flyway helps you regain control of complex legacy databases where even small changes can carry high risk. This article describes two small steps that deliver measurable improvements in control, code quality, and deployment reliability, without disrupting how the development team works. Read more

Test Data Management and DORA Compliance in Financial Organizations

DORA requires financial institutions to run tests that prove their systems can withstand operational disruption, without exposing sensitive data. This article explains how Test Data Management (TDM) provides the realistic but safe data needed for resilience testing and the governance controls required under DORA’s ICT risk management rules. Read more

Simple Workflows for Flyway and Entity Framework Code First

Entity Framework Code First is great for development, but its abstractions can hide risky database changes until deployment. This article explores three practical EF–Flyway hybrid workflows that add visibility and control, helping teams stabilize deployments for complex, legacy databases such as monoliths. Read more