Aisha Bukar in Databases The complete guide to XML support in MySQL and PostgreSQL Discover how MySQL and PostgreSQL differ in XML storage, validation, and querying, and why these differences matter for enterprise apps... 24 June 2026 15 min read
T-SQL Programming Edward Pollack in T-SQL Programming Store, Parse & Convert XML in SQL Server Master XML handling in SQL Server: store XML in typed columns, parse with XQuery and OPENXML, convert between XML and... 03 June 2024 22 min read
David Njoku XQuery for Absolute Beginners: Part 5 – XQuery Update Facility There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or... 19 April 2016 7 min read
David Njoku XQuery for Absolute Beginners: Part 4 – Conditions & Custom Functions This is the fourth part of a series introducing Oracle developers to XQuery. In the first three parts we’ve talked... 12 April 2016 8 min read
David Njoku XQuery for Absolute Beginners: Part 3 – FLWOR This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle... 21 March 2016 9 min read
David Njoku XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery... 02 March 2016 7 min read
Robert Sheldon JSON support in SQL Server 2016 At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a... 15 December 2015 21 min read
Adam Aspin SQLXML Bulk Loader: The Sequel SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of... 25 September 2015 24 min read
Adam Aspin SQLXML Bulk Loader Basics SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way... 02 June 2015 26 min read
Dwain Camps Archiving Hierarchical, Deleted Transactions Using XML When you delete a business transaction from the database, there are times when you might want to keep a record... 30 December 2014 18 min read
David Njoku External Tables: An Introduction At its most basic level, Oracle databases are built around data based within tables held within the database, and the... 16 October 2014 7 min read
Michael Sorens PowerShell One-Liners: Accessing, Handling and Writing Data In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it... 05 June 2014 18 min read
Konrad Lukasik Configuration Management with PowerShell and XML For the rapid delivery of any software application, there must be an effective configuration management system that is scripted. As... 03 June 2014 13 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server FOR JSON: Produce JSON from T-SQL Queries (Flat and Nested) Learn how to produce JSON from SQL Server queries using FOR JSON PATH, FOR JSON AUTO, and custom T-SQL techniques... 06 May 2014 33 min read
Robert Sheldon SQL Server XML Questions You Were Too Shy To Ask Sometimes, XML seems a bewildering convention that offers solutions to problems that the average database user doesn't have. To make... 22 April 2014 26 min read
Michael Sorens PowerShell Data Basics: XML To master PowerShell, you must know how to use XML. XML is an essential data interchange format because it remains... 03 January 2014 13 min read
Robert Sheldon Microsoft’s Log Parser Utility: Swell ETL For loading text, CSV or XML files into SQL Server, the Log Parser utility, with its amazing SQL engine, is... 12 November 2013 21 min read
Dino Esposito Modal Input Forms in ASP.NET MVC Forms in websites have, for a long time, languished in their classic clunky pattern of browser-led 'submit' of content, using... 08 May 2013 12 min read
Dino Esposito Building a Public HTTP API for Data The creation of a public API for data presents something of a dilemma for the developer. Web API, with its... 21 March 2013 12 min read
Seth Delconte Ad-Hoc XML File Querying When you need to shred just part of the data within a large XML file into a SQL Server table,... 05 March 2013 15 min read
