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

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

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

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

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

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

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

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

Daily Coping 4 Jun 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...

SQL Homework – June 2020 – DML Triggers

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds ... Continue reading