All articles

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

Windocks and K8s support

I got recently the 4.08 update from the Windocks team and I was very excited to evaluate some of new features. The first cool one I want to present in this blog concerns the Kubernetes support(…)

work Agile in a GxP-regulated environment

On 4 June 2019 I followed an invitation to wega-it’s Know-how & Networking Breakfast 2 2019 on “Agile Validation in GxP Projects”. So they were to discuss Agility in the context of GxP regulation. I had some earlier exposure to(…)

Evenement Oracle : Dans la tête d’un Hacker & Comment protéger vos données sensibles

By Mouhamadou Diaw Pour une fois un blog en français parce que concernant un événement Oracle en Français. Aujourd’hui chez Oracle Suisse à Genève, il y’avait une présentation concernant la sécurité Oracle. Il s’agissait de se mettre à(…)