Blog Posts

Blog Post

SQL Server 2022 Administration Inside Out

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This book is far more than a quick update. We've rewritten and refreshed large portions of...

2023-03-25 (first published: )

121 reads

Blog Post

Creativity in Technology

I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...

2023-03-24 (first published: )

177 reads

Blog Post

Finding guidance

We all need guidance as we make our way through our careers and our lives. Some people are blessed with the right folks who can offer that by way...

2023-03-24 (first published: )

141 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

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

By Site Owners

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

Is it uncommon for Dev's to have a data model of the source data

By Coffee_&_SQL

This is a generic question. To the moderators, I wasn't sure where to place...

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....

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