The affordable self-service BI revolution has started.
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been...
2012-01-30
1,875 reads
Business Intelligence & SQL Server Decaffeinated
Afterthoughts: IT Pro Camp Orlando 2012
This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando,...
2012-01-24
878 reads
Master Data Services Error: Resolving from a long-running stucked Staging Batch with Status “Queued to Clear” or “Not Running”
In some ocassions, you may run into a runaway, long-running or stucked staging batch with Master Data Services in SQL Server 2008...
2011-12-14
1,578 reads
Codeplex: SSIS Community Tasks and Components
I recently bumped into this very exhaustive list of SSIS tasks, components and samples in CodePlex http://ssisctc.codeplex.com. The list is maintained by...
2011-12-14
1,320 reads
SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error...
2011-11-29
1,740 reads
SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...
2011-11-16
1,280 reads
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...
2011-11-16
1,877 reads
GiveCamp Tampa 2011
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by...
2011-10-24
1,020 reads
Todo lo que debes saber sobre SSIS en 1 hora!
Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento...
2011-10-20
1,319 reads
MDS Error: MDMMemberStatus does not de-activate members through the StgMemberAttribute table
Master Data Services provides a way of de-activating entity members using the StgMemberAttribute table as described in Books On Line...
2011-10-11
1,012 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