Reblog: Slow source? Make your data flow buffers smaller!
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...
2015-08-13
798 reads
Koen Verbeeck
Scripts and SSDT-BI 2013
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means...
2015-08-11
1,028 reads
SSIS Catalog – Path to backup file could not be determined
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...
2015-08-13 (first published: 2015-08-10)
4,845 reads
SSDT-BI and Visual Studio Online
Recently I had to create a new business intelligence project at a client. However, there was no source control present....
2015-08-07
2,520 reads
Reblog: The OLE DB Source and the Oracle Date Literal
SQLKover update:when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog...
2015-08-06
805 reads
My favourite books
As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the...
2015-08-04
618 reads
Reblog: The shaky bug in SSIS
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this...
2015-07-30
1,026 reads
Reblog: Star Schema The Complete Reference – Review
SQLKover update:1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on...
2015-07-30 (first published: 2015-07-23)
2,203 reads
Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy
Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the...
2015-07-16
1,095 reads
Speaking at SQL Server Days 2015
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The...
2015-07-15
657 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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