New Microsoft SSIS transform
Microsoft has just released a new SSIS transform, called the SSIS Balanced Data Distributor (BDD). You can download it here.
This...
2011-06-15
1,354 reads
James Serra's Blog
What’s coming in SP1 for PerformancePoint
Check out What’s New in PerformancePoint Services and SP1? to see a list of the major features and updates included in...
2011-06-14
679 reads
SSIS Fuzzy Lookup Error
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,674 reads
Easier way to view SQL Server job history
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,383 reads
BIDSHelper 1.5 for SSAS, SSIS, SSRS released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2011-06-09
771 reads
Top 10 virtualization benefits for the developer
Virtualization is becoming a hot topic lately, and there is no doubt it provides a ton of benefits. But you...
2011-06-08
1,101 reads
Colleges starting to offer business intelligence degrees
Interesting video on eWeek.com called Business Intelligence Takes Higher Education Students to the Head of the Class that talks about...
2011-06-07
1,222 reads
Great white paper: Microsoft EDW Architecture, Guidance and Deployment Best Practices
A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices.
It’s a must read if you are...
2011-06-06
1,102 reads
PerformancePoint 2010 source control
While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...
2011-06-03
913 reads
Windows 8 demo
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
669 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...
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