All articles

Oracle Enterprise Manager 12c: creation and management of administrators through emcli

Cloud Control 12c (and the former Grid Control 11g) offers the possibility to create administrators and manage their privileges through the “emcli” command line utility. The main advantage of this method (based on scripts) is to be able to reproduce(…)

SQL Server 2012: new permissions

For this end of the year, I decided to present you the new permissions on SQL Server 2012. How to have a list of all permissions ? It’s very simple with this query: SELECT * FROM sys.fn_builtin_permissions(”) SQL(…)

Migrating to Oracle OEM Cloud Control 12.1.0.2.0

I recently upgraded from Enterprise Manager Cloud Control 12.1.0.1.0 to the most recent version 12.1.0.2.0. This document describes the migration procedure and the different problems encountered. The first point to know when you are about to upgrade an existing Enterprise(…)

Oracle APEX 4.2 HTML 5 item types

In this blog, I will explore the HTML 5 new item type features of Oracle APEX 4.2. The objective is to use the new number, e-mail, phone number and url html 5 item type and the native browser validation capability.

Barman: une solution pour vos backups PostgreSQL

L’objet de ce posting est de décrire la mise en place et l’utilisation d’un gestionnaire de sauvegarde pour un cluster de  base postgresql. Barman – acronyme de “backup recovery manager”- pour PostgreSQL est le logiciel sur lequel nous nous(…)

SQL Server 2012 SP1: First Cumulative Update (CU1) now available

A couple of days ago (20 November 2012), Microsoft rolled out the first cumulative update (CU1) for SQL Server 2012 Service Pack 1 (SP1). It’s just two weeks after the release of the first Service Pack (SP1) we are(…)

Risk and Health Assessment Program for Microsoft SQL Server

I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is(…)

Oracle Apex 4.2 now released

Oracle Apex 4.2 is now available on the Oracle Website. It is available since 12 october 2012. This new release comes with new features briefly described in this blog posting. First of all, here are the new features delivered by(…)

Unable to resize tmpfs on Oracle Enterprise Linux 6 versions

I recently helped to create a lab dedicated to a training about Oracle backup and recovery, with Oracle 11g databases. While creating several databases on an Oracle Enterprise Linux 6.1, I wanted to resize the tmpfs to allocate more memory(…)

SQL Server 2012: Service Pack 1 (SP1) now available

Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server 2012 Cumulative Update 1 (CU1) and SQL Server 2012(…)