Database Administration & Monitoring

SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM

Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands:(…)

GoldenGate 12.2.0.2 installation in a Grid infrastructure12cR2

This post is a demonstration on how to deploy a fully supported Oracle GoldenGate as cluster resources. We are going to use the Oracle Grid Infrastructure Agents, called XAG to integrate the GoldenGate instance within our cluster as a cluster(…)

Experiencing update statistics on a big table with circuitous ways

This is my first blog of this new year and since a while by the way. Indeed, last year, I put all my energy to realign my Linux skills with the new Microsoft’s strategy that opens SQL Server to Open(…)

Oracle Licensing (R)evolution with VMware

In 2015 I wrote a blog named “All you need to know about Oracle Database licensing with VMware”. This blog generated lots of comments and hopefully helped some DBAs and IT Managers understanding the potential issues that they(…)

Online datafile move in a 12c dataguard environment

By Mouhamadou Diaw Oracle 12c introduces moving online datafile. One question we might ask is what about moving datafile online in a dataguard environment. In this blog we will do some tests Below our configuration, we are using oracle(…)

Oracle 12.2 Dataguard : PDB Flashback on the Primary

By Mouhamadou Diaw The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle(…)

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 02)

In this post we are going to deploy a R.A.C system ready to run production load with near-zero knowledge with R.A.C, Oracle cluster nor Oracle database. We are going to use the “Deploy Cluster Tool” which is provide by Oracle(…)

Does pg_upgrade in check mode raises a failure when the old cluster is running?

Today I had the pleasure to have Bruce Momjian in my session about PostgreSQL Upgrade Best Practices at the IT Tage 2017 in Frankfurt. While browsing through the various options you(…)

SQL Server Tips: an orphan user owns a database role

A few days ago, I conduct an audit to detect all orphan’s windows accounts in a database and I was surprise to have an error during the drop user query.   The first step is to find all orphan’s windows(…)

How to reduce the size of an LVM partition formatted with xfs filesystem on CentOS7?

DISCLAIMER: I know it exists other solutions to do it Pre-requisites: – a virtual machine (or not) with CentOS7 installed – a free disk or partition I use a VBox machine and I added a 5GiB hard disk(…)