Data, Process, Insights & things I write about
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
Ok, long story short: MS Excel on macOS has a list of recently used files. This list holds up to 25 entries and keeps every Excel file you open. And there is no option to clear it or to disable it. Read More » macOS Excel - clear recently used files list
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
One of the side-effects of working from home a lot - with or without a pandemic running wild - is that the residential IT equipment gets better. Where the WIFI provided by the cable-modem-combi-device was “fine”… Read More » What a 10x network speed difference looks like