All articles

Documentum – ActiveX error 12019 in D2-Config during export

Some months ago at a customer, we started the rollout of some security baselines on a new application (not yet productive). One of the changes was to enforce the use of TLSv1.2 on all our Documentum Clients like D2/D2-Config (4.5,(…)

Displaying the contents of a PostgreSQL data file with pg_filedump

Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don't care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted(…)

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 01)

After having worked with OVM on various architectures I can say that it is a good technology to easily build virtualized environments for production applications. Because it is based on XEN and has simple ways to deal with existing storage(…)

SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)

Before SQL Server 2016, you had the possibility to check the case “Send Windows and SQL Server Error Reports….” during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server(…)

Pass Summit 2017: how to bypass SQL Server security

Last Friday I saw a very interesting session in Pass Summit 2017 about how to Bypass, or Ensure, SQL Server security by Matt Martin. Matt explained us how to bypass SQL Server security with the complicity of your SQL(…)

Multitenant internals: INT$ and INT$INT$ views

By Franck Pachot . This month, I'll talk - with lot of demos - about multitenant internals at DOAG conference. The multitenant dictionary architecture starts with a simple idea: system metadata and data are(…)

Multitenant dictionary: what is consolidated and what is not

By Franck Pachot . The documentation says that for Reduction of duplication and Ease of database upgrade the Oracle-supplied objects such as data dictionary table definitions and PL/SQL packages are represented only in the root. Unfortunately,(…)

Can I have the same table published and subscribed (bi-directional) in PostgreSQL 10 logical replication?

When you start using PostgreSQL 10 logical replication you might think it is a good idea to setup bi-directional replication so you end up with two or more masters that are all writable. I will not go into the details(…)

Quick history on database growth

By Franck Pachot . AWR collects segment statistics, and this can be used to quickly understand an abnormal database growth. Here is a script I use to get, from the AWR history, the segments that have grown by more than(…)

Are large objects supported in PostgreSQL 10 logical replication?

Another interesting topic that popped up last week during pgconfeu: Are large objects supported with logical replication in PostgreSQL 10? The only truth is a test, isn't it? Lets go...