How To Get Fired from an ETL Developer Job
Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...
2015-05-15
2,058 reads
Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...
2015-05-15
2,058 reads
Dear vendor:
Dear Vendor: Keep My Information Secure
If you’re reading this, we have done business together, either directly or indirectly. You...
2015-05-08 (first published: 2015-04-27)
5,976 reads
Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In...
2015-04-30 (first published: 2015-04-20)
12,216 reads
In my most recent post in this series, I talked about how to use the SSIS object variable as an...
2015-04-27
4,816 reads
Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself...
2015-04-24
567 reads
Some time back I wrote about how to use the script component to parse out ragged data files in SSIS....
2015-04-22 (first published: 2015-04-13)
6,000 reads
“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...
2015-04-17 (first published: 2015-04-09)
5,687 reads
The answer: It Depends.
One of the more common problems I encounter when managing data quality, especially in an ETL process,...
2015-04-15 (first published: 2015-04-06)
7,570 reads
This week, PASS announced the Best of PASS Summit 2014, a collection of the 10 highest-rated sessions from last fall’s...
2015-04-13 (first published: 2015-04-04)
5,944 reads
When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there...
2015-04-10
618 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item 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