All articles

Exploration of Calico in Minikube

If you are interested to learn Calico locally on your machine, it is possible to use it with Minikube. Minikube is a tool that sets up a Kubernetes environment on your local machine. It works on Windows, MacOS and Linux and(…)

Patching your ODA may enable all cores!

Introduction If you use Enterprise Edition on your Oracle Database Appliance environment, and if you don’t have unlimited licences, you probably lowered the CPU cores available on each server to dispatch your licences accross your environment. This operation is normally(…)

MySQL Server on Microsoft Azure 2nd part (Performance tests)

Azure Database for MySQL Introduction This second blog follows the first blog about deploying MySQL Server on Microsoft Azure. In the first blog, we saw how easy it is to deploy a MySQL server in minutes(…)

SQL Server 2022 security: Do you know Ledger?

You probably hear or view that on the security point of view, the next version of SQL Server: SQL Server 2022, has a feature named Ledger. It’s already used in Azure but what is Ledger? In 2 points, I will(…)

MySQL Server on Microsoft Azure 1st part (deployment)

Let’s try Azure Database for MySQL Introduction Did you know that you can run MySQL on Microsoft Azure for free for 30 days with a $200 credit? In this first blog I’ll show how to create a MySQL Server and(…)

Configure Oracle DB for using Large Pages on AIX

When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes(…)

PostgreSQL Cluster using repmgr

With this blog I describe the installation of a PostgreSQL Cluster using repmgr instead of Patroni. Repmgr was originally developed by 2ndQuadrant which is now part of EDB and EDB decided for the 2ndQuadrant tools for the future, barman as(…)

Performance problems on a ZyWALL USG

ZyWALL USG 50 Are you experiencing performance problems with your Zyxel ZyWALL USG firewall? You will find in this blog an example of a real case I faced and how I solved it. Introduction From one day to the next,(…)

SQL Server Deadlock on UPDATE with Serializable isolation level

Recently I spent some time on a recurring Deadlock problem on a customer’s site in a high concurrency environment. It was only after finding the solution on my own that I discovered that this particular problem is already well documented(…)

SQL Server Security: Check if the guest is active on all user-databases through the CMS

Today, a customer asks me to have look on each SQL Server instance to control if the user-database Guest is active or not. The easiest way is to go through the CMS (Central Management Servers) with a query but witch(…)