Recent Articles

SQL,

How to Parse XML Data in SQL Server

Are you still using fragile OPENXML and messy SQL to wrestle nested XML into relational tables on SQL Server? You know the drill: It starts as a simple script, but…

Uli Bethke January 25, 2024

XML,

The Ultimate Guide to XML Mapping in 2025

XML mapping is a critical process in data integration, ETL, and system interoperability. As an architect, analyst, engineer, or manager involved in XML mapping projects, you're likely familiar with the…

Maciek January 11, 2024

XML,

Diagram showing XML data being inserted into an SQL table.

How to Insert XML into SQL Tables (2025 Guide)

XML is harmless right up until you try putting it into an SQL table. Then the nesting shows up. The attributes show up. The inconsistencies show up. And suddenly you’re…

Maciek December 22, 2023

XML,

Should you Use Outsourced XML Conversion Services?

What is an XML conversion service? When companies need to process and convert XML documents they have two basic choices. They can either implement an XML conversion solution in-house with…

Maciek December 15, 2023

XML,

XML Converters & Conversion – Ultimate Guide (2025)

“Urgent XML Conversion Project – Need by End of Week”. “Just Convert this XML to SQL Tables. Should be Simple!” Sound familiar? From my experience, XML conversion projects follow the…

Maciek October 4, 2023

XML, XML,

Converting Duck Creek XML to a relational database

Duck Creek makes extensive use of XML. All Policy data is locked away in XML just to give one example. XML is a great format for exchanging data and for…

Maciek October 18, 2022