Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server I tried to balance between SQL and SharePoint related sessions. BYOD As usual, the day started with a Keynote focusing on…
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, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel.…
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 Les difficultés qu’un projet de migration doit affronter Le premier post porte sur l’installation d’ora2pg, un des outils disponibles sur internet.…
One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the…
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 16965974: 12.1.1.1.0 FULL INSTALL IMAGES FOR ORACLE AUDIT VAULT AND DATABASE FIREWALL There are three files: 1. Audit Vault Server 2.…
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 part of it, changing only the collation on the database. In this blog I will explain the methodology that allows…
La version 12c d’Oracle Grid Infrastructure introduit de nombreuses nouveautés dans le support d’ACFS, le système de fichiers clusterisés d’Oracle. Nous abordons dans ce posting la capacité d’ACFS d’être le système de fichier de votre base de données ainsi que sa capacité de mise en œuvre des snapshots. Rappel sur ACFS Ce système de fichier est apparu avec la version 11.2 du…
Some days ago, Microsoft published the sixth Cumulative Update (CU6) for Microsoft SQL Server 2012 Service Pack one, two months after the fifth one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it and just have a look at it. Which issues are covered by this CU6? It…
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 becomes UNUSABLE when dropping or truncating the partition on which this index points, until the clause UPDATE GLOBAL INDEXES is used.…
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 Grid Infrastructure de la 12c. Le contexte Au préalable, il faut avoir installé Grid Infrastructure et créé une CDB (Container Database)…
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 that, I have written a tiny test protocol composed of two parts: Session 1: starts a batch (schema BATCH) processing which…
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 this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might…
