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
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
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
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
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
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
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
How do we protect sensitive data and still get realistic test databases without creating a masking process that is slow, brittle, or impossible to maintain? This article sets out five practical ways that Redgate Test Data Manager helps teams deliver secure, realistic test data reliably. Read more
SQL Prompt AI can repair certain types of broken SQL almost instantly, saving hours of clean-up time. Just prompt it clearly, check the results are exactly what you intended, and you're ready to run. Read more
With simple integration, SCOM and Redgate Monitor combine breadth and depth, infrastructure-wide observability plus SQL Server insight. The result is faster incident response, smarter use of DBA time, and monitoring that scales with growth and new technologies. Read more