Intel Nehalem-EX and Database Performance
Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon...
2010-01-18
860 reads
Glenn Berry
The Energy Detective TED 5000 Installed And Working
Back in October, I ordered one of the new TED 5000 energy monitors directly from Energy, Inc. in Charleston, SC....
2010-01-16
822 reads
Second Shot Promotion For Microsoft Certification Exams
Microsoft and Prometric have renewed their Second Shot promotion for certification exams. This allows you to retake a failed exam...
2010-01-16
908 reads
PASS 2009 Speaker Evaluation Scores
Since quite a few PASS 2009 speakers have gone public with their speaker evaluation scores, I might as well do...
2010-01-15
772 reads
Using Synthetic Benchmarks To Help Evaluate Database Server Hardware Choices
As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA...
2010-01-15
734 reads
Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,473 reads
Intel Intelligent Home Energy Management
Last week at CES 2010, Intel showed off a proof of concept device for a home energy management dashboard. This...
2010-01-12
991 reads
Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010
Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...
2010-01-11
821 reads
New HTPC Build with 32nm Intel Core i3 530
Since Intel announced and released the new 32nm Core i3 processors and compatible H55 chipset, Socket 1156 motherboards this week,...
2010-01-09
2,974 reads
Time to Upgrade from SQL Server 2005 SP2 and SQL Server 2008 RTM
Microsoft’s Bob Ward posted to remind everyone that SQL Server 2005 SP2 support ends on January 12, 2010, and SQL...
2010-01-08
705 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