Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

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.

Building dbRosetta Using AI: Part 1 of Many

Like many of you, over the last couple of years, I’ve been using AI, or, well, let’s just name it appropriately, Large Language Models (LLM), as a part of my job. I’ve also used it in my hobby. With it, I’ve generated snippets of code, tested data conversions, even built a small database for a presentation. However, to date, I haven’t tried doing everything through the LLM. Now, I’m going to.

Create a PostgreSQL Database in 60s

Learn how to set up a PostgreSQL service on Aiven in just one minute. This demo walks you through accessing your account, configuring your new service, and selecting the right options for your needs. We’ll cover selecting an immutable service name, picking the cloud provider and plan, and show how Aiven’s clear deployment feedback makes creating a scalable database fast and straightforward. Get your PostgreSQL database up and running quickly, so you can focus on building your applications.

dotConnect for QuickBooks Online | Secure C# ADO.NET connection with ORM support

Connect your C# .NET applications directly to QuickBooks Online with dotConnect for QuickBooks — a robust, high-performance data provider designed for modern financial integration. Whether you’re building financial dashboards, automating reports, or syncing accounting data, dotConnect gives you seamless, secure access to QuickBooks Online with full Visual Studio integration and rich ORM capabilities.

Tracking Aborted Queries and Memory Grants in Redgate Monitor

Redgate Monitor now surfaces two common SQL Server query issues that usually take manual work to uncover: cancelled or aborted queries and high memory-grant queries. You can now see both in the Query Executions view for each SQL Server instance, directly alongside server activity and alerts, so you can diagnose the cause much faster. Recently, Redgate Monitor introduced the Query Executions feature for SQL Server instances, using Extended Events to capture execution details for individual queries.

Exploring how PostgreSQL 18 conquered time with temporal constraints

Do you like working with time in your code? If yes, you’re likely one of the lucky ones who are blissfully unaware of how deep the rabbit hole goes. If you don’t like it, I have good news for you! Postgres can make working with time more enjoyable! The newly released temporal constraints let you easily maintain referential integrity across temporal relationships. That might seem simple, but it's kind of a big deal. Let’s explore it through an example.