Database management

SQL Server 2014: Rebuilding Clustered Columnstore Indexes

I was surprised that you have to rebuild indexes that are stored In Memory. My previous posting “SQL Server 2014 – New Features: xVelocity memory optimized columnstore index” explains all processes connected with columnstore indexes. In this article, I(…)

Oracle 12c: Applying PSU 12.1.0.1.1 with Multitenant DB & unplug/plug

The concept of Multitenant databases, which was introduced with Oracle 12c in June 2013, allows to run several databases on a single instance. Oracle presents this feature as a good solution for Oracle patching. The reason behind it is(…)

Implementing Oracle Database as a Service (DBAAS)

Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c. Why Database as a Service is interesting When(…)

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