All articles

Learning Azure by having fun with ChatGPT

Learn Azure with ChatGPT to get a story around all the concepts and components of Azure. It becomes visual and you'll get some fun with it.

Monitor Elasticsearch Cluster with Zabbix

Setting up Zabbix monitoring over an Elasticsearch cluster is quiet easy as it does not require an agent install. As a matter a fact, the official template uses the Elastic REST API. Zabbix server itself will(…)

Power BI Report Server: unable to publish a PBIX report

Introduction I installed a complete new Power BI Report Server. The server had several network interfaces to be part of several subdomains. In order to access the Power BI Report Server web portal from the different subdomains I defined 3(…)

PostgreSQL 17: pg_buffercache_evict()

In PostgreSQL up to version 16, there is no way to evict the buffer cache except by restarting the instance. In Oracle you can do that since ages with “alter system flush buffer cache“, but not(…)

Apache httpd Tuning and Monitoring with Zabbix

There is no tuning possible without a proper monitoring in place to measure the impact of any changes. Thus, before trying to tune an Apache httpd server, I will explain how to monitor it with Zabbix. Setup Zabbix Monitoring Apache(…)

ODA X10-L storage configuration is different from what you may expect

Introduction Oracle Database Appliance X10 lineup is available since September 2023. Compared to X9-2 lineup, biggest changes are the AMD Epyc processors replacing Intel Xeons, and new license model regarding Standard Edition 2, clarified by Oracle several weeks ago.

PostgreSQL 17: Split and Merge partitions

Since declarative partitioning was introduced in PostgreSQL 10 there have been several additions and enhancements throughout the PostgreSQL releases. PostgreSQL 17, expected to be released around September/October this year, is no exception to that and will come with two(…)

DevOps Best Practice – Backup and Share your work with GitHub

DevOps best practice to backup and share files by using GitHub. Learn to synchronize the files in your machine with a GitHub repository.

Faster Ansible

Even if Ansible is powerful and flexible, it can be considered “slow”. It will be anyway faster, and more consistent, than doing the same steps manually. Nevertheless, we will experiment to make it even faster. I found few of them(…)

PostgreSQL 17: Add allow_alter_system GUC

Some time ago I’ve written about the options to disable the “alter system” command in PostgreSQL. While there is nothing up to PostgreSQL 16 to do this natively, there are solutions for this requirement (see linked(…)