Data, Process, Insights & things I write about
Apart from writing blog posts I have written answers to many questions on several Q&A sites like StackOverflow and SAP Community. Some of those answers received good feedback and/or the answer surprised me once I worked… Read More » Answers Pinboard
In his recent blog post " Code Pushdown"Paul Hardy, a long-time SAP community contributor described his first foray into HANA SQLScript programming. Paul picked a very ABAP-y problem to solve: Finding records with… Read More » Find the ONE ... or the other
In Matchmaker, I developed a solution to a not-so-obvious problem. The solution worked and delivered the right answer - finding documents where the line items match to a certain degree the line items of a reference… Read More » Matchmaker - quick quick?
SQL is an easy language to learn. A few commands to learn ( SELECT/FROM/WHERE/GROUP BY) and you are good to go. One downside of the simple syntax and small vocabulary is that it can lead many SQL users to the assumption… Read More » Matchmaker
One of the funny things one can learn when living with South Africans is their concept of time. " Now now", " Just now" or " now" do mean very different things and can confuse the rest of the world terribly. For an… Read More » The time is now, isn't it?
A common requirement for SQL DB modeling is to have something that could be called conditional unique constraint. The idea is that certain combinations of column values should only occur once if at all, while other… Read More » Conditionally unique