T-SQL Tuesday #21 - Yes, Today is Wednesday!
T-SQL Tuesday #21 - A Day Late and Totally Full of It
Holy Crap! What in the world are we talking about...
2011-08-10
1,857 reads
Blog Posts
T-SQL Tuesday (er, Wednesday): Crap Code
Ok, I have two admissions that I must bare to the world in this post. The first is that I’ve...
2011-08-10
1,267 reads
T-SQL Tuesday (er, Wednesday): Crap Code
Ok, I have two admissions that I must bare to the world in this post. The first is that I’ve...
2011-08-10
702 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and...
2011-08-10
730 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and bringing us oodles of failure. Adam Machanic is hosting...
2011-08-10
3 reads
T-SQL Tuesday/Wednesday #21: A Crappy Workaround
A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...
2011-08-10
2,066 reads
Two Types of Tail Log Backups
In a recent thread I noted that a tail log backup is essentially a regular log backup, but made with...
2011-08-10
4,156 reads
What It Means To Me To Be A Volunteer
Hi my name is Wes, and I am a volunteer
I am not unique. There are others like me, who give...
2011-08-10
1,335 reads
All about Execution Plans
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
770 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for...
2011-08-09
671 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