The Book of Redgate: Spread across the world
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia I miss Brad. I enjoyed traveling around and working with him. I’d forgotten about Bob...
2025-12-26
33 reads
Blog Posts
Merry Christmas
Today is Christmas and while I do not expect anybody to actual be reading today, here it is nonetheless. I wish you and your family as many blessing as...
2025-12-25
12 reads
T-SQL Tuesday #193 – Notes to my past self and from my future self
It has been a while since my last T-SQL Tuesday blog. When I saw Mike Walsh’s topic for T-SQL Tuesday #193, I was intrigued and inspired – “Notes to...
2025-12-24 (first published: 2025-12-09)
234 reads
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike Walsh. Mike’s call for us is to end the year on a poignant note –...
2025-12-24 (first published: 2025-12-09)
147 reads
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened and pilots stalled, organizations across industries faced the same challenge: turning AI expectations into sustainable...
2025-12-22
28 reads
More fun with Git: git restore
The setup My day job involves babysitting a lot of Git repositories hosted on GitHub. The vast majority of the commits, merges, and squashes I run on a daily...
2025-12-22 (first published: 2025-12-09)
466 reads
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
Recently, the world was reminded of just how fragile the internet can be. Two well established cloud services, Cloudflare and Azure Front Door, both had simultaneous outages that caused...
2025-12-22 (first published: 2025-12-08)
401 reads
A New Word: Etherness
etherness – n. the wistful feeling of looking around a gathering of loved ones, all too aware that even though the room is filled with warmth and laughter now,...
2025-12-19
133 reads
Prepping for Certification, Part 4 of 4
In Parts 1-3, I covered how I prepare for a certification exam. In this last part, I'll talk about how I go about taking the exam.
2025-12-19 (first published: 2025-12-08)
434 reads
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When your SQL Server goes down, alarms are blaring, and managers are hovering, that sentence might...
2025-12-19 (first published: 2025-12-03)
619 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers