Database Administration & Monitoring

EDB BART 2.2, parallel full backups without using pg_basebackup

Some days ago EnterpriseDB released the latest version of its backup and recovery tool for PostgreSQL and EDB Postgres Advanced Server, release notes here. The main new features, at least for me, are backups using multiple(…)

Recovering from failed patch on virtualized ODA

When a patch fails on a virtualized Oracle Database Appliance (ODA), this ODA is often unusuable because Linux and OAKD are patched to new release but Grid Infrastructure is still on old version. OAKD cannot be restarted in default mode(…)

An index only scan in PostgreSQL is not always index only

PostgreSQL supports index only scans since version 9.2 which was released in September 2013. The purpose of an index only scan is to fetch all the required values entirely from the index without visiting the table(…)

SQL Pass Summit 2018: SQL Server 2019 features coming soon!

It’s the 20th anniversary of the event and the keynote today was amazing (see the blog from Christophe) for different reasons but the more important is that is every time better people. Not(…)

Pass summit – day 4

Optimizing Multi-Billion Row Tables in Tabular in 2018   I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is(…)

Pass summit – dbi visit day 3

The Microsoft data platform is evolving The third day began with the Keynote help by Rohan Kumar the Corporate Vice President of Azure Data by Microsoft The main message was “Hybrid data platform is the way for the(…)

SQL server security pre-conference @SQL Pass Summit 2018 in Seattle

After long hours of flights, Christophe Cosme and I finally arrived in Seattle at the SQL PASS Summit 2018. We picked up our badge and bag and now we are ready to begin… This first day for me(…)

Pass summit – dbi visit day 2

  The Art and Science of Designing Smart Data story This pre-conference session was moderated by Mico Yuk CEO and founder of BI Brainz Mico drove us through the path of BI data visual storytelling and the importance it(…)

Some more zheap testing

Hervé already did some tests with zheap and documented his results yesterday. After some more discussions with Amit who did the session about zHeap at the conference here in Lisbon (you can(…)

5 mistakes you should avoid with Oracle Database Appliance

Introduction It has been 5 years I’m working on ODA and I now have a quite good overview of the pros and the cons of such a solution. On one hand, ODA can greatly streamline your Oracle Database environment if(…)