2008-05-08
35 reads
2008-05-08
35 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-07
36 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-06
41 reads
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
2008-05-04
38 reads
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
2008-05-02
485 reads
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
2008-05-01
34 reads
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-04-30
39 reads
Steve Jones still thinks there is a lot of value in books, both fiction and non-fiction, but he's looking at e-Readers, specifically the Kindle from Amazon.
2008-04-29
28 reads
Steve Jones' bimonthly update on the state of transportation and what's happening with his Prius.
2008-04-29
495 reads
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
2008-04-29
504 reads
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
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