All articles

A lesson from NoSQL (vs. RDBMS): listen to your users

By Franck Pachot . I have written a few blog posts about some NoSQL (vs. RDBMS) myths (“joins dont scale”, “agility: adding attributes” and “simpler API to(…)

SQL Server Installation Wizard error : Failed to retrieve data for this request

Today I faced a strange issue when I tried to install a new SQL Server instance : Failed to retrieve data for this request This error occurred just after clicking on “New SQL Server stand-alone installation…”(…)

ODA: odacli now supports Data Guard in 19.8

Introduction I’ve been dreaming of this kind of feature: just because most of the ODA configurations now include Disaster Recovery capabilities, through Data Guard or Dbvisit standy. If Dbvisit will obviously never be integrated to odacli, the lack of Data(…)

SQL Server: Change Availability Group Endpoint Ownership

I’m doing some cleaning on my customer’s instances. I want to delete the login of a previous DBA for 2 reasons; this person does not work anymore in my customer’s company and all DBA are members of a group(…)

Git collaboration: quick start

Git collaboration: quick start If you want to keep the git repository of your project clean and predictive (which is highly recommendable), here is a simple workflow to follow. For the sake of this article, we are going to(…)

Changes that I like in the new MySQL 8.0.21

A new release of MySQL was out on July 13 (8.0.21). Among all the changes, there are some that I have already tested and that I really appreciate.

Control-M/EM Sending alert to SNMP

Hello everybody, today we will see how to send Control-M alerts to a central monitoring software Introduction The aim is to send alerts and logs from Control-M to an event manager system such as Patrol/ BMC Truesight or Nagios.

Java and InfluxDB http api

InfluxDB InfluxDB is a powerfull open source time series database (TSDB) developped by InfluxData. It’s a database optimized for time-stamped or time series data. Time series data are simply measurements or events that are tracked. It is particully interresting(…)

The myth of NoSQL (vs. RDBMS) “a simpler API to bound resources”

By Franck Pachot . NoSQL provides an API that is much simpler than SQL. And one advantage of it is that users cannot exceed a defined amount of resources in one call. You can read this in(…)

Oracle ASH SQL_PLAN_LINE_ID in adaptive plans

There are several methods to find out where time is spent in an execution plan of a query running in an Oracle database. Classical methods like SQL Trace and running a formatter tool like tkprof on the raw trace, or(…)