Database management

Running a Cassandra cluster in a single server

This blog post is about the configuration of Apache Cassandra for running a cluster of 3 instances on a single host. Basically C* is not really build to run in a multi instances environment, but for many cases and reasons(…)

Apache Cassandra overview

Apache Cassandra is one of the most popular NoSQL databases http://db-engines.com/en/ranking. It is used by many big companies as Facebook, Netflix and many others. Initially the project was initiated by Facebook. In combination with Google BigTable and Amazon DynamoDB,(…)

MySQL 8.0.0 DMR – First impression

Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First(…)

Les 24 heures du PASS (24HOP) – édition francophone

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre(…)

List usernames instead of uids with the ps command for long usernames

By William Sescu Have your ever faced such a situation. You have usernames in your /etc/passwd file with more than 8 characters. This is no problem for Linux at all, usernames may be up to 32 characters long, only your(…)

DBA essentials workshop with release Oracle 12c is Available

It’s with pleasure to announced dbi services have upgrade the infrastructure for Oracle DBA essentials workshop. We have migrate the release of Oracle 11g R2 to the latest version Oracle 12c features and install the last PSU (April 2016).

Which parameter changes do require a restart of my PostgreSQL instance?

Starting wiht PostgreSQL 9.4 you can change parameters in postgresql.conf with the "alter system" command in psql. In principle every parameter can be changed that way but not every parameter is applied immediately. Some of(…)

SCOM: change group state to maintenance mode with PowerShell

Some weeks ago, I wrote a blog post about the creation of SCOM groups in order to subscribe to alerts. Subscribe to alert is mandatory, of course, to be able to receive alerts concerning our group. But during operations(…)

SQL Server 2005 decommissioning failed!

The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last(…)

SQL Server 2016: new tools management strategy

A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… 😉 A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools(…)