Database management

PostgreSQL 18: REJECT_LIMIT for COPY

With the just released version of 17 of PostgreSQL, copy got the “ON_ERROR” switch. This is very useful if you load something which contains rows that cannot be inserted into the target(…)

Understanding Head Blockers in SQL-Server

A customer of mine had a recurring issue with one of his business critical applications where everything was frozen and stuck for the users. The issue was caused due to a head blocking transaction which increased blocking in the database(…)

Future Data Driven 2024 – introduction to vector databases

I had the opportunity to participate in the Future Data Driven 2024 event (https://datadrivencommunity.com/FutureDataDriven2024.html) with my colleague Stéphane Haby. Many speakers were present, and I was able to attend several sessions covering the following topics: Azure, AI, CosmosDB,(…)

Coming back to the Future Data Driven Summit 2024’s Event last night

Last night, I followed with Amine Haloui the Future Data Driven Summit 2024 from 3 PM to 2 AM This event was remote and very easy to follow. One day with 5 rooms and  more then 55 speakers…(…)

SQL Server: The importance of the default language during a login migration

Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about “conversion of a varchar data type to datetime data type” on this application.The error was an(…)

“Edit Top 200 rows” does not work between SSMS 18.12.1 & SQL Server 2022

Recently after a migration from SQL Server 2012 to SQL Server 2022, a end user contact me because SQL Server Management Studio (SSMS) does not work anymore when he want t o edit rows… I was surprised and do a(…)

SQL Server: Basic AG – One listener, multiple databases

Introduction When it is not possible to have SQL Server Enterprise and there is a need to set up an AlwaysOn cluster, it is possible to use SQL Server Standard and implement basic availability groups. However, the Standard edition of(…)

CloudNativePG – Connecting external applications

Now that we know how we can benchmark a CloudNativePG deployment, it is time to look at how we can connect external applications to the PostgreSQL cluster. Usually, applications run in the same Kubernetes cluster and(…)

SQL Server Tips: How to know how long goes a shrink ?

Few days ago, I perform a shrink on a data file to spend a little bit space on a disk.The SQL Server is a test server and the customer does not want to expand the disk. I run the shrink(…)

SQL Server: how do monitor SQL Dumps?

Few weeks ago, we had a big issue by a customer and a lot SQL Dumps was created in the SQL Server log folder. After playing fireman at the customer’s premises, we decided to set up a monitoring system for(…)