SQL Saturday Dallas Update
Just a quick update on the SQL Saturday event we are planning for the Dallas area next year. Late last...
2009-09-13
666 reads
Tim Mitchell
Updating Existing Data with SSIS
I see a lot of questions on the forums about updating existing data in SSIS. When the update is dynamic...
2009-09-10
22,356 reads
SpeakerRate – Need Your Feedback
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...
2009-09-08
766 reads
24 Hours of PASS - Recap
At times it felt like a party, it had enough content to be a mini-conference, and we learned that some...
2009-09-03
869 reads
Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
556 reads
Pass Board of Directors
As you’ve no doubt heard or read, the call for nominations for the PASS Board of Directors is open until...
2009-08-27
586 reads
A New Identity
Well, perhaps not a whole new identity, just a consolidation of multiple facets of my online persona. For several years...
2009-08-23
533 reads
The Netbook: 40 Days In
I wrote last month about purchasing a new Toshiba netbook to supplement my mobile computing arsenal. Forty days later, I’m...
2009-08-22
610 reads
SQL Lunch
Baton Rouge SQL Server group leader and recent SQL Saturday host Patrick LeBlanc is putting together a new learning series. ...
2009-08-21
699 reads
Don’t Use USE (in SSIS, at least)
I ran into a situation this week that brought to light a subtle syntactical error I’d made in creating an...
2009-08-19
755 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