All articles

SQL Server 2016 : availability groups and the new SSISDB support

This blog post is focused on the new supportability of SSIDB catalog on AlwaysOn architecture. Others studies are available here: New database issue level detection for automatic failover Potential features in standard(…)

2 ways to move archivelogs – both need RMAN

By Franck Pachot . The database must know where are the files. If you move them from the OS, the database will not be aware of it. But there is a database tool to copy or move files and(…)

Buffer pool advisory in AWR

By Franck Pachot . In Oracle memory advisors: how relevant ? I said that advisors are calculating their recommendations from statistics cumulated since the begining of the instance, even in AWR which is supposed to cover only a(…)

Does the block size matter?

By Franck Pachot . The default block size is 8k in Oracle. This is the most common. Sometimes, people create the database with 16k block size for datawarehouses. You can also find some 32k block size, but less common(…)

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