OPENJSON and CROSS APPLY
June 10th, 2020
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that..
Read More
OPENJSON and an Alias
June 9th, 2020
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some..
OPENJSON : Getting to the data, and the PATH – PART I
June 8th, 2020
Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL..
Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.
Search
Recent Posts
Categories
AlwaysOn Availability Groups Arc Data Services Availability Groups Azure Azure Data Studio CosmosDB Data Database DevOPs Database Lifecycle Management DevOPs Disaster Recovery DLM General High Availability JSON Kerberos Performance Power BI Presentations Reporting Services Security Service Broker Service Packs SMC SQL SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server 2022 SQLServer SQLServerCentral T-SQL T-SQL Tuesday TSQL Uncategorized