Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag JSON Rss

Search for any content tagged json

   Items 1 to 12 of 12   
 

Consuming JSON Formatted API Data in 2016

Natively consume JSON data from API sources with SQL 2016 and CLR  Read more...
By Ryan Loftin 2016/06/02 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 1,728 reads

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2016/05/05 | Source: SQLServerCentral.com | Category: openjson
Rating: |  Discuss |   Briefcase | 1,744 reads

Getting Started with JSON Support in SQL Server 2016 – Part 2

Arshad Ali talks about using OPENJSON to read and parse JSON data and looks at how to convert it to tabular format.  Read more...
By Additional Articles 2016/03/10 | Source: Database Journal | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 4,238 reads

Exploring SQL Server 2016 Always Encrypted – Part 4 – Encrypting Existing Data

Greg Larsen explores the different ways that you can encrypt your existing confidential data using Always Encrypted Columns in SQL Server 2016.  Read more...
By Additional Articles 2016/02/22 | Source: Database Journal | Category: mysql 7
Rating: (not yet rated)  Rate this |   Briefcase | 3,767 reads

JSON support in SQL Server 2016

At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a useful start, even though it is nothing like as comprehensive as the existing XML support. For many applications, what is provided will be sufficient. Robert Sheldon describes what is there and what isn't.  Read more...
By Additional Articles 2016/01/07 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 8,125 reads

De-normalize database schema using JSON

Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.  Read more...
By Additional Articles 2015/12/08 | Source: Microsoft MSDN | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 3,663 reads

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.  Read more...
By Additional Articles 2015/11/03 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,504 reads

NoSQL inside SQL Server

This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.  Read more...
By Steve Jones 2015/09/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

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+  Read more...
By Joshua Healy 2015/08/31 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 10,295 reads

Producing JSON Documents from SQL Server queries via TSQL

Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.  Read more...
By Additional Articles 2014/05/22 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 8,125 reads

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...
By Bret Lowery 2011/07/18 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,634 reads

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.  Read more...
By Ric Vander Ark 2009/09/23 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 11,871 reads
   Items 1 to 12 of 12