Several SQL-to-XML conversion and translation tools are available. The Enterprise and Professional versions of the XMLSpy products from Altova.com can produce an XML schema from a relational database.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

Migrating from an RDBMS to NoSQL can improve scalability and flexibility. Explore top NoSQL databases and best practices for migrating data.

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...