Database management

SQL Server 2014: An overview of the New Features

The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1’000 participants in Basel,(…)

Migration d’Oracle vers PostgreSQL avec ora2pg

Le propos des trois posts PostgreSQL qui vont suivre, est de présenter: la mise en place d’un outil d’aide à la migration d’une base Oracle, au sens du schéma, vers une base PostgreSQL L’utilisation de cet outil, nommé ora2pg(…)

Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox

This blog explains how to install Oracle Audit Vault and Database Firewall (AVDF) 12.1.1.1.0 on VirtualBox step-by-step. The configuration will be covered in a second blog. Download AVDF Binaries First of all, download the binaries on support.oracle.com: https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?_afrLoop=140865428570210&patchId=16965974&_afrWindowMode=0&_adf.ctrl-state=1a5l4hvifo_4 Patch(…)

Collation changes in Microsoft SQL Server are not that simple

Lots of DBAs are changing the collation of their SQL Server databases without knowing exactly what they do and the consequences of this change. And as they don’t know what they do, they often only perform the small and easiest(…)

Oracle 12c: Partitioning enhancements Part II – Other improvements

Oracle Database 12c offers several enhancements for partitioning. In a previous blog posting, I talked about reference partitioning enhancements. This post will present other enhancements in relation to general partitioning. Asynchronous index maintenance With Oracle database, a global index(…)

Oracle Database 12c : démarrage automatique des Pluggable Databases

Dans ce blog post, nous allons nous intéresser à la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l’arrêt et le démarrage automatiques des PDBs en utilisant le Server Control (srvctl) du(…)

Oracle Database 12c: The secret of moving datafiles online

Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do(…)

Oracle Database 12c: PDBs not fully transportable yet

One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of(…)

Oracle Database 12c: SecureFiles enhancements

Oracle Database 12c features with some enhancements for LOB objects and particularly for the SecureFiles. This is not a revolution, but we can see that the range of possibilities with LOB objects increases with the different releases of Oracle…(…)

Oracle Database 12c new features: segregation of duties with new administrative roles

Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data(…)