The Redgate Summit in Atlanta
Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on Mar 13. I’m doing the Keynote with Grant Fritchey and Kathi Kellenberger with this title,...
2024-03-04
73 reads
Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on Mar 13. I’m doing the Keynote with Grant Fritchey and Kathi Kellenberger with this title,...
2024-03-04
73 reads
2024-03-02
69 reads
aesthosis– n. the state of feeling trapped inside your own subjective tastes – not knowing why you find certain things beautiful or ugly, only that you do – wishing...
2024-03-01
80 reads
A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I showed them it does and decided to write a post on this. I’ve been working...
2024-03-01 (first published: 2024-02-16)
166 reads
One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put...
2024-03-01
57 reads
Steve thinks AI might have a place in security, something Microsoft is investigating now.
2024-03-01
131 reads
2024-03-01
406 reads
In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.
2024-02-28 (first published: 2017-09-13)
3,133 reads
2024-02-28
458 reads
Code reviews are a good way to not only improve your quality, but also raise the skill level of your staff.
2024-02-28
238 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
WhatsApp 08388331786.Jl. Kebon Bawang VII No.40 2, RT.2/RW.6, Kb. Bawang, Kec. Tj. Priok, Jkt...
WhatsApp:0817866887 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi Utara 95111
WhatsApp:0817866887 Jl. Ngurah Rai No.83, Pendem, Kec. Jembrana, Kabupaten Jembrana, Bali 82211
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