Friday Flyway Tips–Seeing Pending Migrations
I find that quite a few people using Flyway will end up with a lot of migration scripts over time. While you can certainly re-baseline and split scripts into...
2023-11-03
48 reads
I find that quite a few people using Flyway will end up with a lot of migration scripts over time. While you can certainly re-baseline and split scripts into...
2023-11-03
48 reads
2023-11-03
663 reads
Today Steve looks at the case when one software developer finishes their work, but another doesn't. The challenge of reordering work is something that happens more and more as teams struggle to coordinate their efforts.
2023-11-03
124 reads
I had a customer recently ask if they could find out which objects are dependent on others using SQL Doc. This post shows how to do that. Using SQL...
2023-11-01
319 reads
2023-11-01
341 reads
There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.
2023-11-01 (first published: 2017-12-01)
320 reads
The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
2023-11-01
658 reads
Training more people on the job, while still allowing them to continue their education is something Steve thinks would help more people get started in technology.
2023-10-30
115 reads
2023-10-30
497 reads
funkenzwangsborstellung – n. the primal trance of watching a campfire in the dark. I am not a big camper, but 3-4 times a year we usually go out with...
2023-10-27
20 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...
Telp/wa 085169998803 Jl. Abdulrahman Saleh No.101 Kav C-D, Kalibanteng Kulon, Kec. Semarang Barat, Kota...
Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar No.23 Blok a, Kebon Baru,...
Telp/wa 085169998765 Jl. Kedungmundu No.121, Tandang, Kec. Tembalang, Kota Semarang, Jawa Tengah 50274
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