Marty

  • Interests: Playing Guitar, Music Theory

Blog Post

SQL Server STUFF

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

18 reads

Blog Post

OPENJSON and CROSS APPLY

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: )

6,688 reads

Blog Post

OPENJSON and an Alias

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

281 reads

Blog Post

OPENJSON and an Alias

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

5 reads

Blogs

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Advice I Like: Focus on what’s important

By

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...

India-US Tariff War: Is the Indian IT Sector at Risk?

By

How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...

Read the latest Blogs

Forums

OpenQuery with Application Intent specified runs on primary node.

By kailash.kanaya

I have an Open query that runs on an Always On server via a...

What is a Failed Deployment?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is a Failed Deployment?

Generating a Series I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Generating a Series I

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers