T-SQL Tuesday #185–Being a Video Star
This month we have an interesting invite. Erik Darling is the host, and since he does a lot of video blogs, he’s asking for a video submission for T-SQL...
2025-04-08
14 reads
The Voice of the DBA
Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger
There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE...
2025-04-25 (first published: 2025-04-07)
493 reads
The Book of Redgate–Being Reasonable
As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...
2025-04-18 (first published: 2025-04-04)
408 reads
Comparing My Current Schema with a Backup with SQL Compare
A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that. This is part...
2025-04-21 (first published: 2025-03-31)
273 reads
A New Word: Zverism
zverism – n. the wish that people could suspend their civility and indulge in the physical side of each other first, sniffing each other’s hair like dogs, staring unabashedly...
2025-03-28
65 reads
CHOOSE’ing a Beer: #SQLNewBlogger
We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...
2025-04-09 (first published: 2025-03-26)
275 reads
Monday Monitor Tips: Looking Back in Time
Often we find out about a problem reported by a customer after the incident has passed. This might be from a trouble ticket or even an email that we...
2025-03-24
148 reads
Friday Flyway Tips: State-based deployment with Flyway Teams
I was asked about state-based deployments in Flyway Teams, so I decided to show how this can work with a quick demo. This post walks through the process. I’ve...
2025-04-04 (first published: 2025-03-21)
209 reads
Advice I Like: The Main Thing
The main thing is to keep the main thing the main thing. – from Excellent Advice for Living We can summarize this advice as focus on what’s important. I...
2025-03-21
10 reads
DATEADD Truncates the Number Parameter: #SQLNewBlogger
This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them....
2025-03-19
136 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
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!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
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
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers