Consuming JSON Formatted API Data in 2016
Natively consume JSON data from API sources with SQL 2016 and CLR
2016-06-02
8,881 reads
JSON
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.
2016-03-10
4,763 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.
2016-01-07
9,007 reads
De-normalize database schema using JSON
Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.
2015-12-08
4,095 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.
2015-11-03
2,813 reads
2015-09-07
1,914 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+
2016-10-21 (first published: 2015-08-31)
13,398 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.
2009-09-23
41,086 reads
Blogs
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Forums
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
Question of the Day
Encoding URLs
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers