SAP Factory Calendar in Snowflake
Using the SAP Factory Calendar table TFACS in Snowflake.
Using a Mac still comes with some pleasant surprises
Moving data from an old mac to a new one comes with very pleasant surprises.
SAP HANA middle of the road for Big Data or just average?
How to make HANA process more than 2bn records without partitioning? No average feat!
Write better SQL!
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… Read More »Write better SQL!
SUDO grant – a compromise
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… Read More »SUDO grant – a compromise
Have yourself a good 🙂🕰! (😎)
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… Read More »Have yourself a good 🙂🕰! (😎)
Separate business logic from tables and avoid dynamic SQL
You want to apply your business logic to multiple tables in your DB but don’t want to use dynamic SQL? Good on you! Here’s how.
Why are your scalar UDFs slow? (mine aren’t)
You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!
DBeaver log files: beware and free up disk space
Learn something about DBeaver and get free disk space – for FREE!