Marty

Interests: Playing Guitar, Music Theory

Website: http://martincatherall.com/

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

by Marty

measure twice, cut once.

We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...

2020-06-07

25 reads

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

by Marty

measure twice, cut once.

We’ve looked at getting pulling data from a JSON document into relational table format using an explicit schema that was defined in the WITH clause of the OPENJSON table...

2020-06-07

7 reads

OPENJSON – using an explicit schema. The WITH clause.

by 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

128 reads

OPENJSON, explicit schema and data type

by 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

163 reads

T-SQL Sequences and the OVER() clause

by Marty

measure twice, cut once.

Using a SEQUENCE object - in unusual ways!

2020-06-04

78 reads

OPENJSON – using the default schema to collect new information

by 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

124 reads

JSON data and a T-SQL variable.

by 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,025 reads

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

by 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

152 reads

Data Privacy – Playing your part

by Marty

measure twice, cut once.

Tuesday 28th January 2020 was “Data Privacy Day 2020” Some may refer to this as Data Protection Day, but it is really just a day to draw attention to...

2020-03-10 (first published: 2020-02-03)

195 reads

A trusty old friend – The BCP utility

by 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

195 reads

All authors

Marty

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

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

OPENJSON – using an explicit schema. The WITH clause.

OPENJSON, explicit schema and data type

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

Data Privacy – Playing your part

A trusty old friend – The BCP utility

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)

SQL 2017 to SQL 2025. Good to Go ?

Question of the Day

Using OPENJSON