Types of NULL
In which I deal with non-obvious type conversion problems and NULLs.
SAP HANA
[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
Finding answers on workdays
Cunningham’s Law is the idea that “the best way to get the right answer on the internet is not to ask a question; it’s to… Read More »Finding answers on workdays
Trouble with time?
A comprehensive overview on handling datetime data in SAP HANA – including timezone conversion, UTC handling and how it relates to JAVA/JDBC.