Database Administration & Monitoring

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

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

What the hell are these template0 and template1 databases in PostgreSQL?

When people start to work with PostgreSQL, especially when they are used to Oracle, some things might be very confusing. A few of the questions we usually get asked are: Where is the listener and how can I configure it?(…)

Securing your connections to PostgreSQL by using SSL

Security is a big topic today and in the news almost every day. As the database usually holds sensitive data this data must be well protected. In most cases this is done by encrypting critical data inside the database and(…)

EDB Failover Manager 2.1, (two) new features

In the last post we upgraded EDB EFM from version 2.0 to 2.1. In this post we'll look at the new features. Actually we'll look only at two of the new features in this(…)

EDB Failover Manager 2.1, upgrading

Some days ago EnterpriseDB released a new version of its EDB Failover Manager which brings one feature that really sounds great: "Controlled switchover and switchback for easier maintenance and disaster recovery tests". This is(…)