Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote that instantly stood out as my favorite of the day “Is it possible? …..Why not!...
2025-12-17 (first published: 2025-12-03)
124 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is Ireland’s free, community led, Microsoft Data Platform event. We had a fantastic event this year...
2025-12-16
64 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you might have hit a wall trying to get it running. Here’s what happened when I...
2025-12-15 (first published: 2025-11-26)
982 reads
Each year around this time, companies enter the familiar ritual of budgeting. For many, it feels like a long and exhausting negotiation between ambition and constraint. Everyone knows, it...
2025-12-15 (first published: 2025-12-02)
707 reads
Superheroes and saints never make art. Only imperfect beings can make art because art begins in what is broken – from Excellent Advice for Living Interesting advice for living...
2025-12-12
14 reads
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day to connect with new faces, explore the bustling expo hall, engage with customers and service...
2025-12-12 (first published: 2025-12-02)
286 reads
Following on from my last post about Getting Started With KubeVirt & SQL Server, in this post I want to see if I can improve the performance from the...
2025-12-11
92 reads
Dry-run xp_delete_file Before Actually Deleting Files?
xp_delete_file doesn’t really have a built-in dry-run option to preview which files it would remove. But there’s a simple workaround,...
2025-12-10 (first published: 2025-11-27)
489 reads
Announced at Microsoft Ignite two weeks ago were many new product features related to the data platform. Check out the Major announcements and Book of News. I went through the many announcements and picked...
2025-12-10 (first published: 2025-12-02)
383 reads
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t do that.Dave: What’s the problem?HAL: I think you know what the problem is just as...
2025-12-08 (first published: 2025-11-24)
145 reads
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...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Jl. Mayjen Sutoyo No. 76 Cililitan Kramat Jati (Lt .2 No. 641 Kota Adm,...
Jl. Cideng Timur No.11 F, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Blok G 7 C No, Jl. Danau Sunter Utara 1 dan 2, Sunter Agung,...
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