All articles

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

Control-M/EM How to manage a workflow with ecaqrtab utility

Introduction Before the freshly come “workload manager”  feature on latest Control-M versions, the Control-M users used a lot of workarounds to manage the workload execution. Using Quantitative resources was one of the most used. Request We need to trigger a(…)

A Serverless Standby Database called Oracle Autonomous Data Guard

By Franck Pachot . Announced by Larry Ellison last week, here it is: the Autonomous Data Guard. You can try it, unfortunately not on the Free Tier. First you create an Autonomous Database (ATP or ADW) and then(…)

Create and configure an Oracle linked server in SQL Server Instance

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit(…)