Help, not all of my column is displaying in the output of the query!
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we ... Continue reading
2022-03-09 (first published: 2022-02-22)
359 reads
Blog Posts
How do I merge a small part of a Git repo into another repo?
At my new day job, one of the things we want to do is migrate a portion of a really large Git repository (over 20GB) which I’ll call LargeRepo,...
2022-03-09
41 reads
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
5 reads
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
22 reads
Daily Coping 8 Feb 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-08
11 reads
Data Thoughts – T-SQL Tuesday #148 – Advice on running a user group
G’day, This months T-SQL Tuesday (March 2022) invite is brought to you by Rie Merrit – @IrishSQL Rie has asked us to write about “Advice on running a user...
2022-03-08
17 reads
Microsoft Defender for open-source relational DB
If you navigate to the overview section of your MySQL server you will see a notification area, here you will find security section. It’s basically an area to provide...
2022-03-08
15 reads
T-SQL Tuesday #148–User Group Advice
This month the T-SQL Tuesday invitation is from Rie Merritt, and it’s one that means a lot to me. I don’t actually run a user group, but I think...
2022-03-08
16 reads
ADX and KQL – Free Cluster for learning purposes
G’day, I’ve been looking around a bit lately at Azure Data Explorer (ADX) Clusters and the Kusto Query Language (KQL). I recently learned that Microsoft is letting people experience...
2022-03-07 (first published: 2022-03-06)
108 reads
Daily Coping 7 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-07
14 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Pademangan TLP/Wa 08216977749
Gg. 21 dan 22 No.1, Pademangan Tim., Kec. Pademangan, Jkt Utara, Daerah Khusus Ibukota...
BCA KCP Jembatan Dua TLP/WA 08216977749
Jl. Jemb. Dua Raya No.82 BB-BC, Pejagalan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota...
BCA KCU PASAR BARU TLP/HUB 08216977701
Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus Ibukota...
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 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers