PASS Summit 2012 Day 2: Keynote
Welcome to Day 2 of the PASS Summit!
It’s been a very exciting event so far. Today I’m presenting two sessions,...
2012-11-08
1,001 reads
Welcome to Day 2 of the PASS Summit!
It’s been a very exciting event so far. Today I’m presenting two sessions,...
2012-11-08
1,001 reads
Welcome to the fourth Kilt Day at the SQL PASS Summit. It might be a little silly, but it’s fun....
2012-11-08
1,326 reads
We’re off and running here at the PASS Summit.
New this year is live streaming all day.
Bill Graziano is introducing the...
2012-11-07
927 reads
The Summit proper starts on Wednesday, but the Summit starts at registration. I left a little early from work setting...
2012-11-05
988 reads
I’m continuing to work with the Surface.
BOOM
I just had my first crash. I was in IE when I tried to...
2012-11-02
1,160 reads
More stuff about the Surface.
Web browsing works extremely well so far. I enjoy how you can swipe to move back...
2012-11-01
804 reads
I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the...
2012-10-31 (first published: 2012-10-28)
3,271 reads
Let’s talk some more about the basic keyboard. I’m really surprised at how well it works. But, it’s absolutely going...
2012-10-31
1,442 reads
I know I focus on community, SQL Server, professional development and process. But you need to do other stuff occasionally...
2012-10-26
730 reads
It may seem obvious, but I’ve heard more than one person suggest to me that statistics on a clustered index...
2012-10-22
1,160 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