Database Administration & Monitoring

Deploy DC/OS using Ansible (Part 2) – Playbooks

Finally, after all the configuration stuff is done, we can run the playbooks Create SSH Access First the SSH Access on all nodes need to be created. Therefore the access-onprem.yml is used: Be careful, I used CentOS on(…)

Deploy DC/OS using Ansible (Part 1) – Getting Started

To start into this topic I want to shortly explain some basics. Afterwards I show you how to prepare the configuration files.

Some psql features you are maybe not aware of

It is the time of The 10th Annual PostgreSQL Conference Europe, so this is the perfect time to blog about some tips and tricks around psql you'll love. psql is such a(…)

Getting in touch with shareplex

Tuesday this week I had the opportunity to get in touch with shareplex, Quest’s replication solution. This product does not rely on Oracle licenses, so can also be used with Standard Edition. It is competitor of Oracle’s GoldenGate an used(…)

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