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

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

We have seen how we can export and save the results to a folder and commit them to a GIT repository on my last blog post Backup your SQL...

Data Visualization, Context, and Domain Expertise

I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. The graph is from Fitbit. It shows the number of steps...

T-SQL Sequences and the OVER() clause

Using a SEQUENCE object - in unusual ways!

Approaches to running Databricks ETL code from Azure ADF

Databricks is fantastic, but there is a small issue with how people use it. The problem is that Databricks is all things to all people. Data scientists and data...