Data, Process, Insights & things I write about
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 post the wrong answer.”. More often than not I feel that some of the answers provided to questions… Read More » Finding answers on workdays
There are a couple of topics that are an ongoing source of confusion even for experienced IT professionals and developers. UNICODE handling is one example (see here for info), floating point calculations is another one… Read More » Trouble with time?
The development tools and techniques for SAP HANA have been extended and enhanced a couple of times since SAP HANA had first been released in 2011. For apps developed for SAP HANA XS, the new XSA environment means a… Read More » How to give what you don't have
There was an interesting (aka nerdy) question in the SAP Community Q&A the other day: “Are SQLScript and HANA SQL Turing complete?” I took a swing at it and the following is my result (a slightly edited version of my… Read More » Is SAP HANA SQL/SQLScript Turing complete?
Have you been using the ISNUMERIC function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so, this is the blog post for you. Read More » What's your number?
If you’ve watched “Mad Max Beyond Thunderdome” then " … You know the law: Two men enter, one man leaves …". HANA, of course, reverses, sorry, disrupts this law by making two (or more) values get out of functions, even… Read More » HANA inverts the Thunderdome law
What to read? Whom to follow? # One of the important things to pick up in any community is finding out who are the people that usually have good, funny or interesting content. Many community platforms make it easy to… Read More » HANA backtrace 36/2017
This is going to be one of those weird blog posts, that basically convey just a single piece of information, but since the new SAP Community platform doesn’t really care for WIKI/document style knowledge storage, I had… Read More » HANA gets stripped
A recent discussion in the SAP internal JAM community for HANA made me aware of a feature added to HANA SQL starting with HANA 1 SPS 12 (don’t ask the revision, just check the latest), respectively HANA 2 SPS 02 (we… Read More » A new feature! YAY!?
… logging! Yes, you just got click-baited into reading this advertisement for a product enhancement idea that I posted: Standard logging facility for SQLScript The idea here is simple: when you write application logic in… Read More » What HANA needs now is some...