Development & Performance

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(…)

Data Platform Virtual Summit Pre-con 2022

Thanks to dbi services to let me the opportunity to follow this week and next week, the Data Platform Virtual Summit beginning with the Pre-con. I subscribe the session of Guy Glantser about(…)

Extract all DDL from an Oracle database

Introduction Extracting DDL is sometime useful for creating similar objects in another database without data. Basically everything can be extracted from a running Oracle database. The needs My customer asked me to replicate a database without any data. The goal(…)

SSDT offline installation for Visual Studio 2019

Introduction Before Visual Studio 2019, you were able to install the SSDT with the offline installer. You were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was(…)