Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Replication Job Monitoring Support in Redgate Monitor

Whether it’s a stalled Log Reader Agent, a conflicting insert on the subscriber, or a failed cleanup job bloating the distribution database, Redgate Monitor now brings SQL Server replication issues to light early, before performance or reliability are affected. In many SQL Server environments, replication remains essential for offloading reporting and analytics workloads, or for maintaining local and synchronized data copies across regions.

Building dbRosetta Using AI: Part 2, Defining the Project & Prompt Templates

This is the next installment of the series on building a database and an application called dbRosetta using AI/LLM. Part 1 introduces the concept. THE AI PICKED DATABASE FIRST! Look, I talk databases at this thing a lot, so it probably knows my own preference, but when I asked it, it chose to build a database separate from the code. Let’s get into it.

Unleashing Powerful Analytics: Technical Deep Dive into Cassandra-Spark Integration

Apache Cassandra has long been favored by organizations dealing with large volumes of data that require distributed storage and processing capabilities. Its decentralized architecture and tunable consistency levels make it ideal for handling massive datasets across multiple nodes with minimal latency. On the other hand, Apache Spark excels in processing and analyzing data in-memory, making it an excellent complement to Cassandra for performing real-time analytics and batch processing tasks.

Grafana Tempo: Setup, Configuration, and Best Practices

As systems grow, understanding how a request moves across multiple services becomes harder. Traces help bring this picture together by showing the exact path a request takes, along with the timings that matter. Grafana Tempo is built for this kind of workload. It stores traces efficiently, works well with OpenTelemetry, and keeps the operational overhead low.

Terminate Idle Connections Automatically

Learn how to automatically close inactive connections in your Aiven for PostgreSQL service using pgBouncer’s idle timeout setting. In this demo, we’ll walk through the Aiven Console to adjust the server_idle_timeout value in pgBouncer’s advanced configuration, helping you optimise performance and free up resources by terminating idle connections faster.

New Devart Python Connectors Add Broader Compatibility and Stronger Security

We are thrilled to announce a major update to our Python Connectors line. The release adds support for Python 3.14, PostgreSQL 18, MySQL 9, and MariaDB 12, introduces modern authentication and security options, and delivers notable performance gains across several connectors.

Grafana Mimir 3.0 release: performance improvements, a new query engine, and more

In 2022, we introduced Grafana Mimir, our open source, horizontally scalable, multi-tenant time series database (TSDB) designed for long-term storage of Prometheus and OpenTelemetry metrics. Over the years, Mimir has become a go-to metrics backend within the open source community, with 30 project maintainers and more than 4.7k GitHub stars.