Development & Performance

Scripting is not Just a Series of Commands

I saw, several times now, scripts were it is just a series of commands, sometime just created with copy/paste and few changes. This is far from best practices in terms of readability, maintainability and debug (ability 🙂).

SQL Server 2019: Java in SQL Server hard to believe, no?

It has already been a few months that we are testing the next version of SQL Server: SQL Server 2019. I already blogged about a previous version of SQL Server supporting R and Python. With the new version(…)

work Agile in a GxP-regulated environment

On 4 June 2019 I followed an invitation to wega-it’s Know-how & Networking Breakfast 2 2019 on “Agile Validation in GxP Projects”. So they were to discuss Agility in the context of GxP regulation. I had some earlier exposure to(…)

APEX Connect 2019 – Day 1

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome speech and the very funny and interesting Keynote about “PL/SQL: A Career Built On(…)

RCSI with foreign keys, NULL values and paramater sniffing behavior

In this blog post let’s go back to the roots (DBA concern) with a discussion with one of my friends about a weird transaction locking issue. In fact, this discussion was specifically around two questions. The(…)

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)

SQL Tuning – Mix NULL / NOT NULL Values

One of the difficulty when writing a SQL query (static SQL) is to have in the same Where Clause different conditions handling Null Values and Not Null Values for a predica. Let’s me explain you by an example : Users(…)

Recover a corrupted datafile in your DataGuard environment 11G/12C.

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to(…)

Pass summit – day 4

Optimizing Multi-Billion Row Tables in Tabular in 2018   I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is(…)

A SQLite extension for gawk (part II)

Welcome to part II of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is followed by(…)