All articles

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

RMAN channels in RAC

By Franck Pachot . When you want to minimize the backup or restore duration, you can parallelize RMAN operations by allocating multiple channels. If you are in cluster, you can open channels from several nodes. Let's see why, how, and(…)

ADTS 7.2 And Doc10 Office plugin

When we upgraded our ADTS 6.7 SP2 into 7.2 we realized how great the new version was! Intro The 7.2 version changed its entire structure and cleared many useless dependencies such as Adlib. Now every files and configurations are stored(…)