Technical Article

Mistake or #Fail

When things aren't done well or set up properly in your systems, is it a mistake or a failure? Steve Jones talks about the need for those working with technology to be sure that they are taking responsibility for being educated about how to do things.

SQLServerCentral Editorial

Is Networking Important?

There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.

Technical Article

Is Networking Important?

There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.

Technical Article

Is Networking Important?

There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.

Technical Article

Is Networking Important?

There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.

Blogs

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

By

If you are considering any of the ISACA AI certs like the Advanced Artificial...

A Fabric solution can be very cost effective

By

Are you currently using Microsoft Fabric or considering migrating to it? If so, there...

Track SQL Server Configuration Changes Using the Error Log

By

Track SQL Server Configuration Changes Using the Error Log If you...

Read the latest Blogs

Forums

Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887

By Layanan BCA_24jam

WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...

Alamat kontak resmi BCA KCP Taman Melati Telp:0817866887

By Layanan BCA 24 JAM

WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...

SQL Server Showing Out of Space But Plenty of Drive Space

By AMCity

We have a SQL Server installed. We have a 500GB drive for the database....

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