sqlscript
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!
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.
Is SAP HANA SQL/SQLScript Turing complete?
There was an interesting (aka nerdy) question in the SAP Community Q&A the other day: “Are SQLScript and HANA SQL Turing complete?” I took a… Read More »Is SAP HANA SQL/SQLScript Turing complete?
What’s your number?
Have you been using the ISNUMERIC() function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so,… Read More »What’s your number?
Eco-friendly slide recycling with HANA
Hey there! I recently presented a short session on my experiences with developing and debugging non-classic-SAP HANA solutions at the Leading Insights conference in Melbourne… Read More »Eco-friendly slide recycling with HANA