Articles

123 articles

SQL Fundamentals — The Queries That Cover Most of What You Need
Technology - Non SAP 12 min read
Databases · Ch 1

SQL Fundamentals — The Queries That Cover Most of What You Need

SQL has been the language of data for over 40 years and it is not going anywhere. This post covers the fundamentals — SELECT, WHERE, JOIN, GROUP BY, subqueries and more — with real examples, clear explanations and the SAP angle. A reference whether you are writing your first query or just need a quick refresh.

SQLSQL Tutorial
API Security Essentials
Technology - Non SAP 13 min read
Web Security Essentials · Ch 3

API Security Essentials

APIs are one of the most targeted attack surfaces in modern software. This post covers the essentials every developer and architect needs to know — API keys, OAuth tokens, rate limiting, input validation, and the OWASP API Security Top 10. A practical reference whether you are building, reviewing, or securing APIs.

API SecurityOWASP API Top 10
JSON — From Zero to Confident
Technology - Non SAP 12 min read
Data Formats · Ch 1

JSON — From Zero to Confident

JSON is the universal language of APIs and data exchange. Whether you are reading an API response, writing a config file or working with SAP BTP, you will encounter JSON every day. This post covers everything you need — data types, structure, nesting, arrays, common mistakes and real-world examples — to go from beginner to confident.

JSONJSON Tutorial
OAuth 2.0 and OpenID Connect — How Modern Login Actually Works
Technology - Non SAP 15 min read
Web Security Essentials · Ch 2

OAuth 2.0 and OpenID Connect — How Modern Login Actually Works

Every time you click 'Sign in with Google' or a system calls an API using a token, OAuth 2.0 is at work. This post explains what OAuth 2.0 actually does, how the key flows work, what OpenID Connect adds on top, and how JWT ties it all together — in plain English without the specification language.

OAuth 2.0OpenID Connect
SAP Integration Patterns — The Decisions That Matter
Technology - SAP 12 min read
SAP Integration · Ch 2

SAP Integration Patterns — The Decisions That Matter

Point-to-point or hub-and-spoke? Synchronous or asynchronous? IDoc, BAPI, RFC or REST? These are the architectural decisions behind every SAP integration. This post explains the core integration patterns, when to use each, and how they map to modern SAP tools like Integration Suite and Event Mesh.

SAP Integration PatternsSAP CPI