All articles

Boost dynamic SQL with Plan Guides

Recently a customer asked me to check why a load process from a banking application has so poor performance.In fact this process is extremely slow, between 40 minutes up to more than one hour to load around 240’000 rows. As(…)

Doc.SERIES – The « User Friendly » ECM solution

There are several Electronic Content Management tools (ECM) on the market that are very powerful in their functionalities but are not always easy to configure or maintain, particularly if the size of your company does not allow for a large(…)

It takes a whole village to…

This blog is – spoiler alert – not about technology. It’s not about the latest coding tweaks or the most efficient use of fancy applications – some of them I don’t even know how to pronounce their names. Instead, I’d(…)

SQL Server Integrated acceleration & offloading

Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration & offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to(…)

Cloudbees CD/RO, send and receive parameters with bash / Ansible scripts

Sending a pipeline parameter to a bash or Ansible script is easy, but the reverse is less obvious. In this article, we’ll look at how to return parameters from an Ansible script to a Cloudbees CD/RO job. The easy way(…)

Monitor Microsoft SQL Server with Zabbix

In this blog post, we will quickly see what is required to monitor a Microsoft SQL Server with Zabbix. Agent Setup Agent setup is not required by MSSQL by ODBC template; thus this step can be skipped. Setup Monitoring Account(…)

Manage SSH public keys with Oracle Key Vault (2/2)

Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).

Manage SSH public keys with Oracle Key Vault (1/2)

Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).

PostgreSQL 17: Reset shared statistics at once with pg_stat_reset_shared()

PostgreSQL comes with several catalog views which expose cluster wide statistics. One of them is the new pg_stats_checkpointer view we’ve talked about previously. To reset some of those statistics there is pg_stat_reset_shared().

Cloudbees CD/RO, Pipelines advanced parameters

Cloudbees CD/RO is a highly flexible tool. You can define your own customized parameter forms for pipelines or procedures.For example, the same parameter form can be adapted according to the users: user-friendly for common users or more permissive for admin(…)