SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2008-12-29
14,304 reads
Blog Posts
April Fools Challenge
I know it's not April 1st yet, but I wanted to throw out a couple comments and a challenge well...
2008-12-28
1,512 reads
A Little Work
Tia came down and asked if we should do something with the kids, bowling, movies, etc. I told her I...
2008-12-26
1,432 reads
One Year In
I got my Toshiba Qosmio a little over a year ago and it has been a great machine for me...
2008-12-26
1,447 reads
When Data Mining Goes Too Far
Data mining is commonly used to find otherwise undetectable patterns in related sets of data. However, sometimes these patterns provide...
2008-12-26
1,521 reads
Grasshopper
During a recent class I happened to mention something about grasshopper, and a student wasn't familiar with the reference to...
2008-12-25
1,768 reads
Merry Christmas
I'm sure some of the geeks out there are logging onto the web, checking feeds, and whiling away some of...
2008-12-25
1,392 reads
Building an Infrastructure
As we try and evolve our automotive industry, and perhaps our energy policy, to move into the future in the...
2008-12-24
1,486 reads
Merry Xmas
I'm enjoying today with family and hope you are as well. Nothing complicated today, just some appropriate music!
Bruce Springsteen - Santa...
2008-12-24
1,465 reads
Blackberry Bold
It was only a year ago that I moved from the Blackjack to the Blackberry Curve and overall I was...
2008-12-23
1,413 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
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...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
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