All articles

SQL Server: Is Fill Factor applied during INSERT?

The Fill factor setting controls the amount of space that is left available on the index data pages. The goal is to allow new rows to be inserted or existing ones to change size (UPDATE)  without resulting in(…)

PostgreSQL 15: read some options for pg_dump from a file

PostgreSQL 15 will probably come with a new feature for pg_dump: Instead of passing the arguments/options directly to pg_dump when it is executed, you may also use a file to describe what you want to export. In(…)

ODA and KVM: Debugging of DBsystem creation failure

Debugging errors when working with ODA is not always the easiest thing do... :-P It may become a bit tricky and not a straightforward process. In this blog I wanted to show you and example we faced with the debugging(…)

ODA update-server to 19.12 fails on Patch GI with RHP

Sometimes giving a workshop is a good opportunities to test new things...this what happened to me today...  :-) While giving an ODA workshop, I thought it was a good opportunity to test patching to the new 19.12 release. However during(…)

PostgreSQL Flexible Server on Azure, scram-sha-256 workaround

Microsofts old Single Server for PostgreSQL on Azure offers password encryption md5 only, normaly IT Governance responsible people getting nervous by that. On the new Flexible Server for PostgreSQL on AZure md5 is still the default setting, but a(…)

Configuring ODBC : SQLServer Access From Oracle

By Mouhamadou Diaw Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration(…)

Why does my first tablespace in PostgreSQL always get the OID 16384?

For those already familiar with this topic and wonder about the heading, hold on and continue reading. One of the exercises we do in our PostgreSQL DBA Essentials workshop is to create a tablespace. This is to(…)

Oracle Database Appliance KVM Virtual Instance on ODA 19.12

By Mouhamadou Diaw KVM virtualization uses a kernel-based virtual machine (KVM) to create a virtualized environment for your Linux applications.In this blog I want to share some tasks I did at a client. The client is using ODA 19.12.

Oracle Database Appliance 19.12 Deployment

By Mouhamadou Diaw In this blog I am describing the deployment of an ODA with the version 19.12 Following patches will be needed -Patch 30403643: Oracle Database Appliance ISO Image -Patch 30403673: Oracle Database Appliance Grid Infrastructure Clone(…)

How to efficiently add constraints to existing tables in PostgreSQL

Is is not a surprise that applications change over time. New tables get added, columns need to be changed or new ones are required, and sometimes you need to add check constraints or foreign keys to already existing tables which(…)