TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree. I've built a web tool that helps visualize this tree as a learning exercise.
Foreword
I've leveraged...
2025-12-03 (first published: 2025-11-09)
112 reads
The crime spree in Digitown is not ending. This time 20 cars have been stolen and we need to find where they’re stored.
The problem
This is the abridged case description....
2025-06-09 (first published: 2025-05-16)
280 reads
The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.
The problem
The police have asked for our assistance, and we’ve...
2025-06-02 (first published: 2025-05-13)
200 reads
Another KDA case: Digitown’s utility bills suddenly doubled for no good reason. With the election coming up, I got pulled in to figure out what went wrong. I’ve got...
2025-05-30 (first published: 2025-05-02)
202 reads
I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.
The UI layout
This is what your layout might look like:
LHS menu where you...
2025-05-12 (first published: 2025-04-26)
38 reads
While I mostly write about SQL Server, I have a soft spot for Kusto. In this series, I will explore solutions to fun challenges collectively known as the Kusto...
2025-04-27 (first published: 2025-04-26)
111 reads
Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.
The problem
I attempted to deploy a...
2025-03-19 (first published: 2025-03-07)
204 reads
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but …
reading the extended event...
2024-11-04 (first published: 2024-10-18)
424 reads
I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing...
2024-09-13 (first published: 2024-08-26)
270 reads
This month’s invitation is from Mala Mahadevan (b) asking us how we manage the database code. Since this is my passion project, I have a few basic tips to...
2024-09-06 (first published: 2024-08-13)
421 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. Kedung Doro No.118, Sawahan, Kec. Sawahan, Surabaya, Jawa Timur 60251
BCA KCU PONDOK INDAH Telpon/wa:0813.7887.595.Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17,...
Jl. Tunjungan No.36, Genteng, Kec. Genteng, Surabaya, Jawa Timur 60275
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