All articles

OUD 11.1.2.3 – How to recover a lost entry in a replicated OUD environment

By William Sescu . By accident, it could happen that someone dropped an OUD entry in your replicated environment and of course, the entry is deleted on all replicas as well. And besides that, you got no logical ldif(…)

Postgres vs. Oracle access paths VI – Index Scan

By Franck Pachot . In the previous post my queries were still reading the indexed column only, from a table which had no modifications since the last vacuum, and then didn't need to read table pages:(…)

SQL Server on Linux: Introduction to DBFS experimental tool

A couple of months ago, Microsoft announced two additional command line tools for SQL Server that are mssql-scripter and DBFS. The latter has drawn my attention because it exposes live data from SQL Server DMVs as(…)

MariaDB – How to migrate quickly MySQL to MariaDB over different hosts with mydumper/myloader and ncat

A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The(…)

Postgres vs. Oracle access paths V – FIRST ROWS and MIN/MAX

By Franck Pachot . We have seen how an index can help to avoid a sorting operation in the previous post. This avoids a blocking operation: the startup cost is minimal and the first rows can(…)

24 HOP French edition 2017 – Session videos are available

The 2nd edition of 24HOP French Edition 2017 is over and we had great sessions about SQL Server and various topics ( SQL Server 2017 new features, Azure, PowerBI, High Availability , Linux, Hyper-convergence , Modeling …) If(…)

MariaDB – Speed up your logical MariaDB backups with mydumper

By William Sescu Per default, MariaDB is shipped with a utility called mysqldump for logical backups. For more information, please take a look at the following link. https://mariadb.com/kb/en/mariadb/mysqldump/ The mysqldump has advantages, e.g. it is easy to use and(…)

Postgres vs. Oracle access paths IV – Order By and Index

By Franck Pachot . I realize that I'm talking about indexes in Oracle and Postgres, and didn't mention yet the best website you can find about indexes, with concepts and examples for all RDBMS: http://use-the-index-luke.com. You(…)

Encryption of shell scripts

In this blog, I will talk about the encryption of files and in particular the encryption of a shell script because that was my use case. Before starting, some people may say/think that you shouldn’t encrypt any scripts and I(…)

Documentum – Unable to install xCP 2.3 on a CS 7.3

Beginning of this year, we were doing our first silent installations of the new Documentum stack. I already created a few blogs to talk about some issues with CS 7.3 and xPlore 1.6. This time, I will talk about xCP(…)