Marty

  • Interests: Playing Guitar, Music Theory

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

2,888 reads

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

42 reads

Blogs

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Understanding the Internals of a Data Page

By Mohsin_A_Khan

Comments posted to this topic are about the item Understanding the Internals of a...

Preventing Trigger Execution

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preventing Trigger Execution

DevOps in Space

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DevOps in Space

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers