Treat Yourself to Knowledge
There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can...
2012-11-26
1,107 reads
There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can...
2012-11-26
1,107 reads
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,111 reads
No major updates at the moment. I still haven’t played with remoting through PowerShell. I’m just living with it.
Had an...
2012-11-19
993 reads
I sat the through the big announcements at the 2011 PASS Summit about the partnership between Microsoft and Hadoop. I...
2012-11-16
1,211 reads
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,368 reads
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
2012-11-12
17,086 reads
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
997 reads
I’m a little over two weeks with the Surface at this point. I’ve been travelling all of that time, so...
2012-11-11
1,469 reads
Two quick points, I’m putting this blog together using the Surface.. ooh… and this isn’t a keynote, but a spotlight...
2012-11-09
1,446 reads
I’m attempting to push this thing. I want it to be a production device, not just a consumption device. Frankly,...
2012-11-09
866 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...
Jl. Sultan Moh. No.136, Darat Sekip, Kec. Pontianak Sel., Kota Pontianak, Kalimantan Barat 78117
W979+XMQ, Jl. Arteri Supadio No.Kel, Sungai Raya, Kec. Sungai Raya, Kabupaten Kubu Raya, Kalimantan...
Jl. HOS Cokroaminoto No. 38, Kel. Pakuncen, Kec. Wirobrajan, Yogyakarta, DI Yogyakarta. Tips benar...
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