Operations | Monitoring | ITSM | DevOps | Cloud

Flyway provides a lot of flexibility for releasing database changes in a safe and repeatable manner. Earlier this year, we added the ability to automate state-based deployments. This means the structure of the database is defined in version control and Flyway handles updating a target database to match it. The Flyway comparison engine does all the hard work of identifying what’s different and creating a script that will run on the target database to alter it so it matches the latest state.

NTILE in SQL transforms raw lists into structured distributions before they reach a dashboard. By pushing distribution logic upstream, it divides ordered rows at the query level, so the insights in Power BI, Tableau, or Excel are accurate, not just polished visuals. This guide explores its syntax, practical examples, and comparisons with other ranking functions. It also highlights how database IDEs bring NTILE insights directly into analysis and reporting workflows. Table of contents.

Aiven is proud to launch the newest version of PostgreSQL, version 18, alongside with the open source community as the first managed PostgreSQL provider to support the latest version. This year we had three Aiveners join in on contributing to this major release, a trend which we hope to only see increase. Congrats to Patrick Stählin, Ronan Dunklau, and Thomas Krennwallner for your contributions to the codebase.

Open source defies everything you’ve ever heard or learned about business before (author’s quote). Yes, open source software has been around since the 90s, but there’s still little else like it. If anything, as time has gone on, we’ve added adjacent concepts like “open core” and “source available” that have added complexity to a model that isn’t that straight forward to grasp to begin with. VictoriaMetrics is an open source company.

We are excited to announce a new release of SecureBridge, EntityDAC, and the dbExpress product line. This update introduces support for the newest RAD Studio version, enhances compatibility with popular databases, and adds new components and options to simplify development and strengthen security.

What is Microsoft Entra ID, and why is this important in the database ecosystem? If you have ever used the Microsoft Authenticator app, you’ve already seen how the MS Entra ID works, but only a fraction of it. Microsoft Entra Identity (formerly Azure Active Directory) is a modern identity platform that unifies authentication, strengthens access controls, and integrates with the applications and databases businesses rely on most.

A new milestone is achieved with the release of dbForge 2025.2! This time, it brings you enhancements in dbForge AI Assistant, long-awaited user interface improvements, and further significant advancements across dbForge tools for SQL Server, MySQL/MariaDB, Oracle, PostgreSQL. Interested in learning more? Let’s get started!

Databases are the core of modern applications, whether it is an e-commerce platform, a banking system, or a social media app. Slow database performance or unexpected downtime can cause serious problems, from lost revenue to poor customer experience. Proactive database performance monitoring helps teams identify issues before they escalate. Unlike reactive monitoring, which only addresses problems after they occur, proactive monitoring ensures your database remains fast, stable, and reliable.

We are thrilled to announce a significant update across our DAC (Data Access Components) product line. This release focuses on expanding compatibility with the latest development environments, extending support for modern databases, strengthening security, and adding powerful new functionality for AI-driven applications.

Querying PostgreSQL in plain English is no longer a futuristic idea; it’s something you can build today. With a Model Context Protocol (MCP) server, Claude Desktop connects securely to external systems, including databases, through a structured interface. Here, MCP acts as the bridge between Claude and PostgreSQL, allowing it to run queries, explore schemas, and return results instantly in Markdown. This guide walks you through building that bridge in C#.

One kind of data in most relational databases is what we call static data. This is also referred to as lookup data, code data, domain data or even list data. Whatever you like to call it, it’s usually smaller data sets consisting of data that never changes, or changes very slowly. One example might be Canadian postal codes. Another example, and one I’m going to use, is the amateur radio band definitions within a given country.

Databases form the critical foundation of modern applications, and maintaining their performance and reliability is essential for operational efficiency and user satisfaction. Effective database monitoring however presents numerous challenges. Modern systems produce extensive metrics, operate across diverse environments, and must scale in line with growing workloads, all while ensuring compliance and security.

For nearly 20 years, SQL Prompt has been a trusted companion for database professionals, helping them write cleaner code, reduce errors, and save time. From its earliest days, the focus has been on productivity while removing the repetitive, mundane tasks that slow people down. It’s been about building the reliability and performance that developers and DBAs depend on every day and that story doesn’t stop here.

A few weeks ago, we massively improved the performance of the dashboard & website by optimizing some of our SQL queries. In this post, we'll share how we identified the queries that needed work. In the next post, we'll explore how we fixed each of them. We'll cover the basics and gradually work our way up to the more advanced/complex ways of identifying slow queries. In this post, you'll see: Let's go!

Until recently, Grafana Mimir — our open source, horizontally scalable, multi-tenant time series database (TSDB) — has exclusively used Prometheus’ PromQL engine to evaluate queries. While the PromQL engine works great, it sometimes needs a lot of memory to run, specifically in the Mimir querier component. To address this memory consumption issue, we recently introduced Mimir Query Engine (MQE).

As technology scales and data volumes accelerate, organizations face a pressing challenge: how can they modernize data infrastructure without putting daily operations at risk? Data historians, specialized databases that capture and store time-stamped machine and sensor data, have long been the foundation for reliability and compliance. However, they were not designed for the openness and advanced analytics that modern workloads demand.

