2014-10-17
1,769 reads
2014-10-17
1,769 reads
The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...
2014-10-16
799 reads
London, Oct 24, 2014
Seattle, Nov 3, 2014
Come join us.
Filed under: Blog Tagged: Humor, syndicated
2014-10-16
816 reads
It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time...
2014-10-14
696 reads
2014-10-14
1,722 reads
Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.
2014-10-13
121 reads
I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me...
2014-10-13
927 reads
2014-10-13
2,141 reads
This week Steve wants to know if you'd have some issues when analyzing data and you've mistaken correlation for causation.
2014-10-10
177 reads
2014-10-10
1,691 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...
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
Telp/wa 085169998803 Jl. Kapten Muslihat No. 15 A, Pabaton, Kecamatan Bogor Tengah, Kota Bogor,...
Jl. Taman Aries Blok E1 No. 2A & 2 B, Meruya Utara, Kec. Kembangan,...
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