All articles

How to patch Postgres Plus Advanced Server in a Standby configuration

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn't it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled(…)

SQL Server 2016: TRUNCATE PARTITIONS with sliding Windows scenarios

Some time ago, I had to deal with a new partitioning scenario that included sliding windows stuff for mainly archiving purpose. Regarding the customer context, I used some management scripts that include this time dropping oldest partition. We didn’t care about(…)

Fun with PL/SQL code reviews – Part 1

For quite a long time I did not work anymore with PL/SQL and was quite happy when I had the chance to review some code at a customer. The status today: I am not that happy anymore(…)

Documentum story – D2EventSenderMailMethod when multiple Documentum repositories are used.

When several repositories are accessed through the same Java Method Server (JMS), it might be needed to have a different dfc.properties parameters for the D2EventSenderMailMethod depending on the repository. This can be issued using an external Java call to(…)

Running a Cassandra cluster in a single server

This blog post is about the configuration of Apache Cassandra for running a cluster of 3 instances on a single host. Basically C* is not really build to run in a multi instances environment, but for many cases and reasons(…)

How to patch Postgres Plus Advanced Server

As with any other software there comes the time when you need to patch your Postgres Plus Advanced Server instances. Is that different from patching Community PostgreSQL? Yes and no :) The difference is(…)

Apache Cassandra overview

Apache Cassandra is one of the most popular NoSQL databases http://db-engines.com/en/ranking. It is used by many big companies as Facebook, Netflix and many others. Initially the project was initiated by Facebook. In combination with Google BigTable and Amazon DynamoDB,(…)

Oracle 12c and RMAN switch datafile to copy, is it really so easy?

By William Sescu Oracle incrementally updating backups are used quite often because they are easy to setup and restoring a datafile is very fast. It is very fast because you are not really restoring a datafile, you are switching to(…)

Oracle 12cR2: DDL deferred invalidation

By Franck Pachot . In a previous post I described the new V$SQL views about rolling invalidation. I did the example with dbms_stats which is able to do rolling invalidation since 11g. But more is coming(…)

Running PostgreSQL on ZFS on Linux – Compression

In the last posts in this little series we looked at how to get a ZFS file system up and running on a CentOS 7 host and how snapshots and clones can be used(…)