Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Need to do Integration Testing without a real Postgres SQL Database? #speedscale #postgres #sql

Struggling with integration testing because you need a real Postgres SQL database running? This video walks you through how to use Speedscale's proxymock to easily record and mock a live Postgres connection. You'll see how to: By the end, you'll be able to create realistic database mocks for your testing and development, saving you time and hassle.

New in Flyway: Pre and post deployment scripts for state-based deployments via callbacks

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.

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.

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.

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.

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.