SAP HANA, express edition

My career in the SAP ecosystem started in the beautiful. comfy world of ABAP. After some time doing C++ and Java, ABAP presented itself as the awesome language that masked the database and built the UI for you. Back in those days when you manually... Read More »

While I no longer work within SAP HANA Product Management, in my new role in SAP Cloud Business Group I am still developing on HANA and assisting teams that are doing so as well.  Therefore I wanted to some research on “skinny” local... Read More »

Introduction Currently there is no built-in pivot/unpivot function in HANA. In this blog you will find a workaround how to implement this in SQLScript. Pivot/Unpivot Pivoting is the transformation from the rows into the columns. Unpivoting is the... Read More »

Simple but Important commands in HANA DB on M_TABLE_PERSISTENCE_STATISTICS Vs M_TABLES Vs M_CS_TABLES   A.Different use cases of using M_TABLE_PERSISTENCE_STATISTICS 1.Wanted to find the disk size of your HANA DB select... Read More »

Well, analyzing the spread of the SARS-CoV-2 coronavirus was not my dream use case. But based on the responses to Ferry Djaja‘s Tracking Coronavirus COVID-19 Near Real Time with SAP HANA XSA article I decided to add my two groszy too. [Updated... Read More »

Introduction If you are a JavaScript developer then you have multiple options and frameworks for connecting to and working with SAP HANA databases. It’s easy to be overwhelmed with too many options, some of which even seem to be overlapping in... Read More »

With this tutorial you will learn how to train Machine Learning (ML) models in SAP HANA through Python code. Trigger predictive algorithms either from local Jupyter Notebooks or, even better, from Jupyter Notebooks within SAP Data Intelligence. If... Read More »

Introduction In this blog post I will describe the steps I went through to experimentally install SAP HANA, express edition into WSL2 – Windows Subsystem for Linux Version 2. Before I jump into any content, though, I want to start with a... Read More »

Introduction I read on social media about a New Year’s resolution idea: instead of answering questions sent in direct communication, write the response as a blog post and send the requester a link to the post. It sounds like a great idea to... Read More »

Getting Started with SAP HANA In this blog series you will find quotes, backgrounds, suggested further readings and other information related to my latest book SAP HANA 2.0, An Introduction published by SAP Press. Any good? Post a comment,... Read More »