Blog Posts

Blog Post

go

Starter Template
I saved this as a snippet for vscode to get up and running quickly with something better than the defaults for handling func main isolation.
I’ve been working on...

2020-10-30

25 reads

Blog Post

shell

Installing go-task
This tool is great for cross-platform shell scripting as it runs all the commands in the Taskfile.yml using a built in go shell library that supports bash syntax...

2020-10-30

28 reads

3Cloud image

Welcome to 3Cloud …

A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....

2020-10-30 (first published: )

225 reads

Blogs

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

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

Alamat kantor resmi BCA KCU BEKASI Telp:0817866887

By CS.Bank BCA

WhatsApp:0817866887 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...

Alamat kantor resmi BCA KCP Balaraja Telp:0817866887

By CS.Bank BCA

WhatsApp:0817866887 Jl. Raya Serang Km. 24, Kp. Cariu, RT 003/001, Talagasari, Kec. Balaraja, Kabupaten...

SQL Password enforcing

By Andre 425568

Hi to all We have situation at a client where someone is illegally changing...

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