Taxing Travels
It was a long weekend of travel for me not too long ago, starting at 4:30am on Friday and ending at 7:30pm Sunday night. This was for SQL Saturday...
2019-07-05
19 reads
The Voice of the DBA
Come See the Future of Database DevOps at SQL Sat Austin
I’ll be coming to SQL Saturday #890 – Austin in just over a week. Austin is a great technology town, and this should be one of the larger SQL...
2019-07-03
35 reads
Getting Started with Spawn
I’m excited that the Redgate Foundry is working on some cool projects. The Future of DevOps is one and part of that work is with Spawn. I’ve played with...
2019-07-16 (first published: 2019-07-01)
447 reads
Honored to be a Microsoft MVP
Today is the renewal date for Microsoft MVPs. I received an email a short while ago informing me that I was being awarded again for the July 2019 –...
2019-07-01
19 reads
Basic User Functions in R
As I’ve been learning more about the data platform, I’ve been exposed to some R language code. This makes sense, as more comprehensive data analysis needs something other than...
2019-07-12 (first published: 2019-06-26)
542 reads
Watch the State of SQL Server Monitoring tomorrow
Tomorrow Redgate is running a webinar on the State of SQL Server Monitoring with Grant, Chris Yates, Annette Allen, and Tony Maddonna. You can register now and attend on...
2019-06-24
13 reads
SQLServerCentral–Fixing the Time Zone
One of the bugs features of the bbPress forum software is that all posts were shown in a time zone, which for us was a default of UTC. Not...
2019-06-22
31 reads
Just a Week to SQL Sat Pensacola
One of my favorite events, in a wonderful place to spend the weekend. I’ve been to Pensacola a few times (3?), including a couple times with my daughter. It’s...
2019-06-20
39 reads
A Double Day
I’m traveling back from Australia today. A few weeks ago I lost a day when I flew West across the Pacific. Today I get it back, with a different...
2019-06-16
14 reads
Simulating Load
I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...
2019-06-27 (first published: 2019-06-12)
472 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