Data, Process, Insights & things I write about
Apart from writing blog posts I have written answers to many questions on several Q&A sites like StackOverflow and SAP Community. Some of those answers received good feedback and/or the answer surprised me once I worked… Read More » Answers Pinboard
Recently we got a new Macbook in our household, seeing that the previous one was from 2013 and would not allow new versions of macOS to be installed. Part of setting up the new laptop is to move all data from the old one… Read More » Using a Mac still comes with some pleasant surprises
Real programming # One of the aspects of doing “actual” programming is to automate computations. Making the computer do things not just once, say by running a calculation on the October sales data, but to do it over and… Read More » Separate business logic from tables and avoid dynamic SQL
What is this about? # In his blog post Why are scalar UDFs so slow? Jörg Brandeis wonders why user defined scalar functions (scalar UDFs) are slow compared to plain SQL. This is an important question since UDFs would… Read More » Why are your scalar UDFs slow? (mine aren't)
A journey of 1000 miles… # We are developers. We make the modern world tick and create tools for information workers. We are computer scientists, IT experts, and coders, and we call ourselves engineers. We even renamed a… Read More » How to engineer your DB code
One of the side-effects of working from home a lot - with or without a pandemic running wild - is that the residential IT equipment gets better. Where the WIFI provided by the cable-modem-combi-device was “fine”… Read More » What a 10x network speed difference looks like
A recent question on StackOverflow brought up a topic that is not well covered in the official HANA documentation: the index structures used in HANA’s row-store. The term CPB tree shows up in several locations in the… Read More » What is CPB+-Tree in SAP HANA?
In his recent blog post " Code Pushdown"Paul Hardy, a long-time SAP community contributor described his first foray into HANA SQLScript programming. Paul picked a very ABAP-y problem to solve: Finding records with… Read More » Find the ONE ... or the other
In Matchmaker, I developed a solution to a not-so-obvious problem. The solution worked and delivered the right answer - finding documents where the line items match to a certain degree the line items of a reference… Read More » Matchmaker - quick quick?
On Saturday, 15.02.2020, a rather rain-drenched stormy day in Melbourne, Australia, the SAP Inside Track #sitMEL – Full Day Event was held. I was honored to get a speaker slot and the chance to talk about “Humane DB… Read More » SAP Inside Track #sitMEL – Full Day Event in Melbourne