how to get ahead
Many people have ideas as to how to do well in life. Of course, many people do not even agree...
2012-12-05
1,640 reads
@chuckboycejr
should I use clustering on a VM?
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...
2012-11-28
878 reads
thanks for Bud
My Dad died horribly three weeks ago in a fall after the power got knocked out during Hurricane Sandy. I...
2012-11-22
826 reads
blogging fun: dealing with spammers like Psychz Networks
@PsychzNetworks is spamming me non-stop. Every minute of every day.
I googled them and it seems Psychz Networks are famous for...
2012-11-21
1,504 reads
[video] Inside Tempdb - Bob Ward
Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours...
2012-11-20
2,474 reads
Bob Duffy
ok, everyone has their favorite SQL guru and favorite SQL tips. There are some people whose names you associate with...
2012-11-19
920 reads
circle of trust
I have heard it said that a former US President once remarked "People tell you who they are by their...
2012-11-16
662 reads
"fail fast" vs calligraphy
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
686 reads
problem solving: sometimes you need to walk away from a problem to solve it
If anyone is a believer in solving challenges through sheer force of will, it's me. I'm a stubborn man and...
2012-11-14
717 reads
How to obtain the version and license for a Red Gate SQL BACKUP install
/*
here is a little script I've hobbled together that I use to get version and license info for a Red...
2012-11-13
1,150 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