My Fat Finger and the Target Invocation Exception
I was creating an SSIS package recently and ran into the “TargetInvocationException: Exception has been thrown by the target of...
2010-11-12
706 reads
Blog Posts
PASS Summit 2010-Thursday
Quick recap of yesterday afternoon: blur! I know I did stuff, but the pace is brisk and I’m just keeping...
2010-11-12
544 reads
SQL Rally Precon Vote Results
The votes have all been tabulated and during PASS this week the top pre conference seminars were announced for SQL Rally.Thankfully...
2010-11-12
508 reads
SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source variables. Once again in my quest for performance,...
2010-11-12
817 reads
SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source
variables. Once again in my quest for performance, I look to keep as much
data as possible in memory....
2010-11-12
1,072 reads
SSIS : Using variables as a source in a Data Flow Component
Currently, none of the existing Data Flow sources allow you to source variables. Once again in my quest for performance, I look to keep as much data as possible...
2010-11-12
11 reads
The New Path To MCM
Microsoft has announced changes to the MCM program. This page shows all the ways that you can become an MCM...
2010-11-12
1,327 reads
Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
881 reads
Defensive Db Programming Chapter 08
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this...
2010-11-11
547 reads
Defensive Db Programming Chapter 08
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this series by looking here. We are now discussing chapter 8...
2010-11-11
3 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