The time is now, isn’t it?
Doing calculations with dates in your queries? Better read this post and make sure your code does what you think it does.
SAP HANA
Machine learnings of hana, odbc, and macos
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…
Types of NULL
In which I deal with non-obvious type conversion problems and NULLs.
[NTM] HANA STUDIO NoClassDefFoundError: javax/xml/soap/SOAPException
Note-To-Myself: solution for “”java.lang.NoClassDefFoundError: javax/xml/soap/SOAPException” error.” with SAP HANA Studio on macOS.
Conditionally unique
How do implement unique constraints for only some of the table entries in SAP HANA.
New year, same issues and some tips.
Most folks working with SQL DBs for a while will likely come to see how beginners in this area struggle with “declaritive code” and “tell… Read More »New year, same issues and some tips.
SQL refactoring example
About a year ago I answered a question on the SAP Community Q&A site and have it on my posts-to-write list ever since to turn… Read More »SQL refactoring example
IF EXISTS would exist
A small function to implement the IF EXISTS option for DDL commands in SAP HANA.
How to know “all these things”
How to learn about foundational techniques used in DBMS? This post provides some pointers to great free resources.
A long comment
Last Monday I read DJ Adam’s blog post about GraphQL and how this tool might be useful to be added to the toolbox of SAP… Read More »A long comment