Data, Process, Insights & things I write about
Some time ago I needed a way to control how long a database query would (at least) take. The purpose for this was to test out timeout behaviour of components that trigger and wait for the query result. While the… Read More » Advanced Database magic with Tableau
Something (hopefully useful) for the all the Tableau repository warriors: Table schedules holds, as the name implies, the definition of schedules in Tableau Server. Unfortunately for the SQL user, the information about… Read More » Tableau repository schedules decoded
Analysing the data in SAP systems can be done in many ways. While SAP would like all customers to use the tools from their portfolio, many customers prefer to use other platforms. Snowflake is arguably one of the most… Read More » SAP Factory Calendar in Snowflake
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
When SAP tries to explain HANA as a technology the buzz words “Big Data” have always been part of the story. Commonly “Big Data with HANA” then gets specified to mean one or another thing - often to caveat what the… Read More » SAP HANA middle of the road for Big Data or just average?
When reading Some opinionated thoughts on SQL databases recently, I felt reminded of an observation that I have made in the past: the way SQL is commonly used and presented is way too low-level. Read More » Write better SQL!
Real programming # One of the aspects of doing “actual” programming is to automate computations. Making the computer do things not just once, say by running a calculation on the October sales data, but to do it over and… Read More » Separate business logic from tables and avoid dynamic SQL
A journey of 1000 miles… # We are developers. We make the modern world tick and create tools for information workers. We are computer scientists, IT experts, and coders, and we call ourselves engineers. We even renamed a… Read More » How to engineer your DB code
On the last weekend in May, just a few days ago, the SAP Online Track was held. A volunteer-driven, online developer, and user event around SAP technology. https://twitter.com/Sygyzmundovych/status/1250811896737005570 A… Read More » SAP Online Track 2020
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