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?
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…
HANA 2 has been out for a while now - even SP01 of it is available already - so I thought it is about time to get more familiar with it. Using my trusty "skullbox" (HANA in a pocket... ) I installed HANA 2 and realised that I now also will have to have a … Continue reading HANA 2 and two riddle errors
Hey there! I recently presented a short session on my experiences with developing and debugging non-classic-SAP HANA solutions at the Leading Insights conference in Melbourne (27./28.3.2017). And since the slides are prepared in a way that they could be used without my talking as well, I thought, I might just post them. So, there they … Continue reading Eco-friendly slide recycling with HANA
In case you ever got frustrated by how 80's like the SAP HANA hints infrastructure looks like, go and support my improvement idea on SAP Idea place: https://ideas.sap.com/D40094 Go and upvote! Now! 🙂 [Update 23.1.2017]: After some of the folks that I really liked to review my idea reported that they don't have access to it, … Continue reading Make query hints great again…