SQL
SAP HANA middle of the road for Big Data or just average?
How to make HANA process more than 2bn records without partitioning? No average feat!
Write better SQL!
When reading Some opinionated thoughts on SQL databases recently, I felt reminded of an observation that I have made in the past: the way SQL… Read More »Write better SQL!
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.
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.
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.
Using new features not supported?!
What do you do when HANA tells you that the new feature you want to use is actually not supported?
This post has an answer for that.
Matchmaker – quick quick?
You’ve come up with a clever SQL to solve a problem but now you want to make it fast?
No worries! This post shows how I shaved off 50% runtime and memory by copy & paste.
Matchmaker
Finding alternative order-documents where the lineitems match a certain percentage of a reference document? In SQL? With no cursors? See how it’s done!