I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
549 reads
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
794 reads
Over the past week there has been information finally coming out about how the Target breach occurred. This write up...
2014-01-24
932 reads
Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted...
2014-01-23
791 reads
Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that...
2014-01-21
481 reads
I looked at Outlook.com when it launched and recently revisited. I connected a couple of my personal email accounts to...
2014-01-21
538 reads
For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a...
2014-01-24 (first published: 2014-01-21)
1,598 reads
Ever say “one more minute” while working on something and then realize 30 minutes have gone by? My daughter has...
2014-01-17
636 reads
I went 30 miles south last night for the first meeting of the year. Extra good night because I was...
2014-01-16
487 reads
Email them, call them, instant message them – pick your preferred method, and send a message that says “I think you’d...
2014-01-16
510 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