Development & Performance

SQL Server 2016 – Query Store: retrieve query that doesn’t appear!

For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query(…)

Attunity Replicate: additional column on the target

In December 2015, my colleague Vincent did a test with additional column with Oracle GoldenGate 12.2. Hervé & Vincent asked me(…)

Attunity Replicate: Backup & Restore a task

By a customer, we faced the question: how to backup and restore a replication task in Attunity Replicate? We don’t see any button or menu into the administration web console and in the Guide line, we haven’t really a(…)

PKI – SSL certificates management with Java keytool and OpenSSL

In this blog, we will cover all steps to enable SSL encryption for a particular server. The procedure described here applies mostly for Java based servers and applications, with usage of a keystore. In the case the organization(…)

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

SQL Server 2016: Microsoft R Server

In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.

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

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

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

SQL Server 2016 : nonclustered columnstore index and aggregate pushdown

Did you miss aggregate pushdown capability shipped with columnstore index? Well, I remember the first time I heard about it is was when I read the very interesting blog post of Niko Neugebauer here with a(…)