BE SHARING

All articles

Las Vegas, from sin city to green city?

14.09.2023 by Grégory Steulet

Introduction Oracle CloudWorld 2023 will start next week in Las Vegas, and I’m happy to participate in this worldwide event. As a Swiss citizen, when I think of Las Vegas, the first image that comes to my mind is that(…)

Database Administration & Monitoring

No more snapshot too old in PostgreSQL 17

08.09.2023 by Daniel Westermann

Currently PostgreSQL has a feature which is called snapshot too old. While each release of PostgreSQL comes with a bunch of new features, sometimes features also get removed. Starting with PostgreSQL 17 there will be most likely no more “snapshot(…)

Database management

Do we need DBAs in 2023?

08.09.2023 by Adrien Obernesser

Introduction : Over the past months, people asked me more and more questions about the DBA role and the underlying question was often: Are we witnessing the end of the DBA role in IT? My first answer, after a big(…)

Database Administration & Monitoring

How to code better?

07.09.2023 by Oracle Team

Sysadmins are traditionally more operators than developers, they code mainly scripts for automation reasons (shell scripts, Ansible, Terraform, aso). In addition, they can find themselves in situations where they need to analyse code or even decompile programs. Some sysadmins lack(…)

Application integration & Middleware

Zabbix Report Scheduler Setup and Troubleshooting

07.09.2023 by Olivier Spiesser

I wanted to test the Zabbix report scheduler. In this blog, I will explain how to do it as well as the different issues I faced (with cause and resolution, obviously 🙂 ). By the way, report scheduler is a(…)

Database Administration & Monitoring

“create user”, “create role”, what should be used in PostgreSQL?

05.09.2023 by Daniel Westermann

Recently we’ve seen a video on YouTube which recommends not to use the “create user” command in PostgreSQL and instead always use the “create role” command. It was also mentioned that “create group” should not be used as well. We’ve(…)

Application integration & Middleware

Zabbix Better Storage

05.09.2023 by Olivier Spiesser

Among the different possibilities for Zabbix storage, one piqued my curiosity: TimescaleDB TimescaleDB is a time series database plugin for PostgreSQL. Joël Cattin already blogged about it here from a general point(…)

WebLogic

JBoss EAP 7 – Use vault to protect passwords

04.09.2023 by David Diab

JBoss EAP simplifies a lot of server configuration by consolidating all subsystem configurations into a single XML file (standalone.xml or domain.xml). This, however, can expose sensitive information to any user that has access to the configuration files. For example, datasource(…)

Database Administration & Monitoring

PostgreSQL 17: Allow “\watch” to stop based on the number of rows returned

04.09.2023 by Daniel Westermann

psql already is really powerful but still it gets more features with almost every release of PostgreSQL. One example is the “\watch” meta command. This command was introduced in PostgreSQL 9.3 and hasn’t changed much since(…)

Application integration & Middleware

Zabbix Configuration with API

01.09.2023 by Olivier Spiesser

Despite the will of Zabbix to be as automated as possible, some tasks cannot be automated. Nevertheless, Zabbix offers an HTTP-based API which can be used programmatically. This opens the door to huge possibilities in terms of automation. JSON-RPC JSON-RPC(…)