Database Administration & Monitoring

Microsoft Inspire Partner Event 2019 / Day 3

dbi services at Microsoft Inspire Conference Core Note Satya Nadella – Day 3 The day started with the Core Note from Satya Nadella. Being alone at the conference allowed me to find one of the very last well-located seat to(…)

Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption

From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the(…)

Microsoft Inspire Partner Event 2019 / Day 2

dbi services at Microsoft Inspire Conference SQL Server 2019 is in “public preview” stage, live from Microsoft Inspire 2019 – Day 2 Anshul Rampal (SQL Server product marketing team) and Rony Chatterjee (SQL Server Core team / Product Manager) presented(…)

Microsoft Inspire Partner Event 2019 / Day 1

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

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