Data, Process, Insights & things I write about
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!
A long intro # One of the defining characteristics of “enterprise” software is that these systems are used across many parts of organisations and sometimes across many organisations. As with all shared resources commonly… Read More » SUDO grant - a compromise
Ok, nothing complex, crazy, or high-concept today. Just a reminder that stuff like the following is possible without any effort with your database of choice (including HANA, of course): This does not stop if you want to… Read More » Have yourself a good 🙂🕰! (😎)
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
What is this about? # In his blog post Why are scalar UDFs so slow? Jörg Brandeis wonders why user defined scalar functions (scalar UDFs) are slow compared to plain SQL. This is an important question since UDFs would… Read More » Why are your scalar UDFs slow? (mine aren't)
Remember my post from earlier in April 2020? (Getting data into HANA - the easy way) In it, I described how to use DBeaver to load CSV files into HANA quick and hassle-free. For DBeaver activities like importing or… Read More » DBeaver log files: beware and free up disk space
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