All articles

SQL Server 2016 : availability groups and the new clustered columnstore index support

This blog post is focused on the new supportability of clustered columnstore index on the high- availability read-only replicas. Others studies are available here: New database issue level detection for automatic failover(…)

When a function returns a collection: can you directly reference the index of the returned collection?

As I am still interested in PLSQL I browsed the documentation some days ago and learned something new which is about functions returning collections. Here is a simple test case: Let’s create a simple package,(…)

SQL Server 2016 : availability groups and load balancing features

Let’s continue with this third post about SQL Server AlwaysOn and availability groups. Others studies are available here: New database issue level detection for automatic failover Potential features in standard edition(…)

SQL Server 2016 CTP2: Stretch database feature – Part 2

In my previous blog SQL Server 2016 CTP2: Stretch database feature – Part 1, I explained how to prepare your instance and your database to enable the Stretch feature for your table. Now I present you how to enable(…)

ODA workshop at Arrow ECS

On the 16th and 17th of June David Hueber, Georges Grey and myself had the chance to attend the ODA hands on workshop at Arrow ECS. Lead Trainer Ruggero Citton (Oracle ODA Product Development) did the first day(…)

SQL Server 2014: Analysis, Migrate and Report (AMR) – a powerful In-Memory migration tool

An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load(…)

statistics_level parameter

With Enterprise Manager Cloud Control 12c configuring and using the compliance standard utility allows us to discover events we should not have seen in other ways. Today at a customer’s site I discovered the following message:   The configuration(…)

What is more efficient: arrays or single columns values? – oracle

In the last post on this topic it turned out that using an array as a column type needs more space than using a column per value in PostgreSQL. Now I’ll do the same test case in Oracle.

What is more efficient: arrays or single column values?

In PostgreSQL ( as well as in other rdbms ) you can define columns as arrays. What I wondered is: What is more efficient when it comes to space: Creating several columns or just creating once column as array? The(…)

SQL Interpolation with psql

The PostgreSQL psql utility provides some really nice features. One of these features is SQL interpolation which allows us to do interesting things, e.g. reading files and analyze the results directly in the database. This post(…)