OPENJSON : Getting to the data, and the PATH – PART II
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
28 reads
OPENJSON : Getting to the data, and the PATH – PART I
Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...
2020-06-07
9 reads
OPENJSON : Getting to the data, and the PATH – PART I
Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...
2020-06-07
34 reads
Azure Platform Series: Creating an Azure Container Registry – ‘registry_name’ must conform to the following pattern
This is another blog post in the series of how to #MakeStuffGo in Azure. Background: I am working on a client project that requires containerised applications – so we...
2020-06-07
88 reads
Azure Platform Series: Push to GitHub repo with 2FA from a Mac using Personal Access Token
This is another blog post in the series of how to #MakeStuffGo in Azure. Background: I have some code on my Mac. I need to put it into an...
2020-06-07
37 reads
Azure Platform Series: How to setup Azure Cloud Shell
This blog post will be a series on the Azure Platform and some things we can use it for. Background: I run a consultancy company – and sometimes I...
2020-06-22 (first published: 2020-06-06)
238 reads
OPENJSON, explicit schema and data type
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
168 reads
Daily Coping 5 June 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-05
13 reads
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication. To make this easier,...
2020-06-19 (first published: 2020-06-05)
859 reads
SQL Server Authentication
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] We will be discussion SQL Server Authentication and below topics:- What...
2020-06-05
92 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat BCA KCU Gading Serpong Tlp:08218154374
Hub Via Wa:628218154374 Alamat Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster...
Alamat BCA KCU Tangerang City Telp:08218154374
Hub Via Wa:628218154374 Alamat Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20,...
Alamat Kantor BCA KCU Serang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers