All articles

Oracle OpenWorld 2018: Day 3

By Mouhamadou Diaw Today my first session was about GDPR Data Security in the GDPR Era. It was presented by Joao Nunes, IT Senior Manager, NOS Tiago Rocha, Database Administrator, “Nos Comunicaões, Sa.” Eric Lybeck, Director, PwC(…)

Oracle OpenWorld 2018: Day 2

By Mouhamadou Diaw Today is my second day of Oracle OpenWorld 2018. I can now go to the Moscone Center without GPS (cool) and then I decided to follow a MySQL session (my boss will be happy). Yes my first(…)

SQL Server availability groups, SQL Browser and Shared Memory considerations

Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating(…)

Oracle OpenWorld 2018: Day 1

By Mouhamadou Diaw The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive. This session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team(…)

Oracle OpenWorld 2018: Day 0

By Mouhamadou Diaw Today was the day 0 for the oracle Openworld 2018. The event is officially not started but there were many nice entertainments to discover and enjoy San Francisco. The one Gregory Steulet (CFO of dbi services)(…)

Use PowerShell To Access a WebService

Ten monthes ago, when I started to work for DBI at a customer site, I had to work on groups managing the server accesses. The information can be queried via a simple web site: enter a server and it provides(…)

Schema only account with Oracle 18.3

With Oracle 18.3, we have the possibility to create schemas without a password. Effectively in a perfect world, we should not be able to connect to application schemas. For security reasons it is a good thing that nobody can connect(…)

Monitoring Linux With Nmon

By Mouhamadou Diaw I was looking for tools to monitor linux servers and I found an interesting one nmon ( short for Nigel’s Monitor). I did some tests. In this blog I am describing how(…)

Inheriting super user privileges over a role automatically in PostgreSQL

In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in(…)

Where come from Oracle CMP$ tables and how to delete them ?

Regarding the following "MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)", we know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names that include "CMP",(…)