Database Administration & Monitoring

And finally it is there…PostgreSQL 10

What are you waiting for?(…)

udev rules for ASM devices on RHEL 7

Preparing the storage devices for use with ASM is one of the first tasks you should do. When you do not want to use ASMLib then udev is what you should use for this.

Going from SLES12 SP2 to SLES12 SP3, online

SLES 12 SP3 was released some time ago and as we have customers running on that I thought it might be a good idea to test the upgrade from SP2 to SP3. Actually it turned out this(…)

SQL Server 2017 RTM is available: time to try!

Now SQL Server 2017 RTM  is available. 😀 The first step is to go to the Evaluation Center here After completing the registration with your contact information, you download the(…)

SQL Server 2017 on RHEL first installation

Beginning of last week Microsoft announced the general availability of SQL Server 2017 for today, the second of October. In the same time, but in a more marketing side, Microsoft announced a SQL Server on Red Hat Enterprise(…)

SQL Server 2016: New Dynamic Management Views (DMVs)

In SQL Server 2016, you will discover a lot of new Dynamic Management Views(DMVs). In this article, I will just give you a little overview of these useful views for us as DBA. SQL Server 2012 has 145 DMVs(…)

Announcing the dbi OpenDB Appliance

As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are(…)

Searching wikipedia from the command line

Wouldn't it be nice if you could search wikipedia from the command line? I often need to quickly look up a definition or want to know more about a specific topic when I am working on the command(…)

Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives

Today, after we did a fresh setup of a Grid Infrastructure cluster (12.1.0.2.170814) we faced two issues reported in the alert.log of the ASM instances (in fact you would see the same for the alert logs of any instance in(…)

Bequeath connect to PDB: set container in logon trigger?

By Franck Pachot . There are little changes when you go to multitenant architecture and one of them is that you must connect with a service name. You cannot connect directly to a PDB with a beaqueath (aka local) connection.