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
A small function to implement the IF EXISTS option for DDL commands in SAP HANA.
There is one predominant reason for why databases and database technology get a spot in the conversation of “the business”: performance.Understanding system performance and coming up with ideas for improving it typically requires a form of end-to-end understanding with different levels of detail insight on how a query from a client application is processed by … How to know “all these things”
Last Monday I read DJ Adam’s blog post about GraphQL and how this tool might be useful to be added to the toolbox of SAP UI5 developers.There is a lively discussion over the blog’s topics going on and most of it was around the GraphQL technology and its potential usage in UI5. I added a … A long comment
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 on the SAP Community platform follow this approach, probably being unaware that … Finding answers on workdays
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 XS … 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 … Maps and Paths