All articles

Tracking Logs Inside a Documentum Container (part II)

Testing the log watcher This is part II of the article. Part I is here. All the above code has to be included in the entrypoint script(…)

Tracking Logs Inside a Documentum Container (part I)

Containers running under docker can have their stdout observed from the outside through the “docker logs”command; here is an excerpt of its usage: docker logs --help Usage: docker logs [OPTIONS] CONTAINER Fetch the logs of a container Options: --details Show(…)

SQL Server Tips: Path of the default trace file is null

In addition of my precedent blog about this subject “SQL Server Tips: Default trace enabled but no file is active…”, I add a new case where the default path of the trace file was empty. The(…)

Adding PostgreSQL extensions without being super user?

Usually, when you need to install a PostgreSQL extension you do this as superuser (or at least I am doing it like this). The downside of that is, of course, that a super user must be available once a new(…)

Make Oracle database simple again!

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can(…)

One day training @ Microsoft Azure Cloud Workshop

Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about(…)

SQL Server Tips: Orphan database user but not so orphan…

Beginning of this year, it is good to clean up orphan users in SQL Server databases. Even if this practice must be done regularly throughout the year of course. 😉 During my cleaning day, a new case appears that(…)

PostgreSQL 13: parallel vacuum for indexes

Because of its implementation of MVCC PostgreSQL needs a way to cleanup old/dead rows and this is the responsibility of vacuum. Up to PostgreSQL 12 this is done table per table and(…)

Deploying your own PostgreSQL image on Nutanix Era – 2 – Deploying a new PostgreSQL VM

In the last post I described how you can create your own PostgreSQL image in Nutanix Era. In Nutanix wording this is a "Software profile". This profile can now be used to deploy PostgreSQL VMs with(…)

Dbvisit 9: Adding datafiles and or tempfiles

By Mouhamadou Diaw One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit(…)