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.
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 the DB what you want not how to do it” In my experience, this issue stems partly from the way SQL is tought – examples are often way too simplistic … New year, same issues and some tips.
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 it into a blog post. I feel that I learn a lot from seeing applied examples of concepts and rules – for example from this great presentation from Kevlin Henney … SQL refactoring example