Database Administration & Monitoring

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(…)

Step-by-Step Guide to Enabling Copilot in SSMS

With the latest version of SSMS, SSMS 21, there is now integration with Copilot. In this blog post, we’ll go through the setup step by step, with screenshots, to get everything ready to use Copilot in SSMS.There is already(…)

SQL Server 2025: Local SQL Server Container without Docker Command

The last version of” MSSQL extension for Visual Studio Code” has in Preview “the Local SqlServer Containers” based on SQL Server 2025 with the following keys: Create and manage SQL Server containers locally without Docker commands Use SQL Server 2025(…)

Exploring the Future of Data at SQLBits 2025 in London

I’m looking back on three amazing days of interesting technical insights from the SQLBits event 2025 in London. It’s actually my first time having the pleasure of attending one of Europe’s biggest data platform events and I can sincerely say,(…)

SQL Server 2025: What news on the instance configuration

Like every time with a new version of SQL Server, it’s good to see what the new configurations possibilities are for us to manage the instance. To do this, I will compare SQL 2022 and SQL 2025 using the system(…)

Oracle DMK release 2.2.0 new features / Windows support.

DMK is a Database Management Kit that can be used in various database environments. It simplifies command-line tasks for Databases Administrator on Unix and Windows systems. It supports multiple databases including Oracle, MongoDB, MariaDB, and PostgreSQL. It also includes additional modules for automating RMAN(…)

Guidance for a SQL Server backup strategy in AWS EC2

INTRODUCTION S3 storage is the most resilient and available service in AWS: is a trusted service for storing backups over the long term. From a Windows Server machine, in AWS EC2 or elsewhere, the easiest and most reliable way(…)