All articles

Understanding XML performance pitfalls in SQL Server

A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.

Two days at the KCD Suisse Romande

The 4th and 5th december, I attended KCD Suisse Romande in Geneva. It was a great event in a great place with great people. I really enjoyed the talks and the workshops. First Day: the workshops After(…)

How to patch your ODA to 19.29?

How to patch your Oracle Database Appliance to 19.29(…)

Extend Session Timeout in GoldenGate Microservices Web UI

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice. Since there is no clear Oracle documentation on that matter, here are multiple ways(…)

Dctm – OTDS SSO with sAMAccountName AD/LDAP attribute and Azure

The OpenText Directory Services (OTDS) is a pretty interesting piece of software, and it works quite well out-of-the-box. If you are starting to use the OTDS from scratch (when you have nothing internally), then there isn’t much problem, you(…)

Shell and Perl in one script

To run a Perl script directly like a binary from within the shell, you have to set the executable flag on the script Add the shebang line (the 1st line (#!...) specifiyng the interpreter to use) #!/usr/bin/env perl(…)

Dctm – D2 SSO through OTDS fails with DM_LICENSE_E_INVALID_LICENSE

After doing some more upgrades from Documentum 20.2 to 23.4, including D2, I faced a funny error about invalid licenses (DM_LICENSE_E_INVALID_LICENSE) while trying to login to D2 through OTDS SSO. That’s interesting because there is no license management for(…)

M-Files vs. SharePoint vs. Documentum vs. Alfresco: Which ECM Fits Your Business?

For over 15 years, I have been exploring the world of Enterprise Content Management (ECM). Although this sentence reminds me that I’m getting old, that’s not the point! Above all, I have accumulated a fair amount of knowledge(…)

Oracle to PostgreSQL Migration with Flink CDC

Introduction When wanting to migrate from the big red to PostgreSQL, most of the time you can afford the downtime of the export/import process and starting from something fresh. It is simple and reliable. Ora2pg being one of the(…)

Common queries on a SQL Server environment for a DBA

This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin(…)