Infrastructure at your Service

Category

Database Administration & Monitoring

Yann Neuhaus

Microsoft Inspire Partner Event 2019 / Day 1

By | Database Administration & Monitoring, DevOps, SQL Server | No Comments

dbi services at Microsoft Inspire Conference Summary of my first participation – Day 1 After 20 years in the business of IT Infrastructure, time has come to open my mind 😉 and Microsoft Inspire is the perfect opportunity. It is a partner conference that has quite a different approach compared to other software editors I worked for (e.g. Oracle). Indeed, the Oracle Open World mixes partners and customers, which is not always a good idea…

Read More
Daniel Westermann

Migrating your users from md5 to scram authentication in PostgreSQL

By | Database Administration & Monitoring | No Comments

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 interruption? Actually that is quite easy, as you will see in a few moments, but there is one important point to consider: Not every client/driver does already support SCRAM-SHA-256 authentication so you need to check that before. Here is…

Read More
Daniel Westermann

Converting columns from one data type to another in PostgreSQL

By | Database Administration & Monitoring | No Comments

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 not so uncommon as you might think and fixing that could be quite a challenge as you need to cast from one data type to another when you want to change the data type used…

Read More
Daniel Westermann

Telling the PostgreSQL optimizer more about your functions

By | Database Administration & Monitoring | No Comments

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 doing and how many rows will be returned for a given set of input parameters. What you might not know is, that indeed you can tell the optimizer a bit more about your functions.

Read More
David Barbarin

SQL Server containers and docker network driver performance considerations

By | Database Administration & Monitoring, DevOps, Docker, SQL Server | No Comments

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 and especially when database components come into the game with chatty applications. One year ago, I was in a situation where a customer installed some SQL Server Linux 2017 containers in a Docker infrastructure with user applications located outside…

Read More
Mouhamadou Diaw

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

By | Database Administration & Monitoring | No Comments

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 à la place d’un Hacker pour mieux appréhender leurs démarches et ensuite comment protéger les données dans une base de données Oracle. Comprendre les intentions et moyens utilisés par les Hackers pour parvenir à leurs fins nous aide à mieux les…

Read More