Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

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.

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.

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.

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.

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.

Redgate Flyway Enterprise's code analysis: Enforce compliance, reduce risk, deploy with confidence

With increasing security threats and stringent compliance requirements, database code quality isn’t just a best practice; it’s a business imperative. Yet many organizations struggle to enforce their database development standards consistently across teams, leading to security vulnerabilities, potential data loss, and lengthy review cycles that slow down software delivery.

Activating free trial in dbForge add-ins for SSMS

In this video, you’ll learn how to activate a dbForge add-in for Microsoft SQL Server Management Studio. We’ll use dbForge SQL Complete as an example, but the activation steps apply to all dbForge add-ins. We’ll show where to find your activation key, how to activate online or offline, and even via the command line. Activation is quick, secure, and free — so you can start your trial right away!