All articles

Ravello

By Franck Pachot . I'm at Oracle Open World and I'm rather focused on database rather than all those Cloud topics, but one product caught my attention at the Oracle ACED Briefing. Oracle bought Ravallo systems at the beginning of(…)

Oracle 12cR2 Optimizer Adaptive Statistics

By Franck Pachot . When 12.1 came out, the major issue we encountered after migration was related to the new adaptive features of the optimizer: automatic reoptimization, SQL Plan Directives and the resulting dynamic sampling. Of course, Oracle product managers(…)

Oracle 12cR2 Long Identifiers

By Franck Pachot . This morning during Gerald Venzl presentation of "What’s New for Developers in the Next Generation of Oracle Database" at Oracle Open World, one feature has been acclaimed by a full room: 12.2 show the end of(…)

Oracle Database 12.2 – PDBaaS

By Franck Pachot . It's official, Larry Ellison made the announcement at first keynote and the database product team at oracle has released the version and the documentation publicly. Oracle Database Exadata Express Cloud Service is the 'Cloud First' environment(…)

SQL Server 2016: Dynamic Data Masking and database role

Last week, dbi services organized an event named “SQL Server 2016: what’s new?” in Lausanne, Basel and Zurich. I would take the opportunity to say again a big thank you to everyone which joined us. During my session some(…)

Oracle 12cR2 SQL new feature: LISTAGG overflow

By Franck Pachot . LISTAGG was a great feature introduced in 11g: put rows into line with a simple aggregate function. 12cR2 adds an overflow clause to it. What happens when you have so many rows that the LISTAGG(…)

Les 24 heures du PASS (24HOP) – édition francophone

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre(…)

SQL Server 2016 : Basic availability groups may fit to your HA needs

In this blog let’s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. First of(…)

Result cache side effects on number of calls

By Franck Pachot . During the execution of a SQL statement, you cannot guess how many times an operation, a predicate, or a function will be executed. This depends on the execution plan, on some caching at execution, and some(…)

Sharding with PostgreSQL

By Mouhamadou Diaw In this article we are going to talk about sharding in PostgreSQL. What is sharding, Sharding is like partitioning. The difference is that with traditional partioning, partitions are stored in the same database while sharding shards (partitions)(…)