Articles

Deep dives on the extension's design and performance, published on Medium:

• Bringing Microsoft SQL Server to DuckDB: A Native TDS Extension — why a pure C++ TDS 7.4 implementation instead of ODBC/FreeTDS, and what the catalog integration looks like from the inside.
• DuckDB SQL Server extension: UPDATE, DELETE, Transactions, and 1.2M Rows/Sec Bulk Loading — the DML layer, transaction pinning, and how the columnar BCP write path reaches seven-figure row rates.
• From 51 Seconds to 1 Second: How We Made DuckDB ↔ SQL Server 49x Faster with ORDER BY Pushdown — pushing ORDER BY + LIMIT into T-SQL as SELECT TOP N ... ORDER BY, and why sorting on the server changes everything for top-N queries.
• Querying Azure SQL and Microsoft Fabric from DuckDB with Azure Entra ID Authentication — service principals, Azure CLI and device-code flows against Azure SQL and Fabric warehouses, end to end.

Related resources:

• DuckDB Community Extensions: mssql
• Hugr Lab — the data-mesh platform this extension grew out of.