De-normalize database schema using JSON

Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.

So You Need to Expose JSON Endpoints

Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.

JSON

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+

A Function to Split JSON Data

JSON is Javascript Object Notation and it's a format for exchanging data. New author Ric Vander Ark brings us an article that shows how to implement a function to split out the data into a table format and gives a number of examples for different data.