All articles

Linux Serververwaltung mit Puppet leichtgemacht

Mit Puppet die Linux-Server verwalten   Sind mehrere Linux-Server vorhanden, dann entsteht sofort ein Aufwand die unzähligen Konfigurationen ( ntp, chrony, dns, users, groups, services etc.) zu administrieren. Jeder Administrator möchte möglichst alle Server auf die gleiche Weise konfiguriert haben,(…)

Interested in a deep dive of logical replication?

By Franck Pachot . It's next week at #DOAG2015 Interested in a deep dive of logical replication? Let's try it. The best way to learn is to try it and this is the idea of #RepAttack where you can quickly(…)

Software architecture vs code representation

Tuesday the 10th of November I attended a public lecture at Swiss Java User Group in Zürich. Topic of the pretension was to describe and address challenges any project manager can encounter, when reflexion switches from perspective of software(…)

set “_rowsets_enabled”=false

By Franck Pachot . This 12c 'wrong results' issue is thoroughly described by Mike Dietrich (https://blogs.oracle.com/UPGRADE/entry/switch_off_rowsets_enabled_in) and I've nothing to add. This blog post is there to be used as a reference for the comment in(…)

Journées SQL Server (JSS) 2015 à Paris – Sessions & Sponsoring

Faisant suite à la première annonce de David Barbarin sur les journées SQL Server du 30 novembre et 1er décembre, j’ai le plaisirs de vous inviter à venir nous voir également(…)

Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available

We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for(…)

SQL Server 2016: IF EXISTS is included in the DROP command

With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested(…)

GoldenGate – Error during a register extract

This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the(…)

AWR when ASH CPU >> DB CPU

By Franck Pachot . I'll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is(…)

SQL Server Collation for System Center Products

A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in(…)