SAP HANA, express edition

The SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace in early 2022. Since then many new features have been introduced to improve the user experience and add new functionality. In this blog... Read More »

This is an utility that worked very well in converting  HTML to Jupyter Notebook IPYNB with all the Author's text for 3 SAP blogs I tried Will be very helpful for many blogs with the current thrust in Data Science and Data Engineering; reader... Read More »

Some friendly queries on embedded Analytics Data Science Machine learning made me interested in SAP HANA  ML. First my sheer chance I chose PAL (nor APL) Hands-On Tutorial: Leverage SAP HANA Machine Learning in the Cloud through the Predictive... Read More »

It’s recommended to use Shared local Container/Schema details within the development team while working on the same project or Dependent Data model. The procedure outlined below explains how to access objects from another local container by... Read More »

It pays to know the HANA database system tables and views. Not unsurprisingly all databases HANA, MSSQLServer, Oracle have similar metadata and HANA  System tables and views well documented. hdbsql is the Command line utility of HANA and is... Read More »

last updated: 2023-03-11 Introduction There is huge knowledge available about SAP HANA reclaim / shrink / defragmentation topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make... Read More »

last updated: 2023-07-25 Introduction There is huge knowledge available about SAP HANA partitioning, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I... Read More »

Background At the end of 2020 Apple released Macintosh computers with a dramatic shift in hardware, leaving behind the Intel x86 based CPU’s and using their own in house M1 arm based CPU’s. This shift meant software had to be recompiled... Read More »

With the new evolving modern methodologies around many SAP applications and database technology, i am trying to contribute with some idea that can be helpful or spark a new idea for others. The thought is … What if we can create HANA docker... Read More »

Task Upgrading SAP HANA, express edition SPS05 (db version: 2.00.057) to SPS06 (db version: 2.00.061). Reason of the Article I encountered issues during the upgrade. The aim of this article is to document these upgrade issues, and demonstrate how I... Read More »