measure twice, cut once.

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...

2020-06-07

45 reads

OPENJSON : Getting to the data, and the PATH – PART I

by data-marty

measure twice, cut once.

Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...

2020-06-07

18 reads

OPENJSON, explicit schema and data type

by data-marty

measure twice, cut once.

Back in our last instalment, we looked at OPENJSON and how we can get data into a tabular format from a JSON document. Readers may have noticed that we...

2020-06-05

178 reads

OPENJSON – using an explicit schema. The WITH clause.

by data-marty

measure twice, cut once.

G’day, Previously, we have looked at using OPENJSON to gain knowledge about the JSON document that we have presented to the function. A bit like this Notice that we...

2020-06-05

151 reads

T-SQL Sequences and the OVER() clause

by data-marty

measure twice, cut once.

Using a SEQUENCE object - in unusual ways!

2020-06-04

94 reads

OPENJSON – using the default schema to collect new information

by data-marty

measure twice, cut once.

We’ve looked at reading JSON from disk and also verifying that a string we have contains valid JSON data. But, naturally, we’d like to do more than that. Well,...

2020-05-27

140 reads

JSON data and a T-SQL variable.

by data-marty

measure twice, cut once.

G’day, You may have noticed when looking at FOR JSON AUTO or FOR JSON PATH that both clauses result in one single column that contains a JSON string. But,...

2020-05-23

2,171 reads

JSON, SQL Server and Esacpe Characters of the non-printable kind

by data-marty

measure twice, cut once.

G’day, We observed in a previous installment that JSON uses the backslash character “” as the escape character. However, what happens if we actually want a backslash in our...

2020-05-20

165 reads

A trusty old friend – The BCP utility

by data-marty

measure twice, cut once.

One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...

2020-03-08

296 reads

Data Events in Australia and New Zealand in early 2020

by data-marty

measure twice, cut once.

Over the course of the next few weeks there are some significant events taking place that reflect technologies on the Microsoft data platform and beyond. Thursday 13th and 14th...

2020-02-12

69 reads

measure twice, cut once.

OPENJSON : Getting to the data, and the PATH – PART I

OPENJSON : Getting to the data, and the PATH – PART I

OPENJSON, explicit schema and data type

OPENJSON – using an explicit schema. The WITH clause.

T-SQL Sequences and the OVER() clause

OPENJSON – using the default schema to collect new information

JSON data and a T-SQL variable.

JSON, SQL Server and Esacpe Characters of the non-printable kind

A trusty old friend – The BCP utility

Data Events in Australia and New Zealand in early 2020

Blogs

Asking for Help Isn’t a Weakness

The Proof of the Backup Is in the Pudding

T-SQL Tuesday #204 – Are blogs still relevant?

Forums

Layanan Resmi BCA KCU BEKASI Telp:0817°82°5533

Layanan Resmi BCA KCU GARUT Telp:0821°8200°233

Layanan Resmi BCA KCU SUBANG Telp:0821°8200°203

Question of the Day

SQL Server Vector Support II