2008-12-08
488 reads
Editorial - iPod
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
2008-12-06
732 reads
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
2008-12-04
71 reads
Just Keep Going and Going and Going
The upgrade treadmill might hit you in ways that you didn't expect.
2008-12-03
83 reads
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
508 reads
2008-12-01
927 reads
The Ebb and Flow of Community
Phil Factor talks a bit about the SQLServerCentral community and how we all get something different from it.
2008-11-26
525 reads
2008-11-26
641 reads
2008-11-25
510 reads
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
2008-11-24
511 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