Powershell and Passionate Evangelism
Back in July we had Chad Miller visit oPASS to do a presentation on Powershell. It was well received and...
2009-09-23
858 reads
SQLAndy
Travel for 2010
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 reads
PASS Book List
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
550 reads
PASS Connector Editorial for September 23, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
561 reads
One Too Many Plates Spinning
I’ve written here and there about my attempts at time management and the idea that as you spin more and...
2009-09-21
603 reads
South Florida Code Camp Announced for 2010
Just received a note from Dave Noderer that the 2010 South Fla Code Camp will be February 13th in Mirarmar,...
2009-09-21
531 reads
Follow Up To The Boss Is Always Right
My friend Kevin had sent this to me after I wrote The Boss Is Always Right but before it was...
2009-09-20
701 reads
Building a Chair – Part 2
Last week I posted Part 1 and Steve Jones gave some grief about not posting some pictures (rightfully so) of...
2009-09-17
835 reads
The Boss Is Always Right
Bet you’re ready to disagree, right? I’ve had this on my list to write about for a while. One trend...
2009-09-17
1,355 reads
Featured Blogger: Simon Sabin
Simon is a prolific blogger, at rough look averaging 10-15 posts per month, and almost all of them are SQL,...
2009-09-16
793 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