Database Administration & Monitoring

ODA and CIS / GDPR features

We all know that security becomes...sorry, is one of the hottest topic when setting up IT environment. One basis for that is to be compliant with regulations or standards such as GDPR or CIS. What is not so well known,(…)

Is there too much memory for my SQL Server instance?

Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to deal with of my customers a couple of weeks ago. Usually DBAs complain when they don’t have enough memory for environments they have(…)

Patching a virtualized ODA to patch 12.2.1.4.0

This article describes patching a virtualized Oracle Database Appliance (ODA) containing only an ODA_BASE virtual machine. Do this patching first on test machines because it can not be guaranteed that all causes of failures of single VM ODAs are(…)

DC/OS: Install Marathon-LB with keepalived

After the minimal setup of the DC/OS in my further articles, I wanted to extend my DC/OS and add a loadbalancer. There are two options for loadbalancing in DC/OS 1. Marathon-LB (a layer 7 load balancer, used for external requests,(…)

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