All articles

The (almost) same sample schema for all major relational databases (3) – MySQL/MariaDB

Some time ago I blogged on how to get the "Dell DVD Store Database Test Suite" installed in PostgreSQL and Oracle. This time we'll do the same on a MariaDB instance.

Maintenance scenarios with EDB Failover Manager (3) – Witness node

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance(…)

SQL Server 2016: R Services

I was during a long time captivated by the R programming language. I’m happy to see that SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts. The first(…)

Maintenance scenarios with EDB Failover Manager (2) – Primary node

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I'll look on how(…)

SQL Server 2016 RC3: .NET Framework 3.5 is no longer required during installation

As you may certainly know, the last release candidate of SQL Server 2016 (RC3) has been released by Microsoft a couple of days ago. You may find the announcement here.  As usual, after downloading the binaries(…)

A short glance at Attunity replicate

By Franck Pachot . If you follow my blog, you should know that I really like Dbvisit replicate because it's simple, robust, has good features and excellent support. But that's not a reason to ignore other alternatives (and this is(…)

Java: Cannot delete file?

You may once went into the struggle to delete a file in java? So do I… I went so mad when I figured out that my files were still present even after a file.delete() or file.deleteOnExit(). It always(…)

Oracle 12C Unified Auditing Feature in a multitenant environment

By Mouhamadou Diaw In oracle 12c we have a new feature called Unified Auditing. What is it, how to implement it, how it works in a multitenant environment that’s what we will try to explain briefly in this article. Traditional(…)

The (almost) same sample schema for all major relational databases (2) – Oracle

In the last post we looked at how to install the "Dell DVD Store Database Test Suite" into a PostgreSQL 9.5.2 database. In this post we'll do the same with an Oracle database.

The (almost) same sample schema for all major relational databases (1) – PostgreSQL

The are times when it would be nice to have the same sample schema in all relational databases you or your company are working on. This is great if you want to compare how different databases execute the same tasks(…)