A relational database table is articulated on a fixed number of columns and each column has its own data type, such as strings of variable or fixed length, dates, numbers, Booleans and the like. JSON ...

SQL Server has introduced a JSON data type. While you could previously store JSON in the database using the NVARCHAR(MAX) data type, it was an incomplete solution.

Because SQL Server doesn’t have a Boolean data type, I must test the IsPremium property against the string "true." But, wait, there’s more! In my next column I’m going to look at retrieving whole JSON ...