Community

SQLServerCentral Editorial

Giving Thanks

  • Editorial

My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]

(1)

You rated this post out of 5. Change rating

2024-11-24 (first published: )

58 reads

SQLServerCentral Editorial

Baseball Everywhere

  • Editorial

Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on […]

You rated this post out of 5. Change rating

2024-06-15

55 reads

SQLServerCentral Editorial

Honeybee Swarms

  • Editorial

I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]

(1)

You rated this post out of 5. Change rating

2024-05-12 (first published: )

80 reads

SQLServerCentral Editorial

There's No Free Lunch with Open-source Software

  • Editorial

As a member of the PostgreSQL open-source community, I have been following the recent license change by Redis Labes on March 20, 2024. Redis introduced a dual license model, specifically adding the Redis Source Available License (RSAL), which prevents other vendors from providing Redis as a service without a paid subscription from Redis Labs. The […]

(3)

You rated this post out of 5. Change rating

2024-04-13

157 reads

SQLServerCentral Editorial

Give It Away

  • Editorial

Tech conference season is in full swing, and it’s only the middle of March. Between Grant, Steve, and I, we’ve attended or presented at about 10 events so far. And within my community of developers and database folks, I’ve seen pictures and posts of many more. As I’ve said a few times in previous editorials, […]

You rated this post out of 5. Change rating

2024-03-17

76 reads

SQLServerCentral Editorial

The Voice of the Customer

  • Editorial

This week I had the opportunity to join many of the U.S.-based Redgaters in Austin to talk about 2024 plans, hear from the product teams, and have some much-needed fellowship. One thing was particularly clear as I listened to various leaders and product managers – the customer drives everything we do. And I have to […]

You rated this post out of 5. Change rating

2024-01-20

49 reads

SQLServerCentral Editorial

A Thrill of Hope

  • Editorial

I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. 😊 However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently. 2023 hasn’t gone exactly […]

You rated this post out of 5. Change rating

2023-12-23

60 reads

SQLServerCentral Editorial

Community at PASS Summit

  • Editorial

Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]

You rated this post out of 5. Change rating

2023-09-30

47 reads

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

ROLLUP to calculate Month total for all Categories

By Reh23

Good Afternoon, I have built a table with four columns:  Period(Month), Category, Numerator, Denominator....

Creating JSON I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON I

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers