Backup History
Can you tell me the drive we were backing up server #58 to exactly 8 months ago, and, if possible,...
2013-05-14
421 reads
Simple SQL Server
Cluster Info
This script is so simple you’ll start off by asking why you’d ever use it. Then you’ll use it and...
2013-05-14
602 reads
File Sizes
There are two scripts I like to use to look at the file sizes on servers. The first one is...
2013-05-14
448 reads
Copy / Paste Code
Copy / Paste formatted text is a nightmare in WordPress. I’m singling out WordPress because I use it, and, from what...
2013-05-13
579 reads
Database Assessment
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
470 reads
2013-05-10
409 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