Building My Next Workstation–Part 1
It’s been four years – maybe more – since I last bought a workstation to use for development and lab work. It’s...
2013-02-18
742 reads
SQLAndy
My $200 Oops
My Nexus 7 tablet has grown on me, though I think it’s more about having a dedicated tablet than the...
2013-02-14
623 reads
Annual Catch Up and End of Job/Contract Networking Steps
It’s easy to get comfortable in a job and neglect to capture the relationships and connections you’ve built – for me...
2013-02-12
616 reads
Some Thoughts About Sponsors at SQLSaturday
I think it was because I had just received an email about sponsoring a SQLSaturday that had me thinking about...
2013-02-12
602 reads
LinkedIn Endorsements
Last year LinkedIn rolled out a new feature called endorsements, not to be confused with recommendations. Recommendations are free form...
2013-02-11
769 reads
The PASS BA Conference–Good Idea or Not?
Ever since it was announced I’ve been ambivalent about the PASS Business Analytics Conference. I believe PASS should look for...
2013-02-09
845 reads
Don Gabor Presents Mastering the Art of Conversation and Making Business Contacts in NYC
My friend Don Gabor is presenting a two hour seminar titled “Mastering the Art of Conversation and Making Business Contacts”...
2013-02-09
768 reads
SQLSaturday #200 in Philadelphia (And Vacation)
I’m planning to attend SQLSaturday #200 in Philadelphia on June 1, 2013. Number 200! This will be my first trip...
2013-02-09
602 reads
One Slick Solution and Unexpected Consequences
Quite a few years ago my first job in the military was driving a tracked vehicle, a variant of the...
2013-02-07
762 reads
I’ll Meet You Half Way–Compromising To Win
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it....
2013-01-28
775 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