SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...
In my previous few blogs, I covered the basics of KQL. We covered everything from simple queries on one table to working with multiple tables using joins. Those examples used clean, structured data in ...