Writing & Insights

Deep dives into Data Architecture, BI strategy, and modern software engineering.

The Project Was Delivered. So Why Are We Still Fixing It?

Featured

Oct 31, 20264 min read

The Project Was Delivered. So Why Are We Still Fixing It?

🚧 The Project Was Delivered. So Why Are We Still Fixing It? There is something fascinating about the way we measure success in the world of data engineering. A project gets approved. A deadli…

DataEngineeringDataArchitectureEngineeringCultureTechnicalDebt

Read article

May 2, 20263m

Oracle SQL A Comparative Guide to CTEs, Views, Temporary Tables, and Materialized Views

Today, we're diving into Oracle SQL views, temporary tables, Common Table Expressions (CTEs), and subqueries. There's a lot of debate in thi…

oracle SQLSQL CTEsSubquires

May 2, 20266m

How to Integrate API Data into Oracle Database Using PL/SQL

In this blog post, we'll walk through the process of integrating data from an external API into an Oracle database using PL/SQL. Specificall…

SQLOraclePI

May 2, 20266m

Efficiently Loading CSV Data into Oracle DB: Solving the Merge Problem

Problem Statement In many data-driven environments, we often receive data in CSV format from upstream systems. The challenge lies not jus…

OracleBIDatabasen