Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

SQL NTILE Function Explained with Practical Examples

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.

Welcome PostgreSQL 18: A New Era of Performance on Aiven

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.

Learn to mock your MySQL database and get realistic test data without the hassle of a live server!

Proxymock allows you to record real interactions between your application and a MySQL database. Use proxymock to simulate your database during local development and testing. Get real data without running a live MySQL server. Modify mock responses to fit your testing needs. Simplify your testing workflow and replicate production data easily.

Creating a Sustainable Open Source Business Model - Introduction

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.

SecureBridge 11.0, EntityDAC 3.5, and dbExpress Drivers: Latest Versions Released

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.

Authentication Methods and Features in Microsoft Entra ID

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.

dbForge Hits a New Milestone With 2025.2!

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!

10 Best Practices for Proactive Database Performance Monitoring to Prevent Downtime

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.

Feature Spotlight: PostGres Mocking #speedscale #postgres #postgresql

Struggling with integration testing because of a Postgres database dependency? Testing can feel impossible when you need to replicate realistic data in Postgres. That’s where Speedscale’s Postgres Mocking Tool comes in. Speedscale drops a recorder into your live system, observes all Postgres traffic, and shows you the actual sequence of statements and responses—making it easier than ever to test reliably.