An Un-CATCHable Error?
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
2010-03-23
2,173 reads
Tim Mitchell
PASS BI Virtual Chapter
Did you know that PASS has virtual chapters, allowing members to participate in virtual meetings that are geographically agnostic? One...
2010-03-22
1,218 reads
SQL Saturday is a’comin!
Just a quick reminder that registration is still open for SQL Saturday #35 in Dallas. This event will be held...
2010-03-16
551 reads
North Texas SQL Server User Group – March 2010
Join us this Thursday, March 18th for our monthly NTSSUG meeting. SQL Server MVP Sean McCown will be continuing his...
2010-03-15
586 reads
Alpha Split in SSIS, Redux
So I’ve discovered another benefit of being a technical blogger. Not only do you get some kudos when you write...
2010-03-07
883 reads
User Group Leaders: Who Are Your Members?
At the MVP Summit last week, I was talking with fellow Dallas-area tweep Sean McCown about our local SQL Server...
2010-02-26
1,636 reads
Editorial - “Dude, Your Fly Is Open”
In case you don’t subscribe to the SQL Server Central daily newsletter, check out the editorial I wrote entitled “Dude,...
2010-02-25
600 reads
The PASS Acquisition of SQL Saturday
A couple of weeks ago, it was announced that the SQL Saturday franchise was voluntarily transferred to PASS . This change...
2010-02-15
1,173 reads
A New Season (A Networking Success Story)
I’d like to share a networking success story. Last year, I blogged about my experience at the PASS Summit of...
2010-02-05
1,180 reads
SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,407 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