Database Administration & Monitoring

Create and configure an Oracle linked server in SQL Server Instance

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit(…)

DBPod – le podcast Bases de Données

By Franck Pachot . J’essaie quelque chose de nouveau. Je publie beaucoup en anglais (blog, articles, présentations) mais cette fois quelque chose de 100% francophone. En sortant du confinement, on reprend les transports (train, voiture,…) et c’est l’occasion de(…)

Terraform Import from AWS

I came accross an issue by a customer using aws and terraform. He created a server with ebs volume attached to it but he deleted the volume by mistake. He then recreated it manually without using the terraform to do(…)

The log_duration parameter in PostgreSQL

log_duration is a useful point for finding slow running queries and to find performance issues also on the applications side using PostgreSQL as database. Another topic is finding issues with Java Applications using Hibernate after a(…)

The myth of NoSQL (vs. RDBMS) “joins dont scale”

By Franck Pachot . I’ll reference Alex DeBrie article “SQL, NoSQL, and Scale: How DynamoDB scales where relational databases don’t“, especially the paragraph about “Why relational databases don’t scale”. But I(…)

Microsoft Teams, Power Automate and Planner

As we moved to Teams at dbi and one of our customers, automating tasks was a strong need. One of the tasks that could be automated is the creation of tasks in Microsoft Planner which does not support recurring tasks.

Oracle Data Guard RedoRoutes : What is Priority 8 ?

By Mouhamadou Diaw When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is(…)

Oracle Autonomous Linux: cron’d ksplice and yum updates

By Franck Pachot . Oracle Enterprise Linux (OEL) is a Linux distribution which is binary compatible with Red Hat Enterprise Linux (RHEL). However, unlike RHEL, OEL is open source, free to download, free to use, free to distribute, free(…)

Oracle GoldenGate 19c: Cannot register Integrated EXTRACT due to ORA-44004

The global_name in an oracle database has a direct impact on the Golden Gate Extract process registration we need to do when we create an Integrated Extract. In my example below, I use Oracle GoldenGate MicroServices architecture but the same(…)

Postgres Vision 2020 is still live

This year the Postgres Vision 2020 conference was a Free Virtual Event that took place on June 23-24, 2020 and the Postgres Vision Theme was “Postgres is for builders”(…)