measure twice, cut once.

SQL Server STUFF

by Marty

measure twice, cut once.

The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...

2022-01-10

13 reads

More Times Like These with SQL Server

by Marty

measure twice, cut once.

I blogged the other about have some issues translating Oracle date formats to SQL Server date data types I find the way SQL Server handles dates with a defined...

2021-12-06

2 reads

Times Like These with SQL Server

by Marty

measure twice, cut once.

I was doing some conversion of Oracle code (PL/SQL) to SQL Server code (T-SQL) – which had some quirks. I just thought that I’d share a quick tip that...

2021-12-02

3 reads

What exactly is a modern data warehouse?

by Marty

measure twice, cut once.

G’day, I was asked recently what a modern data warehouse is – and that’s a vey thought provoking question. First, there’s the tag “Modern” – I think what’s modern...

2020-12-14

11 reads

OPENJSON and CROSS APPLY

by Marty

measure twice, cut once.

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...

2020-06-24 (first published: 2020-06-09)

6,521 reads

OPENJSON and CROSS APPLY

by Marty

measure twice, cut once.

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...

2020-06-09

4 reads

OPENJSON and an Alias

by Marty

measure twice, cut once.

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...

2020-06-08

267 reads

OPENJSON and an Alias

by Marty

measure twice, cut once.

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...

2020-06-08

2 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

12 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

measure twice, cut once.

SQL Server STUFF

More Times Like These with SQL Server

Times Like These with SQL Server

What exactly is a modern data warehouse?

OPENJSON and CROSS APPLY

OPENJSON and CROSS APPLY

OPENJSON and an Alias

OPENJSON and an Alias

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

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

Blogs

SQL Server 2025

Advice I Like: Apologies

Build a Serverless Todo App With AWS, Pulumi, and Python

Forums

SQL Clustered Resource in online pending for about 3-5 mins before coming online

SQL Query to use in MS SSRS server to give you your report structure.

Temp table security

Question of the Day

Escaping Like I