Separate business logic from tables and avoid dynamic SQL
You want to apply your business logic to multiple tables in your DB but don’t want to use dynamic SQL? Good on you! Here’s how.
Why are your scalar UDFs slow? (mine aren’t)
You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!
DBeaver log files: beware and free up disk space
Learn something about DBeaver and get free disk space – for FREE!
macOS Excel – clear recently used files list
How to fix a major product flaw in MS Excel for macOS with a little bit of VBA.
How to engineer your DB code
See how to choose between different implementation options for your DB code like an engineer.
Also: JMeter, htop, and MapMerge programming.
What a 10x network speed difference looks like
Get 10x better network speed improvement by using a crazy little piece of equipment. It looks like this…
Getting data into HANA – the easy way
Loading data into SAP HANA the super easy way. A click-through. How to use DBeaver to load huge CSV data files quick without any coding.
What is CPB+-Tree in SAP HANA?
Ever wondered what a CPB+tree is and what it does in SAP HANA? This post has the answer for you.
SAP Online Track 2020
The SAP Online Track event was a major success.
Find my talk “If your SQL reads like Assembler you’re doing it all wrong.” here.
Find the ONE … or the other
Some “finger-exercises” in data modeling, SQL programming, and making sense of ABAP design decisions.