The "data" part of the terms "data lake," "data warehouse," and "database" is easy enough to understand. Data are everywhere, and the bits need to be kept somewhere. But should they be stored in a ...

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