"I was studying Java, and suddenly SQL came up.""I've seen SELECT and INSERT, but what are they actually used for?"For those who have just started learning programming, SQL might seem a bit confusing.

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