All articles

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”(…)

Oracle Cloud basics for beginners

Introduction Cloud, Cloud, Cloud. Everyone is talking about the Cloud but a lot of people are still in the fog with Cloud technologies. Let’s talk about basic features of the Oracle Cloud, called OCI for Oracle Cloud Infrastructure. What is(…)

Attaching your own CentOS 7 yum repository to AWS SSM

From some blogs I've written in the past you might already know that we are using AWS SSM to patch and maintain the complete EC2 and onprem instances at one of our customers. The previous posts(…)

The Oracle ACE program ♠ what it is not ♠

By Franck Pachot . I had a few questions about the Oracle ACE program recently and I thought about putting some answers there. Of course, that’s only my point of view, there’s an official web page:(…)

Some myths about PostgreSQL vs. Oracle

By Franck Pachot . I originally wrote this as a comment on the following post that you may find on internet: https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/ but my comment was not published (many links in it… I(…)

Azure Migrate: how to assess on-premises servers for a future Azure migration

Azure Migrate provides a set of tools to assess and migrate on-premise infrastructure like Hyper-V or VMware virtual machines, physical servers as well as SQL and other Databases, web application… The Azure Migrate overview page resumes the different key(…)

Documentum – Change/Rename of LDAP Config object

Using an LDAP Server with Documentum (or any ECM for that matter) is pretty common to avoid managing users locally. In this blog, I wanted to talk about something that isn’t very common and that is the change of an(…)

Power BI Report Server – URL reservation Warning – Delegation blocked

Introduction Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working(…)

Oracle non-linguistic varchar2 columns to order by without sorting

By Franck Pachot . Sorting data is an expensive operation and many queries declare an ORDER BY. To avoid the sort operation you can build an index as it maintains a sorted structure. This helps with Top-N queries as(…)

Publishing a PowerShell script to AWS Lambda

I've done some Lambda functions with Python in the past and it was quite easy to publish that to Lambda (by just uploading a zip file with all my code and dependencies). You might ask yourself(…)