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
See how to choose between different implementation options for your DB code like an engineer. Also: JMeter, htop, and MapMerge programming.
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