SQL Server - How to export the content of a column to XML files April 13, 2020 5 min read Continue reading
SQL Server - How to export and import tabular data files (for example, CSV) using CLR (C#) March 20, 2017 8 min read Continue reading
SQL Server 2016 - Using native JSON support (JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, ISJSON, JSON_MODIFY) February 19, 2017 16 min read Continue reading
SQL Server - How to read, import and export data from XML files June 18, 2016 27 min read Continue reading
SQL Server - Importing and Exporting Data from Excel Spreadsheets June 15, 2016 5 min read Continue reading
How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing into the database and exporting to XML July 25, 2015 14 min read Continue reading