Operations | Monitoring | ITSM | DevOps | Cloud

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.

Aiven's PG Studio is now in Early Availability, allowing you to work with your Aiven for PostgreSQL instances, directly in the Aiven Console. Over the last several decades, PostgreSQL has been steadily climbing its way to the top of popularity amongst DBAs and app developers. With the rise of AI development, PG has become the tool that you can build with at many different development stages. This starts at the home of your data, which is the Aiven for PostgreSQL service page in the Aiven Console.

This is a guest post from James Hemson. Redgate Test Data Manager's latest release adds Entra ID authentication, multi-target anonymization, and direct treatment code editing, with workflow improvements to make pipeline management faster and more flexible. Entra ID Authentication You can now connect to SQL Server using token-based authentication via Azure Entra ID, for both anonymization and subsetting.

We are happy to announce the release of Review Assistant 4.3, introducing support for integration with Visual Studio 2026 and a more practical permissions model for viewing project reports.

We’re excited to share Code Compare 5.5 R1, the latest update to our code comparison and merge tool. This release adds integration support for Visual Studio 2026, so teams can compare changes and resolve merge conflicts directly within the IDE workflow they already use. With Code Compare 5.5 R1, developers can review differences, apply merges, and handle conflicts in Visual Studio 2026 using the same comparison experience they rely on across projects and repositories.

This is a guest post from Adrian Tan. Over recent months, we’ve been steadily improving PostgreSQL monitoring in Redgate Monitor, with a singular focus: to help Postgres users diagnose performance problems faster, with less manual investigation. The latest updates and new features tackle this problem in a few different ways.

Short Summary: Sometimes URL paths repeat by mistake because of tracking problems or redirect loops.. In this guide, you’ll learn how to find and count those repeats using Trino SQL. By using simple SQL tools like CTEs, arrays, and window functions, you can break a long link into smaller pieces and clean up the data without using complex regex.

SQL Prompt's February releases focused on compatibility and stability, with a critical fix for SSMS 22.3 users and several features graduating from experimental to fully supported.

Short Summary: In this guide, we address performance problems that occur when PostgreSQL queries very large tables containing low-cardinality boolean fields. It also demonstrates how composite indexes, created and tested with Devart tools, allow PostgreSQL to locate the required rows directly instead of scanning the entire table.