Database Administration & Monitoring

SQL Server: Do you know how to use SERVERPROPERTY()  function in a useful way?

The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it’s good to come back to basis… How to begin? Read the documentation of course here but you will see(…)

MongoDB Log Analysis : A Comprehensive Guide

Contrary to other DBMS, MongoDB self-managed deployments generate logs in a JSON format, which can be quite intimidating at first. But instead of hoping to never have to look at the logs, you can use some tools and tips(…)

From Oracle’s PL/SQL to PostgreSQL’s PL/pgSQL – 2 – Records, outputs and constraints

In the last post we’ve learned the basics for migrating a sample procedure from PL/SQL to PL/pgSQL. In this post we’ll actually start with migrating the code. The first step in the original procedure was to(…)

From Oracle’s PL/SQL to PostgreSQL’s PL/pgSQL – 1 – Basics

Migrating from one database system to another is not an easy task. It might be easy if you only need to migrate the data, but as soon as you have business logic in the database this can become a lot(…)

How to patch SQL Server instances with Qualys Patch Management

By one of our Customers, I have to use Qualys to patch their production SQL Server instances. And to be more precise the Qualys Patch Management application which provides a solution to manage vulnerabilities and deploy patches to secure(…)

Cannot drop a tablespace?

ORA-22868: cannot drop a tablespace(…)

Unit Testing PostgreSQL with pgTAP

Introduction Unit testing is a fundamental practice in software development, ensuring that individual components function correctly. When working with PostgreSQL, testing database logic—such as functions, triggers, and constraints—is crucial for maintaining data integrity and reliability. One powerful tool for this(…)

Customer case study – Partition switching and transactional replication

The client’s environment includes two SQL Server instances (I1 and I2). One of the databases, D1 (on I1), is replicated to I2 via transactional replication. Additionally, the tables in this database are partitioned. The largest table (which is the one(…)

Contained Availability Group and login failed

A contained availability group is a special availability group which manages its owns logins, users, permissions, jobs… with a dedicated master and msdb system databases, more information here.At a customer place we found some unexpected “login failed” for the(…)

SQL Server: New SQL Server Management Studio (SSMS)  landing page

After the new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages, you have a new landing page for SQL Server Management Studio (SSMS) : https://learn.microsoft.com/en-us/ssms You will see 6(…)