Operations | Monitoring | ITSM | DevOps | Cloud

Customer-led, independently proven: Redgate Monitor's G2 Spring 2026 awards

Every quarter, G2 publishes seasonal reports and awards badges based on authenticated customer reviews, not paid ranking, to highlight top-performing B2B software products. For Spring 2026, Redgate Monitor had a standout showing, earning 14 new badges, including several “Best / Most” awards that go to just one single product in every category.

Mastering AI Prompts: How to Get the Best Out of SQL Prompt AI | The Tony and Tonie show Ep41

How to get the most value from SQL Prompt AI in day-to-day work, whether you're writing new queries or improving existing code. A little prompt-writing knowledge goes a long way with SQL Prompt AI. Tony and Tonie discuss how to build reusable prompts that give the tool the context it needs to return useful results first time.

New Release of Delphi Data Access Components Adds Support for Latest IDEs, Databases, and Windows Arm64EC Target Platform

We are thrilled to announce a new release of our Delphi Data Access Components product line. This update delivers broader platform compatibility, enhanced security, and extended support for modern database technologies across multiple providers.

Migrating from MySQL to PostgreSQL: Performance and Replication Best Practices

Summary: Today, many teams are moving from MySQL to PostgreSQL as they update their database systems and plan for future growth. However, too often, there is extra work after the migration: for example checking that tables and constraints were copied correctly, tuning performance, and confirming that replication works properly. Devart’s PostgreSQL tools help DBAs with these tasks through features like Schema Compare, Data Compare, and other tools that help review and manage PostgreSQL databases.

High-Performance Range Queries in PostgreSQL: Overcoming Bottlenecks in AWS Aurora

Short Summary: PostgreSQL can slow down when range queries and frequent data updates rely on the same indexes. This guide shows how to spot the problem and use Devart tools to reduce B-Tree index conflicts, improve query plans, and manage bi-weekly data updates in AWS Aurora.

dotConnect for Zoho CRM | Connect Zoho CRM to .NET Apps Easily

Bring Zoho CRM data into your.NET applications with dotConnect for Zoho CRM—a fast, reliable ADO.NET provider built for secure and efficient connectivity. Set up in minutes using a Windows installer or NuGet, then explore and manage your CRM data from Visual Studio. This video walks you through connecting via Server Explorer, authenticating with Interactive OAuth, running queries through standard ADO.NET workflows, and integrating with popular ORMs like EF Core and Dapper.

What's under development in Redgate Flyway

In my recent posts, I looked back at the major features we shipped in 2025, highlighted all the exciting things going on in Flyway for Oracle databases, and shared the recent improvements to tracking dependencies for both SQL Server and Oracle databases. But that’s only part of the story. With four development teams working on Flyway, there’s a lot happening. Here’s a look at what’s recently been released, what’s in public preview, and what’s coming next.

Redgate Flyway's Product Updates - March 2026

This is a guest post from Maxime Drobot. This month we’re bringing you official GitHub Actions for Redgate Flyway, usability improvements in Flyway Desktop, and a look at what’s new, what’s in preview. Plus: earlier visibility of code‑review results, helping teams keep quality high and reviews flowing smoothly as AI increases the volume of changes.

The Four Factors of Production-Ready PostgreSQL

Discover how Aiven makes the 4 factors of production-ready PostgreSQL easy A database isn't production-ready just because your application can query it. To be truly ready for production, your PostgreSQL setup must be able to survive node failures, block unauthorized network access, handle sudden connection spikes without crashing, and tell you exactly why a query is running slow. Let’s explore these four factors and how Aiven puts being production-ready on easy mode.

The Complexity Rebound

Redgate’s annual “State of the Database Landscape” survey has been published. Like every other year, it paints a really interesting picture. Personally, I love looking through this in order to better understand where people are experiencing pain in the management of their data. If you know where people are experiencing pain, as a technical person, you know where to focus your own skill development.

New Redgate Flyway GitHub Actions: Faster setup, safer deployments

This is a guest post from Stephanie Herr. If your team uses GitHub Actions to ship application code, you've probably wished your database changes could move through the same pipeline just as smoothly. Today, that's easier than ever. We've launched verified Redgate Flyway GitHub Actions on the GitHub Marketplace, giving you a simple, reliable way to integrate database deployments into your existing GitHub workflows.

Observability Lessons From OpenAI

Writing code is moving from the good old IDE into the realm of autonomous AI agents. One example of this is OpenAI, which has been developing internally with 0 lines of manually written code. You can read about their workflow in their engineering blog: Harness engineering: leveraging Codex in an agent-first world. For me, the main takeaway of OpenAI’s article is how AI has rewritten the constraints equation.

Benchmarking Kubernetes Log Collectors: vlagent, Vector, Fluent Bit, OpenTelemetry Collector, and more

