JSON in SQL Server
Data is received in many different formats including text files, comma separated value files, excel spreadsheets, XML files and JSON files. It is crucial for anyone in the data analytics arena to be able to receive and output data in these various formats.
This video introduces the JSON format as it relates to SQL Server and shows an example of parsing the JSON into columns in the database. SQL Server has extensive facilities to consume and produce JSON.