Blog Posts

Blog Post

Another Change

Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity firm. There are no details of terms, and you can read the press release. It’s...

2026-01-07

16 reads

Blog Post

Start with the FabricTools PowerShell module

Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the UI. Workspaces, capacities, and tenant-level settings all need repeatable, scriptable management. FabricTools is a community-driven PowerShell module...

2026-01-07 (first published: )

237 reads

Blogs

A Cloud Dependency Failure from Amazon

By

I went to sleep while reading a Kindle book on my phone. I know...

Deploying AI in logistics (the unfiltered version)

By

A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Read the latest Blogs

Forums

BCA KCP Pluit Raya Hub/Wa 08216977701

By noumanarshad

Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta 14440

BCA KCP Yos Sudarso HUB/CS 08216977701

By noumanarshad

Jl. Kebon Bawang VII No.40 2, RT.2/RW.6, Kb. Bawang, Kec. Tj. Priok, Jkt Utara,...

BCA KCU MUARA KARANG Telpon/WA.0853•5504•2311

By noumanarshad

BCA KCU MUARA KARANG Telpon/WA.0853•5504•2311 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah...

Visit the forum

Question of the Day

Creating a JSON Document III

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      1960
If I run this code, how many rows are returned?
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers