Microsoft offers many resources for SQL Server developers to work with JSON (JavaScript Object Notation) data, including Transact-SQL (T-SQL) functions and online documentation.
A list of MSDN blog post articles on SQL Server and JSON can be found at https://blogs.msdn.microsoft.com/sqlserverstorageengine/tag/json/.