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

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

Quickly Blocking Inbound Connections to SQL Server

Sometimes the brilliance of a solution is lost in its simplicity.  Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about...

T-SQL Sequences and the OVER() clause

Using a SEQUENCE object - in unusual ways!

What are you tuning for?

People want to make things faster. It’s in our nature as IT professionals. What are you tuning for? I’ve been asking that a lot later. I have to sit...