Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,125 reads
SQLRunner
Virtual Presentation : Index Statistics
I just gave a virtual presentation, courtesy of Pass and the appdev group. The recorded presentation is available here:
Recorded Presentation
A...
2010-03-23
629 reads
Business needs vs dirty reads
I have worked in many industries, but most of my time has been in the publishing industry. For those not...
2010-03-12
289 reads
Managing user data and response through 'drop boxes'
There are a few ways to get data from a client to your system; FTP or email. Internally we tend...
2010-02-24
620 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-17
779 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-16
4,555 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-09
324 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-08
328 reads
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I...
2010-02-07
547 reads
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I...
2010-02-07
1,785 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers