31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)
31 Days of SSIS
It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series. As...
2011-01-28
886 reads
Blog Posts
A Quick TRIM, Sir?
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...
2011-01-28
2,152 reads
MySQL Saves You From Missing Where Clause, Sorta
I’ve been taking a look at MySQL after a long absence to help a client decide if it should be...
2011-01-28
918 reads
Speaking at the Rocky Mountain Tech Trifecta on March 5
I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on...
2011-01-28
679 reads
SQL Saturday #57 Houston
So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...
2011-01-28
468 reads
Un-SQL Friday #002 Roundup (finally)
The invitation for Un-SQL Friday #002 (Tech Giants) was, like, a week ago! I’ve gotta get this train a-rollin, or...
2011-01-28
958 reads
Upcoming presentations
It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...
2011-01-28
537 reads
31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
902 reads
A Half-Price Seat at the Masters’ Table
Well, it looks like I half-won the SQLskills competition for a free seat at a SQLskills Master Immersion Event on...
2011-01-27
521 reads
Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
19,120 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
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...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers