Be careful with dates and timestamps
Ever mixed timestamps and dates and wondered why your result wasn’t quite what you expected?
Find one possible answer to this in this blog post.
Lars Breddemann
SAP Inside Track #sitMEL – Full Day Event in Melbourne
Looking for the content of Lars’ presentation from #sitMEL-2020? Look no further, it’s all here.
One in a Million
In which I analyze why a SELECT takes longer when the primary key column is included…
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.
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 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.
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 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