Recent Articles

All JSON Snowflake XML
Snowflake,
Flexter XML to SQL converter visual guide for seamless database integration

How to Use the Flexter XML to SQL Database Converter Online

Converting deeply nested XML to database for free, without writing a single line of code. Too good to be true? With Flexter Online, it’s a reality. In this guide, I’ll…
Kristijan Berta March 20, 2025
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
Data Lineage,

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
SQL,

How to Parse XML Data in SQL Server

The many options available for loading, querying, shredding, and converting XML on SQL Server can often be overwhelming for beginners. SQLXML, XPath, XQuery, OPENXML, FOR XML, OPENROWSET, BULK INSERT are…
Maciek January 25, 2024
SQL,

Mastering SQL: How to detect and avoid 34+ Common SQL Antipatterns

Overview Are you looking for reasons why your SQL queries are slow or costly. Look no more. This blog post showcases a comprehensive list of 34 SQL antipatterns. Use it…
Uli Bethke December 6, 2023