All articles

MySQL versions performance comparison

This blog aims to make a performance comparison between the different MySQL versions/editions and also comparing the differents MySQL forks such as Percona Server and MariaDB.  Indeed number of improvements as been done to innodb storage engine in the last(…)

dbi services wishes you a Merry Christmas with this SQL Server script

The end of the year approachs and soon it will be time to celebrate Christmas with your family and friends. At dbi services, we wish you a merry christmas via SQL Server with the following script, to execute in your(…)

How to store SQL Server data files in Azure Storage

A new functionality, introduced with SQL Server 2014, enables to store data files from a SQL Server database in Windows Azure Storage. In this posting, I will show how it works.   Accessing Azure Storage The(…)

Journées SQL Server 2014: Vidéos des sessions disponibles

Les vidéos des sessions des journées SQL Server 2014 sont enfin en ligne: > Infrastructure et AlwaysOn > Industrialisation des audits (avec Sarah Bessard) Si vous avez des questions n’hésitez pas à(…)

Oracle lateral inline view, cursor expression and 12c implicit statement result

By Franck Pachot . I’ll present here 3 ways to run a query for each result of another query. Let’s take an exemple: get all executions plan (select from dbms_xplan.display_cursor) for each of my queries (identified from v$sql). The(…)

Oracle 12c: Can we disable logging for DML?

By Franck Pachot . If we don’t mind about loosing our changes, then can we disable logging for DML? This is a question I’ve heard a lot. Ok, you don’t need to recover your changes but Oracle may want(…)

SQL Server 2014 : sortie du livre “Développer et administrer pour la performance”

Un billet en cette fin d’année qui approche à grand pas pour vous annoncer la sortie prochaine (fin décembre 2014) du livre SQL Server 2014 : Développer et administrer pour la performance en français et(…)

Taskset: a useful tool to set CPU affinity

Today at the #ukoug_tech14 I had the chance to attend to the Christo Kutrovky’s session @kutrovsky (Pythian) about “Measuring Performance in Oracle Solaris & Oracle Linux”. This session aimed to present how to measure(…)

SQL*Plus COPY Command is back as BRIDGE

By Franck Pachot . Did you ever use the COPY command in sqlplus? It’s very old, and documentation says : The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8i. The(…)

FIO (Flexible I/O) – a benchmark tool for any operating system

I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I(…)