Blog Post: How to find minimal set of hints leading to better execution plan?

Blog Post: How to find minimal set of hints leading to better execution plan?

Dealing with query performance degradation coming from suboptimal execution plans is a task every DBA knows. Thanks to very good Oracle instrumentation, we have several options to deal with the problem, both in terms of analysis, as well as introducing the correct solution. If you are able to get the proper plan for example from … Continue reading „How to find minimal set of hints leading to better execution plan?“

Blog Post: Plus/minus what? Let’s talk about uncertainty (talk)

Blog Post: Plus/minus what? Let’s talk about uncertainty (talk)

Last week at DOAG 2017, I had two talks, one about deep learning with DL4J (slides here) and one about how to communicate uncertainty (or rather: how to construct prediction intervals for various methods / in various frameworks ranging from simple linear regression over Bayesian statistics to neural networks). TLDR: The most important thing about … Continue reading Plus/minus what? Let’s talk about uncertainty (talk)

DOAG 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell

DOAG 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell

Below you will find a list of the different demo scripts used during the DOAG training day 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell. In general the script do need a SCOTT or a HR demo schema. Some of the scripts may have more requirements eg. Kerberos configuration, Oracle Enterprise User Security etc. […]

Blog Post: DOAG 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell

Blog Post: DOAG 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell

Below you will find a list of the different demo scripts used during the DOAG training day 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell. In general the script do need a SCOTT or a HR demo schema. Some of the scripts may have more requirements eg. Kerberos configuration, Oracle Enterprise User Security etc. […]

Install Oracle Unified Directory 12c the smart way

Install Oracle Unified Directory 12c the smart way

Installing Oracle Unified Directory has always been easy. The installation guide for OUD 11c as well OUD 12 is simple and straight forward. Additionally Oracle does provide a couple of MOS notes for different deployment scenarios. Nevertheless there is always room for improvement 🙂 During my work on OUD to go on Raspberry Pi Zero […]

Blog Post: Install Oracle Unified Directory 12c the smart way

Blog Post: Install Oracle Unified Directory 12c the smart way

Installing Oracle Unified Directory has always been easy. The installation guide for OUD 11c as well OUD 12 is simple and straight forward. Additionally Oracle does provide a couple of MOS notes for different deployment scenarios. Nevertheless there is always room for improvement During my work on OUD to go on Raspberry Pi Zero […]

Blog Post: Install Oracle Unified Directory 12c the smart way

Blog Post: Install Oracle Unified Directory 12c the smart way

Installing Oracle Unified Directory has always been easy. The installation guide for OUD 11c as well OUD 12 is simple and straight forward. Additionally Oracle does provide a couple of MOS notes for different deployment scenarios. Nevertheless there is always room for improvement During my work on OUD to go on Raspberry Pi Zero […]

Blog Post: Last Week in Stream Processing & Analytics – 21.11.2017

Blog Post: Last Week in Stream Processing & Analytics – 21.11.2017

This is the 91st edition of my blog series blog series around Stream Processing and Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from SlideShare Videos from YouTube As usual, find below the new blog articles, presentations, videos and software releases from last […]

Blog Post: Hunting date errors

Blog Post: Hunting date errors

Just recently, I had to find out, why a dataload, that had been working smoothlessly in the past, suddenly prodced an error. The data is coming from an ORACLE database, and imported into MS SQL Server with an OPENQUERY statement. The error message read: “Error converting data type DBTYP_DBTIMESTAMP to datetime2”. Since no changes had…

Blog Post: Dynamic forecasts – with Bayesian linear models and neural networks (talk at Predictive Analytics World Berlin)

Blog Post: Dynamic forecasts – with Bayesian linear models and neural networks (talk at Predictive Analytics World Berlin)

I really wish I had the time to write an article about the conference, instead of just posting the slides! Predictive Analytics World was super inspiring, not just in a technical way but also as to the broader picture of today’s data science / AI explosion, including its political, sociological and personal implications. As I … Continue reading Dynamic forecasts – with Bayesian linear models and neural networks (talk at Predictive Analytics World Berlin)