All articles

APEX Connect 2016 – Day 2 – APEX

After the great Keynote about “APEX Vision, Past, Present, Future” by Mike Hichwa, the father of APEX, I decided to attend presentations on following topics: – Dynamic Actions 5.1 – APEX and Oracle JET – Enterprise UX(…)

Columnstore index rebuild cannot start

A couple of weeks ago, I was charged to migrate an SQL Server datawarehouse environment to a more recent version of SQL Server (from 2005 to 2012 in my case). After discussing with my customer we decided to benefit from(…)

SCOM: Creation of a group in order to subscribe to alerts

I am currently managing at one of my customer a monitoring project that concerns SQL Server instances and SCOM (System Center Operation Manager). The project includes many instances, more or less 50, divided in two environment (Production and Test) and(…)

I/O Performance predictability in the Cloud

By Franck Pachot . You don't need good performance only for your system. You need reliable performance. You need performance predictability.

Database security: Where is my critical data?

Last week I visited the Oracle University Event “Expert Summit 2016” in Berlin, Germany. Besides the nice location in the Adlon Kempinski hotel, close to the Brandenburger Tor, I saw very interesting presentations from Jonathan Lewis (Database Troubleshooting and Tuning)(…)

syspolicy_purge_history job and PowerShell ExecutionPolicy

Since SQL Server 2008, Microsoft has introduced a system job called “syspolicy_purge_history”. This job is installed and enabled by default, and it contains three steps scheduled at 02:00 AM:   What is this job?(…)

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