fun

SQLServerCentral Editorial

The Top 5 Technologists

  • Editorial

There's a common party question about which 5 people would you invite to a dinner party? Often this is amended to include living or dead people, and it's often interesting to hear people tell you who they'd invite and why. Since most of the people reading this work in technology in some way, I was […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2023-02-24

179 reads

External Article

The Data Center that Exploded

  • Article

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!

2025-01-01 (first published: )

10,375 reads

Blogs

Data Engineering Books Worth Having on Your Shelf (or your tablet)

By

Good documentation gets you started. Good books get you deep. After years of working...

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

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

Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Restoring Azure Key Vault Keys...

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