All articles

Email Spoofing

Have you ever had this unhealthy sensation of being accused of facts that do not concern you? To feel helpless in the face of an accusing mail, which, because of its imperative and accusing tone,(…)

Migrating your users from md5 to scram authentication in PostgreSQL

One of the new features in PostgreSQL 10 was the introduction of stronger password authentication based on SCRAM-SHA-256. How can you migrate your existing users that currently use md5 authentication to the new method without any(…)

Huawei Dorado 6000 V3 benchmark

I had the opportunity to test the new Dorada 6000 V3 All-Flash storage system. See what the all-new Dorado 6000 V3 All-Flash Storage system is capable as storage for your database system.

Storage performance benchmarking with FIO

Learn how to do storage performance benchmarks for your database system with the open source tool FIO.

What you should measure on your database storage and why

How can you do a good capacity and performance management for your databases, when you do not know, what your storage system is capable of, and what you need? In this article, we are discussing a way to test a(…)

Converting columns from one data type to another in PostgreSQL

Usually you should use the data type that best fits the representation of your data in a relational database. But how many times did you see applications that store dates or numbers as text or dates as integers? This is(…)

Telling the PostgreSQL optimizer more about your functions

When you reference/call functions in PostgreSQL the optimizer does not really know much about the cost nor the amount of rows that a function returns. This is not really surprising as it is hard to predict what the functions is(…)

SQL Server containers and docker network driver performance considerations

Few months ago I attended to the Franck Pachot session about Microservices and databases at SOUG Romandie in Lausanne on 2019 May 21th. He covered some performance challenges that can be introduced by Microservices architecture design(…)

Deploying SQL Server on Azure virtual machine with Terraform

We are entering now to the infrastructure as code world and provisioning a SQL Server infrastructure is not excluded from the equation. This is especially true when it comes the Cloud regardless we are using IaaS or PaaS. One(…)

Modifying pg_hba.conf from inside PostgreSQL

During one of the sessions from the last Swiss PGDay there was a question which could not be answered during the talk: Is it possible to modify pg_hba.conf from inside PostgreSQL without(…)