In the previous lessons we explored converting PowerShell data into a "traditional" XML document. In other words, an XML document that you could use outside of PowerShell. In the last lesson I created ...

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 ...