Top Articles

SQL Visualisation Guide – Query Diagrams, Lineage & ERD

Have you ever inherited the SQL codebase from someone else where it is in a “bit of a mess”? 😁 Sound familiar? Most data engineers and SQL developers have been there including myself—staring at a spaghetti-like web of queries, trying to untangle a chaotic SQL codebase. It’s a common nightmare. Traditionally, you had to fight …

Uli Bethke November 3, 2024

Recent Articles

SQL,
XML to database conversion

XML to Database Converter – Tools, Tips, & XML to SQL Guide

Manually converting XML to a database sucks. If you’re anything like me, you’ve probably burned countless wasted hours wrestling with deeply nested XML and data mappings, misinterpreted XML attributes and…
Maciek December 4, 2024

Master Snowflake Data Lineage – Features, Tools & Best Practices

What is Snowflake data lineage? Imagine you’ve just touched down in a bustling, unfamiliar city you’re eager to explore. You step outside your hotel and realise you have no idea…
Uli Bethke November 27, 2024

SQL Visualisation Guide – Query Diagrams, Lineage & ERD

Have you ever inherited the SQL codebase from someone else where it is in a “bit of a mess”? 😁 Where you find nested CTEs (Common Table Expressions), stacked like…
Uli Bethke November 3, 2024
SQL,

Oracle EXTRACT & EXTRACTVALUE for XML (Guide & Examples)

When you need to extract and/or query an Oracle database for XML data, there are two SQL functions that come to mind, ‘EXTRACT’ and ‘EXTRACTVALUE’. I’m going to delve into…
Maciek October 21, 2024
XML,
Best XML to CSV Converters Compared by Data Expert

Best XML to CSV Converters – Compared by Data Expert

You might be surprised that selecting the right XML to CSV converter doesn’t start with evaluating the tool itself or its features. It’s not about the tool. It is all…
Maciek October 16, 2024
JSON,

CSV vs JSON vs XML – The Best Comparison Guide 2024

We’ve all been there, going from spec to Wikipedia page to another spec to some other article on the topic trying to pick between CSV, XML, and JSON for the…
Maciek September 25, 2024
spinner