Development & Performance

APEX Connect 2023 (Day 1)

This year again the APEX connect conference spans over two days onsite in Berlin, with mixed topics around APEX, like JavaScript, PL/SQL and much more.After the welcome speech and the Keynote about “22.2, 23.1, and beyond” by the Oracle(…)

SHELL SCRIPTING: improve DBA scripts readability using J2 templates

Quering database's by using SQL in shell scripts can make the whole script unreadable. Very oftent the query is unredable too, due to the variable usage. This situation make the script debugging a pain. Templating simplify the script by taking(…)

Hashicorp Vault. Install and quick first configuration

by Alexandre Nestor Introduction Keeping and using passwords in scripts is often an overlooked task, at least in the initial stages of development.This behavior poses serious security problems, and quite often, especially in scripts, one can find plaintext(…)

Create and manage Ansible Execution Environments

by Alexandre Nestor Introduction What is an Ansible Execution Environnement, by the way ? As per RedHat definition an Ansible Execution Environment (EE) is a standard way to build and distribute the environment that automation runs in,(…)

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while(…)

Some tips when developing in PostgreSQL’s PL/pgSQL

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures,(…)

Oracle Exchange Partition

The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method(…)

Oracle Database Row Archiving

In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered(…)

How to contribute to YaK

Some days ago we officially launched YaK, which is our open source tool for deploying infrastructures everywhere. Because the core component of Yak is open source, can you contribute if you want. Contributions are more(…)

Data Platform Summit 2022 – Cracking Power BI Performance Tuning In A Day!

Introduction The second pre-conf I attended was about tuning Power BI. I was curious to hear and learn from Nikola  Ilic, who presented the session, what his experience and technique are dealing to solve Power BI performance issues(…)