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!
Interested in DB technology, SAP HANA, and quite some other things. * Co-Author of "SAP HANA Administration" at SAP PRESS * once a SAP Employee, SAP Mentor, SAP HANA Distinguished Engineer, and otherwise SAP community involved I am the founder of Data Process Insights PTY LTD a consulting company focussing on SAP HANA and SAP solution architecture. I write a blog on LBREDDEMANN.ORG.
How to make HANA process more than 2bn records without partitioning? No average feat!
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!
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
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 ππ°! (π)
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.
You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!
Learn something about DBeaver and get free disk space – for FREE!
How to fix a major product flaw in MS Excel for macOS with a little bit of VBA.
See how to choose between different implementation options for your DB code like an engineer.
Also: JMeter, htop, and MapMerge programming.
Get 10x better network speed improvement by using a crazy little piece of equipment. It looks like this…