2017-06-15
1,002 reads
JSON
SQL Server 2016: built-in JSON Use case scenarios
There's built-in JSON support starting with SQL Server 2016. Does that mean we should all ditch XML and start using JSON? It depends mostly on the target of your data output processing.
2016-08-16
5,131 reads
2016-07-05
1,031 reads
2016-06-24
1,397 reads
2016-06-13
1,216 reads
2016-06-06
1,071 reads
Consuming JSON Formatted API Data in 2016
Natively consume JSON data from API sources with SQL 2016 and CLR
2016-06-02
8,622 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.
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
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers