Sheldon Hull

Blog Post

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

7 reads

Blog Post

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

8 reads

Blog Post

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

6 reads

Blog Post

2020-05-07T22:54:34+00:00

Kept getting an error Incorrect syntax near the keyword 'read' when running the some updated PowerShell 7 in lambda with the dotnet3.1 sdk. Was troubleshooting loading types thinking I...

2020-05-07

9 reads

Blog Post

2020-05-07T22:54:34+00:00

Kept getting an error Incorrect syntax near the keyword 'read' when running the some updated PowerShell 7 in lambda with the dotnet3.1 sdk. Was troubleshooting loading types thinking I...

2020-05-07

12 reads

Blog Post

2020-05-07T22:54:34+00:00

Kept getting an error Incorrect syntax near the keyword 'read' when running the some updated PowerShell 7 in lambda with the dotnet3.1 sdk. Was troubleshooting loading types thinking I...

2020-05-07

7 reads

Blog Post

Improved Windows Terminal Setup

I’ve long been a Cmder/ConEmu user for Windows as it’s provided a much-needed improvement of the standard Windows terminal.
I’ve started trying to use the newer Windows Terminal project to...

2020-05-04 (first published: )

362 reads

Blogs

SSMS Evaluation – future ready

By

In previous posts, we looked at the SQL Server engine. for us DBAs, the...

Claude.ai vs Claude API

By

You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...

T-SQL Tuesday #198–Change Detection

By

This month we have a new host, Meagan Longoria, who graciously agreed to help...

Read the latest Blogs

Forums

Creating a JSON Document IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document IV

Permissions Removal When Changing Object Schema

By Brandie Tarvin

When the schema of an object is changed, SQL Server wipes out the previous...

Visit the forum

Question of the Day

Creating a JSON Document IV

I have this data in a table called dbo.NFLTeams

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960
If I run this code, how many rows are returned?
SELECT 
  YearEstablished,
  json_objectagg(city : TeamName)
FROM dbo.NFLTeams
GROUP BY  YearEstablished;

See possible answers