All articles

Autonomous Database

By Franck Pachot . Larry Ellison has announced Oracle 18c to be the Autonomous Database, the no-human labor, and self-driven, database. Here is a quick recap of what it is behind the marketing words. My opinion only.

Changing the LOCALE in CentOS/RedHat 7

What I really don't like is this: Someone wants me to work on a Linux system for whatever purpose and then I get messages like this: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permission non accordée or: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger(…)

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

ODA X7

By Franck Pachot . ODA X6-2 So, the ODA X6 End of Life seems to be planned for October, and be careful, as far as I know, this concerns also the storage expansion. The main feedback from the X6-2 series(…)

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

Oracle 18c RU and RUR for pioneers and followers

By Franck Pachot . In a previous post, I explained the announcement of the new release model, with Release Updates and Release Update Revisions replacing Proactive Bundle Patch and PSUs. Here is a description that will(…)

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