In which I analyze why a SELECT takes longer when the primary key column is included…
Doing calculations with dates in your queries? Better read this post and make sure your code does what you think it does.
In which I try out something seemingly simple and chase problems down a rabbit hole.
hana.ml.r library for R on macOS is not for the casual user…
In which I deal with non-obvious type conversion problems and NULLs.
Note-To-Myself: solution for “”java.lang.NoClassDefFoundError: javax/xml/soap/SOAPException” error.” with SAP HANA Studio on macOS.
How do implement unique constraints for only some of the table entries in SAP HANA.
A small function to implement the IF EXISTS option for DDL commands in SAP HANA.
How to learn about foundational techniques used in DBMS? This post provides some pointers to great free resources.