2014-08-18
1,687 reads
2014-08-18
1,687 reads
Steve Jones wonders about the next generations of IT workers. Can we encourage more people to enter this field? With the supposed shortages of talent today and the poor reputation of IT positions, can we change the trend of fewer people entering IT?
2014-08-15
190 reads
How much would you pay for a laugh? Maybe you'll donate to ensure that some of your SQL Server speakers will embarrass themselves at the PASS Summit.
2014-08-14
254 reads
Can a single piece of software work well for most situations? Steve Jones wonders if we're not attacking the problems of large software applications in the right way.
2014-08-13
161 reads
I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL...
2014-08-12
763 reads
Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.
2014-08-12
240 reads
It’s T-SQL Tuesday time again. After missing two months with my sabbatical, I’m back.
The topic this month is hosted by...
2014-08-12
706 reads
More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.
2014-08-11
109 reads
Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog,...
2014-08-11
563 reads
2014-08-08
1,860 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
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