At VictoriaMetrics, we built vlagent as a high-performance log collector for VictoriaLogs. To validate its performance and correctness under a real production-like load, we developed a benchmark suite and ran it against 8 popular log collectors. This post covers the methodology, throughput results, resource usage, and delivery correctness. Collectors under the test: We’ve made all benchmark configurations and source code public, so you can reproduce and verify the results independently.

A Faster Way To Spot What's Slowing Down Your PostgreSQL Database

This is a guest post from Kellyn Gorman. Kellyn Gorman is a Database and AI Advocate and Engineer at Redgate She's the previous director of Data and AI at Silk, and the Oracle SME in Azure at Microsoft. With a robust background in cloud technology and a passion for promoting its merits and potential, I am thrilled to spearhead conversations and actions that help shape the future of this industry.

Let's Tune Our AWS Aurora PostgreSQL Database

In case you don't know the back story, in order for me to play with radios and label it "work," I've created a PostgreSQL database running on AWS Aurora. The db is fed from API calls to aprs.fi through Lambda functions on AWS. Some of the DDL & code is mine. Some is from Claude. Neither of us paid much attention to indexing when we were putting things together.

Redgate Monitor is now available as a fully managed SaaS edition

This is a guest post from Phil James. Database teams are already juggling a lot. Monitoring the performance of complex, multi-platform estates takes expertise and focus — and that's before you factor in installing, maintaining, and updating the monitoring tooling itself. That's the tension we've been hearing from database teams for a while. The monitoring solution is supposed to reduce operational burden, yet the infrastructure that runs it adds more.

5 Database Monitoring Tips Every DBA Should Use to Reduce Firefighting

This is a guest post from udara.ratnakumara. In a recent webinar I hosted with my colleague Chris Hawkins, Inside a DBA’s Day: What Really Happens and How to Stay Ahead, we talked through the realities of a typical DBA day and the practical ways teams can stay ahead of issues rather than constantly reacting. For many DBAs, the day doesn’t start with coffee. It starts with an alert. A report is suddenly slow. An application query is timing out.

MySQL, from "Hello World" to High Availability

Whether you’re spinning up your first relational database or running a global e-commerce platform, Aiven for MySQL provides the performance and reliability you need. In the world of open-source databases, MySQL is the engine behind millions of applications, and at Aiven, we believe managing it shouldn't keep you up at night. Our platform is built to grow with you, from when you're just getting started all the way through to enterprise scale.

Liquibase MongoDB Extension Tutorial | Install & Use the Harness Community Extension

Discover how to manage MongoDB schema changes using Liquibase with the Harness Community Liquibase MongoDB Extension. In this step-by-step tutorial, you will learn how to install, configure, and run MongoDB database migrations using Liquibase Community Edition. This extension enables DevOps teams to bring database version control and CI/CD practices to MongoDB, making schema changes easier to track, automate, and deploy.

New dotConnect and Entity Developer Release: EF Core 10, AI Vector Types, and Expanded Database Compatibility

We are thrilled to announce a set of product updates across our dotConnect data providers and Entity Developer. The new release adds support for Entity Framework Core 10, introduces AI-focused vector data types across major databases, and extends compatibility with the newest platform capabilities such as SQL Server 2025, Oracle 26ai, and Microsoft Entra authentication.

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.

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.

Introducing Aiven's PG Studio

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.

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.

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.

Database Schema Evolution: Designing for Continuous Change | Harness Blog

Modern database design is no longer a one-time activity but an ongoing process that evolves as business needs, scale, and system behavior change. Instead of large redesigns, teams rely on incremental and backward-compatible schema changes, such as adding columns, indexes, or new tables, to safely adapt the database without disrupting production.

However you Postgres, we've got you covered

From free hobby projects to $5/month developer setups and enterprise-scale clusters, Aiven for PostgreSQL scales with you. Find the perfect tier for your data. Our aim is to make your use of PostgreSQL in the cloud as easy as possible, however you’re using it. Whether you are just starting to learn the ropes or you're managing a global-scale enterprise database, the platform should adapt to you, not the other way around.

Solving the Cartesian Count Problem: Efficient Multi-Table Aggregation in Complex Databases

Short Summary: Counting related records across multiple dependent tables can produce wrong totals or slow queries when standard joins are used. This article explains a more reliable way to do this by counting each table separately, applying date filters, and checking that the query still runs well on large datasets. Tools such as dbForge Edge can also help if needed.

Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2

Short Summary: Different databases use different SQL syntax for simple tasks like subtracting days from a date. In this post, we show how these differences appear across databases such as MySQL, PostgreSQL, SQL Server, Oracle, and H2. We also explain how dbForge Edge helps teams work with them in one place while keeping application logic consistent.