Struggling With Due Diligence
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
532 reads
SQL Swimmer
Did you know?
Did you know that the call for speakers for PASS Summit 2016 opened on February 3, 2016?
Did you know that...
2016-02-15
432 reads
What is Power BI?
One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you...
2016-02-02 (first published: 2016-01-25)
3,018 reads
What Do You Want?
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
378 reads
We Want You!
It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already. ...
2016-01-08
406 reads
Scripts – A Living History
As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who...
2015-11-20
967 reads
Aggregation Design is Back!
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...
2015-11-19
464 reads
One Tool to Rule Them All – Almost
There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One...
2015-11-18
598 reads
My Build and Deploy Process (as Requested by Bill Fellows)
Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...
2015-11-10 (first published: 2015-11-05)
2,662 reads
The Whirlwind That Is October – Part 3
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-11-03
509 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