Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Redgate Test Data Manager Updates - March 2026

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.

Why SSIS will never die - with Tim Mitchell

Steve is joined by business intelligence architect and author Tim Mitchell. They discuss why SSIS will never die, the general pros of cons of integration services, the evolution from XML to JSON, how AI can help with coding, and taekwondo – among other topics! Recorded on-site at PASS Data Community Summit 2025.

Code Compare 5.5 R1 Adds Integration Support for Visual Studio 2026

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.

Smarter Postgres Monitoring: Compare Queries, Spot Unused Indexes, and Diagnose Waits

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.

Counting Consecutive Repeating Segments in URL Strings via Trino SQL

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.

Optimizing PostgreSQL Performance for Large Tables with Boolean Filters

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.

Scaling Your CLI Query Tool: Prioritizing Database Support for Maximum Impact

Short Summary: This article explains how to expand your CLI query tool so it can handle multiple databases. First, we focus on key relational systems, then move to data warehouses. We’ll use dbForge Edge as a reference point, showing how different databases can be managed in one place while keeping automation simple.

Choose the Right SQLite ODBC Driver: Practical Comparison for 2026

Picking an SQLite ODBC driver is like choosing a key; you need one that opens every door cleanly, without snapping or jamming. The right driver must connect your data effortlessly—no errors, no limitations. It also has to withstand real challenges: complex queries, cross-platform environments, and large datasets. In this guide, we’ll show you which 2026 drivers stand up to these demands, so you can pick the one that won’t let you down.