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 considerable change in the way application code accesses the database. In his post "Synonyms in HANA … Continue reading How to give what you don’t have
A brief twitter exchange triggered some thoughts about expectations and how those determine whether something is a good A, a passable B or a terrible C. Paths When you want to go somewhere and you do not know the way, you need directions. Somebody or something needs to show you the path to follow. That's … Continue reading Maps and Paths
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 original answer). Alright, let's do this! (even though I don't have an idea why it … Continue reading Is SAP HANA SQL/SQLScript Turing complete?
Happy New Year, dear reader! I hope you had an enjoyable and relaxing time between Christmas and New Years Eve with your thoughts away from work. I can say, I did. During this time I took the opportunity to finish some thoughts on my engagement with the SAP Community Platform (SCP) where I have been a … Continue reading Not a New Year’s thing
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 for you. Just recently I've seen a customer using my old workaround (first published here) and then a few days later the related stackoverflow question got … Continue reading What’s your number?
How HANA is a real-life Mad Max like badass when using user defined functions (UDF)
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 find out who are the "leading contributors", the "heroes", "aces" etc.Currently, the platform SAP Community is … Continue reading 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 to come up with a click-bait title to make it a blog post. I've written before on installing … Continue reading 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 don't speak about SPS 00 and SPS 01, do we?): "calculated columns". Generated <> … Continue reading 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 SQLScript then you very likely want to have the option to log what your program does. This is not the logging I … Continue reading What HANA needs now is some…