Database Administration & Monitoring

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

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

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

Getting started with Red Hat Satellite – Initial configuration

In the last post it was all about the Installation of Red Hat Satellite and the components that are used under the hood. In this post it is about doing the initial configuration so that packages(…)

Getting started with Red Hat Satellite – Installation

This is the start of a series of posts I wanted to write for a long time: Getting started with Red Hat Satellite. Just in case you don't know what it is, this statement from the official Red Hat website(…)