All articles

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

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.