Inconsistent SQL formatting is a silent productivity killer. The database will execute it, but for developers, poorly structured queries lead to slower reviews, harder debugging, and errors that slip through unnoticed. Over time, this lack of consistency compounds into costly technical debt. This guide shows how to format SQL code so it remains clear, consistent, and easy to maintain.

Databases handle critical operations for applications, from online banking to e-commerce and streaming services. Any slowdown or failure can directly affect application performance and user experience. Database monitoring tracks performance, detects issues, and helps prevent downtime. It also ensures efficient use of resources, maintains security, and supports compliance requirements.

"Let us support different relational databases apart from SQLite. Nobody likes to run SQLite in production." This was one of the most requested features from our community. Your requests have been heard, and we've added support for different relational databases, starting with PostgreSQL. If you're self-hosting SigNoz, you no longer need to worry about SQLite's limitations. Let's dive into what we've built and why it matters for your production deployments.

Avoid the pitfalls of cloud database migration with Redgate Flyway. Learn how automation, schema discipline, rollback strategies, and traceability reduce risk and enable fast, compliant cloud deployments, with these insights from John Q. Martin, Technology Partner Manager at Redgate Software. Cloud migrations promise faster releases and more flexible scaling, but a poorly executed database migration will stop you from exploiting them.

ClickUp integration has become a key driver of operational efficiency for over 3 million teams worldwide. By connecting the ClickUp platform with business applications, organizations simplify operations, eliminate manual handoffs, and give leaders the visibility needed to act with confidence. But achieving these outcomes requires a stable integration approach because not all methods offer the same flexibility or access.

MariaDB has become a preferred backend for many enterprises, thanks to features like Galera clustering, JSON functions, and ColumnStore for analytics. But to extract value from MariaDB, organizations need reliable integration with BI tools, ETL pipelines, and custom apps, and this is where MariaDB ODBC drivers come in. These drivers bridge the gap between your database and external systems. But not all of them are production-ready.

Snowflake is the backbone of modern enterprise data architecture, powering over 10,600 organizations—including 800+ Fortune Global 2000 leaders. But thriving in this ecosystem takes more than just the platform. It requires a data architecture that can handle real-world complexity—and that’s where Snowflake connectors come in.

Zendesk is a goldmine of customer insights, but extracting that value from its usage is not simple. Teams trying to export data from Zendesk often run into paywall restrictions, API rate limits, and third-party tools that promise simplicity but falter at scale. For organizations integrating support data into BI platforms, migrating systems, or automating reporting pipelines, these challenges stall analytics and strategy.

The OpenTelemetry Astronomy Shop is a widely used demonstration environment designed to illustrate the concepts and practical implementation of observability in distributed systems. Built as a microservice-based e-commerce application, the demo provides developers with a near real-world environment where they can explore how telemetry data—metrics, logs, and traces—can be collected, processed, and visualized.

Industrial data strategy often feels like a choice: keep legacy systems or replace them outright. But neither extreme is ideal. Full replacements are disruptive and costly, while avoiding change leaves businesses stuck with tools that limit growth. The better path is incremental. Each organization has different needs, and modernization works best when you build on proven systems while adding new capabilities.

Database latency rarely starts in your app layer because it’s almost always a query doing more work than it should. Metrics tell you when that happens, but slow-query logging tells you which statement did it and how. That’s gold for tracking down missing indexes, inefficient filters, or accidental full scans. Pair the logging with a some lightweight counter metrics, and you get both an early warning and a clear path to a fix.

John Q Martin, Technology & Alliances Partner Manager at Redgate, covers 10 mistakes he's made when migrating databases to the cloud - and the strategies he now implements to avoid them happening again. But first, John explains exactly why databases are the hardest part of cloud migration.

Redgate Test Data Manager’s September release introduces AI dataset generation, streamlined database connectivity, and improved validation. These updates eliminate manual work and configuration errors while maintaining security and data quality standards.

When an application slows down, users rarely think about the database—but in many cases, that’s where the bottleneck lies. Databases sit at the core of nearly every application, storing, retrieving, and processing the information that powers business transactions, analytics, and user interactions. A minor inefficiency in query execution or a spike in resource usage can cascade into multiple issues, starting with degraded application performance, service interruptions, or even downtime.

Redgate Monitor now supports Oracle Data Guard environments, giving DBAs instant visibility into replication health, lag and role transitions, so Standbys stay in sync and are ready to protect availability and data when needed. DBAs running Oracle Data Guard know that keeping replicas healthy requires constant vigilance. It often involves querying dynamic performance views, such as V$DATAGUARD_STATS, or running Data Guard Broker commands to check lag and role status.

Understand what's happening inside your database before your users do. Modern applications live and breathe through their databases. But when slow queries, connection spikes, or failed transactions start to pile up, the impact isn't just technical—it's customer-facing. That's why tracking your databases gives you the visibility into how your databases are performing under the hood.