Blog Posts

Blog Post

Making Databases Personal

If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...

2019-04-09

125 reads

Blog Post

Making Databases Personal

If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...

2019-04-09

3 reads

Blog Post

Women in Tech Talk Tech

March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...

2019-04-09 (first published: )

1,036 reads

Blog Post

Database In Recovery Redux

One of the more gut-wrenching experiences of a DBA is to have a database get stuck in recovery. This typically happens when the server was rebooted unexpectedly and typically...

2019-04-08

16 reads

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

By

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...

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...

Read the latest Blogs

Forums

BCA KCP Bursa Efek Jakarta Telpon/wa:0813.7887.595

By bomchuachay34

BCA KCP Bursa Efek Jakarta Telpon/wa:0813.7887.595.Gd. Bursa Efek Jakarta, Jl. Jend. Sudirman kav 52-53...

BCA KCP Gunung Sahari Telp/WA.0821°3111°179

By Cakhia TV Bóng Đá Trực Tuyến

Telp/WA.0821°3111°179 Pert, Indah Blok B, Jl. Gn. Sahari Jl. Budi Mulia No.13 11-12, Pademangan...

Cara membuka blokir akun Bank Jago

By Kevin Champ

Cara membuka blokir akun Bank Jago yang terkunci karena salah PIN/password dapat dilakukan dengan...

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