All articles

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

With Power Query, converting an internet table to Excel is an easy job!

While exploring SQL Server 2014, I was surprised by the powerful Power Query feature. In the recent past, converting an internet table to Excel was a nasty work leading to format problems, implicit conversions, etc. With Power Query, importing(…)

SQL Server 2014 – New Features: xVelocity memory optimized columnstore index

Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services(…)

Oracle Database 12c: Database Migration Assistant for Unicode

The choice of the correct character set before you create an Oracle 12c database is an important decision. You have to know the type of data you have to store and the languages needed by the Oracle database. Oracle(…)

Oracle Database 12c New Features: Uninstaller encapsulated into installation media

Among the Oracle 12c new features there is the addition of an uninstall tool encapsulated in the Oracle database binaries. There is no more the necessity to download the deinstallation tool for Oracle products (deinstall utility). In this blog I(…)

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

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

Developing an archive action for Alfresco Share (2 of 2)

In my last article, I presented the first part of setting up a new action for Alfresco Share, which is an archive action. I advise you to read the first part if you have not read it yet since(…)

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

Developing an archive action for Alfresco Share (1 of 2)

A few weeks ago when I was working on setting up an Alfresco Community Edition v4.2.c, I came across a problem that took me quite some time. What I will talk about today is the customization of the actions(…)

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