Removing All SQL Server Query Store Data
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
537 reads
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
537 reads
One of the many small things you don’t have to worry about any more when working with Azure SQL Database...
2016-01-18 (first published: 2016-01-11)
1,400 reads
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
586 reads
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic....
2016-01-12
436 reads
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,747 reads
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
965 reads
Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?
Never mind.*
Instead, it seems I’ll be...
2015-12-18 (first published: 2015-12-14)
1,248 reads
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
453 reads
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
484 reads
This represents my 12th month on the board so I thought I would recap my time there so you know...
2015-12-09
480 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. Tanjung Duren Dalam III, Tj. Duren Utara, Kec. Grogol petamburan, Kota Jakarta Barat,...
Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23, Kec. Grogol...
Jl. Kemanggisan Utama Raya No.37, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota...
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