The February Energy Update
Steve Jones takes a look at the world of energy news and a few projects out at the ranch.
2008-04-29
466 reads
Steve Jones takes a look at the world of energy news and a few projects out at the ranch.
2008-04-29
466 reads
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-28
30 reads
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
2008-04-27
28 reads
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
2008-04-24
40 reads
2008-04-23
36 reads
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
2008-04-22
481 reads
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
36 reads
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
29 reads
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-15
35 reads
2008-04-14
35 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