Simple And Amusing Question Of The Day
I was working on a script today to check the range of some values and trying to take the time...
2014-04-11
573 reads
SQLAndy
Quarterly Goals
Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to...
2014-04-11
532 reads
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
564 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
501 reads
SQLServerCentral Editorial: Team Reputation
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who...
2014-04-04
603 reads
The Untold Story of SQLHotties.com
Back when SQLSaturday was in the #20’s or so I bought SQLHotties.com, thinking it would be good for an April...
2014-04-03
567 reads
PASS Election Season Begins
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
526 reads
A Questionable Trigger–Question Of the Day
A Questionable Trigger is the SQLServerCentral Question of the Day today. It’s my latest and perhaps the hardest. Here is...
2014-04-02
465 reads
Solid State Tapes–Prelaunch News!
Note: Sorry for the vague details on the tech part, you’ll get all of that tomorrow – this is what I...
2014-04-01
453 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,200 reads
Blogs
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...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
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