SQL Lunch #48 Advanced SSIS Tips & Tricks
I had the privilege of giving a SQL Lunch presentation today. The slide deck for that can be found here: SSIS Tips & Tricks deck. The recording can be...
2011-01-30
6 reads
Josef Richberg
Shout out to SQLPeople.Net
I wanted simply give a shout out to Andy Leonard (twitter | blog) for his never ending commitment to the SQL...
2011-01-29
1,331 reads
Shout out to SQLPeople.Net
I wanted simply give a shout out to Andy Leonard (twitter | blog) for his never ending commitment to the SQL Community. Take a look at SQLPeople.net and join...
2011-01-29
7 reads
Shout out to SQLPeople.Net
I wanted simply give a shout out to Andy Leonard (twitter | blog) for his never ending commitment to the SQL Community. Take a look at SQLPeople.net and join...
2011-01-29
5 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change the format of its data feed. Evidently, today...
2010-12-16
836 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change
the format of its data feed. Evidently, today is not every day. It would
be one thing...
2010-12-16
15 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change the format of its data feed. Evidently, today is not every day. It would be one thing...
2010-12-16
13 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,092 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
Blogs
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...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Forums
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...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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