oPASS June 2010 Meeting Date Change
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
567 reads
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
567 reads
Last week I blogged about attending TechEd 2010 on a press pass, and since then I’ve been trying to come...
2010-05-19
560 reads
I’ve blogged on this before, here and here, and ended up chatting about it on Twitter (see, I do use...
2010-05-19
666 reads
You can choose from how query optimization works and why it’s so hard, or how relational engines and MapReduce can...
2010-05-19
656 reads
I struggled with the title for this one. One of the thoughts I had was that I believe in being...
2010-05-18
683 reads
On Thursday I presented ‘Building a Comprehensive Professional Development Plan’ to the PASS Professional Development Chapter (#PASSProfDev on Twitter) via...
2010-05-17
719 reads
A friend is moving into a leadership role for the first time and we talked some about making that transition....
2010-05-14
954 reads
Had this on my list todo list, upgrade my laptop that just had plain old SQL 2008 on it. The...
2010-05-13
616 reads
It’s been a couple years since I’ve attended and always found Teched to be a great event, more content than...
2010-05-12
1,225 reads
This was a phone meeting on April 8th, 2010, that covered:
Possibility of an online track at the 2010 PASS SummitDiscussion...
2010-05-11
690 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