Another Change
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity firm. There are no details of terms, and you can read the press release. It’s...
2026-01-07
15 reads
The Voice of the DBA
Using Prompt AI to Help Setup Data Analysis
I used Claude to build an application that loaded data for me. However, there were a few others things I needed done to help me get the data ready...
2026-01-23 (first published: 2026-01-07)
316 reads
Monday Monitor Tips: Learning While Using the Tool
A customer was asking about what certain items in Redgate Monitor mean. They have a variety of skills on their staff, and they have developers accessing Redgate Monitor. This...
2026-01-19 (first published: 2026-01-05)
232 reads
Advice I Like: Pyramid Schemes
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
18 reads
Using Prompt AI for a Travel Data Analysis
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2026-01-16 (first published: 2025-12-31)
302 reads
2025 Wrapped for Steve
I’ve often done some analysis of my year in different ways. Last year I had a series of posts (health, music, reading, speaking, travel). This year, I took last...
2025-12-29
20 reads
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
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
Vibe Coding a Login Tracking System
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t do this natively, as this really needs an XEvent session. I decided to see if...
2026-01-02 (first published: 2025-12-17)
2,212 reads
Monday Monitor Tips: Native Replication Monitoring
Redgate Monitor has been able to monitor replication for a long term, but it required some work from customers. Now we’ve added native monitoring. This is part of a...
2026-01-05 (first published: 2025-12-15)
287 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers