SAP HANA

SAP Factory Calendar in Snowflake

04/05/202314/05/2023
SAP HANA, Snowflake, SQL

Using the SAP Factory Calendar table TFACS in Snowflake.

Answers Pinboard

19/12/202219/12/2022
miscellaneous, Oracle Database, SAP HANA, SAP MaxDB, SQL

A collection of questions and answers about SQL, SAP HANA, and data modelling.

SAP HANA middle of the road for Big Data or just average?

14/08/202217/08/2022
SAP HANA, SQL

How to make HANA process more than 2bn records without partitioning? No average feat!

Write better SQL!

03/04/202103/04/2021
miscellaneous, SAP HANA, 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

28/02/202128/02/2021
SAP HANA

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 🙂🕰! (😎)

20/02/202120/02/2021
miscellaneous, SAP HANA

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 🙂🕰! (😎)