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...

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...

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...

3D Printing Ear Savers

On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...

A Byte of Redgate–Bonus Queso Recipe

As part of the Community Circle effort at Redgate, we’ve released a cookbook: A Byte of Redgate. You can read about the story in this blog, and it was...

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...

OPENJSON – using an explicit schema. The WITH clause.

G’day, Previously, we have looked at using OPENJSON to gain knowledge about the JSON document that we have presented to the function. A bit like this Notice that we...

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...

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-04T22:15:21+00:00

add dev container configuration for Go project in Visual Studio code
Added docker compose file
Add SQL Server to compose as another service.
docker-compose up -d
Attach to running container in VSCode
Magic ?

Now...