SQLServerCentral Editorial: The Perfect Environment
I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them...
2014-03-28
534 reads
SQLAndy
Building the SQLSaturday Orlando Marketing Plan–Part 1
I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the...
2014-03-28
498 reads
Can’t See The Forest For the Logins–Question of the Day
My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing...
2014-03-28
438 reads
Speaking at OPASS – April 2014
If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a...
2014-03-26
626 reads
The Unusable User–Question Of The Day
My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for...
2014-03-26
691 reads
Notes From the Orlando Code Camp
Nice to have a SQL track! Looked like it averaged 20-25 attendance per session.Ran smooth, thanks to Esteban Garcia and...
2014-03-24
525 reads
Notes From the March 2014 oPASS Meeting
Rodney Landrum presentingLots of free form demos, very light on slides – nice changeLooked at Power Pivot, Power Query, and Power...
2014-03-24
602 reads
Speaking At SQLSaturday #298 in Jacksonville on May 10, 2014
Got the email confirmation yesterday that I’m on the schedule – looking forward to being back in Jacksonville.
2014-03-24
501 reads
More On Alas Snapshot
Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than...
2014-03-21
445 reads
Meetings In Glass Houses
If you’ve followed my writing for a while you’ll know I’m a fan of translucency (transparency) in most things business....
2014-03-20
521 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