SQLAndy

Blog Post

Vacation Notes

I wrote this over the course of 10 days, so it’s a bit rambling, but maybe you’ll find a good...

2012-06-20

801 reads

Blog Post

On Break

I’m at Orlando International as I write this, about to fly to Parsippany for meetings today and tomorrow, then back...

2012-06-06

626 reads

Blog Post

The Rules of Gibbs

It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...

2012-05-29

846 reads

Blog Post

Unsubscribing

One of the things I’ve been doing lately is pruning (again) the number of newsletter type emails I get. Some...

2012-05-28

834 reads

Blogs

Future IT Roles – Agentic Architect and AI Boom!!

By

These days everything is changing to AI World, IT roles are getting changed and...

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

By

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...

A Cloud Dependency Failure from Amazon

By

I went to sleep while reading a Kindle book on my phone. I know...

Read the latest Blogs

Forums

SPAM Issues May 2026

By Steve Jones - SSC Editor

We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...

SQL Password enforcing

By Andre 425568

Hi to all We have situation at a client where someone is illegally changing...

SQL Password enforcing

By Andre 425568

Hi to all We have situation at a client where someone is illegally changing...

Visit the forum

Question of the Day

Creating a JSON Document III

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 TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers