All articles

Enterprise Manager 13c and BI Publisher

In Enterprise Manager 12c, if you need to display the database storage, from the report menu you have the following possibilities: From now on, with Enterprise Manager 13c, this possibility does not exist anymore in the report menu,(…)

A look at PostgreSQL 9.6 – The wait interface

For a long time there was no real wait interface in PostgreSQL core. Now, with the upcoming 9.6, pg_stat_activity was extended to provide more meaningful information for what a session is currently waiting on.

Stored procedure execution may fail with nonclustered columnstore indexes

In this blog post, let’s talk about a weird situation where I faced a nonclustered columnstore issue with SQL Server 2012. Let’s say we are in the same context than this previous blog post here. So(…)

Happy birthday PostgreSQL

SQL Server 2016: Extended Events are more powerful as Trace Flag for Backups and Restores

Before SQL Server 2016, we use Trace Flag to display information about backup and restore operations like the 3004, 3014, 3213 or 3604. Here a link to the MSDN with a great(…)

GoldenGate Studio 12.2 – Create repository

In a previous blog I explained you how to install GoldenGate Studio. This time the goal is to describe how to create the repository required by GoldenGate Studio. Oracle provides a tool to create all the repository data(…)

SQL Server 2016 RTM – Coming soon!

The first RTM release of SQL Server 2016 will be released soon. It’s official now! Indeed, Microsoft announced here the SQL Server 2016 RTM release being generally available for use the 1st June 2016. What does(…)

SQL Server: Now Cumulative Updates (CU) need to be install!

 Since this year, Microsoft recommends to install Cumulative Updates (CU) like Service Packs (SP) In the past, Microsoft always recommended to apply the Service Packs and security fixes for SQL Server. Cumulative Updates were applied only if(…)

Connecting your PostgreSQL instance to a Microsoft SQL Server instance

In the last posts I looked at how you can connect Oracle and MariaDB/MySQL to a PostgreSQL instance. In this post I'll do the same with a MS SQL Server instance.

GoldenGate Studio 12.2 – Installation

Today I will present you the new product GoldenGate Studio which was announced at the last Oracle Open World. This product allows to design the replication flows and deploy a solution with a graphical tool. Download The first step is(…)