Five Ways to Simplify Data Masking

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 Versus Smart Quotes

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

Monitoring your Servers and Databases: SCOM and Redgate Monitor

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

Color-coded Checks for your Current Flyway Environment

This article shows how to provide clearer feedback from the Flyway CLI by using environment-specific placeholders to provide details about the environment's purpose. It then illustrates how you might use this information to allow a scripted Flyway pipeline to give a simple code-coded message confirming the connected environment. Read more

Cut SQL Server Licensing and Cloud Costs by Monitoring CPU Overallocation

Avoid paying for unused CPU power, on-prem or in the cloud. This guide shows how to use Redgate Monitor to identify overprovisioned SQL Server VMs, reduce licensing and compute costs, and ensure your workloads still run smoothly. Read more

How to Identify and Fix Slow Queries in PostgreSQL

Struggling with slow queries in PostgreSQL? Learn how to spot and fix them fast, using a simple diagnostic process and the free tool pgNow. Read more

Defining and Using Multiple Flyway Environments in TOML

This article shows how to define environments in your TOML files, use resolvers to provide secure connection details, and configure per-environment overrides and placeholders. It explains how this approach simplifies automation, makes CI/CD pipelines easier to manage, and helps teams work consistently and securely across multiple databases. Read more

Practical PostgreSQL Schema Comparison with Redgate pgCompare

Managing PostgreSQL schema changes across environments can be challenging, especially with complex dependencies. pgCompare highlights differences between two databases and generates reliable deployment scripts. This article shows how to get started with the tool and how it simplifies everyday tasks like reviewing feature branch changes, auditing schema drift, and creating build scripts. Read more

Why Database Deployments Sometimes Go Bad

Phil Factor shares some of the common ways database deployments go wrong, and the testing strategies and sanity checks that will stop them happening to you. Read more

Set up Redgate pgNow Activity Monitoring on Azure Database for PostgreSQL Flexible Server

This article is a QuickStart setup guide for Redgate pgNow activity monitoring on Azure Database for PostgreSQL Flexible Server. Once you’ve completed the setup, you can start using live query activity, health, and performance data to troubleshoot current issues on your PostgreSQL instances, all without writing any SQL scripts. Read more

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Product articles