Interviewing a DBA
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,582 reads
Blog Posts
To Blog or Not To Blog
Blogging seemed like a big deal in 2004. At the 2003 PASS Summit, we were told by Microsoft that they...
2005-06-29
1,517 reads
My First Blog!
At least here 🙂 Normally I blog over at http://www.dkranch.net/
That's usually personal stuff going on in my life, so I'll try...
2005-06-28
1,410 reads
2001-01-01
14 reads
Courtney Woolum
A longer bio or profile text can go here in Markdown. There should be a lot more here
2001-01-01
4 reads
Privacy Policy
The Agile SQL CLub Privacy Policy (google Made me do it) The website uses cookies to track views and where you go, if you block cookies then they will...
2001-01-01
10 reads
Privacy Policy
The Agile SQL CLub Privacy Policy (google Made me do it) The website uses cookies to track views and where you go, if you block cookies then they will...
2001-01-01
7 reads
2001-01-01
4 reads
About Ed Elliott
Hi,
My name is Ed Elliott, I live in Sussex, England with my family. I work in and around data and when people ask me what I do for a...
2000-02-12
7 reads
About Ed Elliott
Hi,
My name is Ed Elliott, I live in Sussex, England with my family. I work in and around data and when people ask me what I do for a...
2000-02-12
15 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers