Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with a little fantasy to ease and please the brain....
2011-09-16
5 reads
Blog Posts
Come and get your Data Education!
We all have been to various training courses throughout our professional career. Many follow a similar standard curriculum or course...
2011-09-16
920 reads
Conflict Resolution
More than once I’ve run into situations where I’m working with two people/groups that don’t get along. Especially as a...
2011-09-16
617 reads
Dreaming
It’s easy to get so busy with life you forget to dream, at least for me. Most of us have...
2011-09-16
707 reads
Import Data from AS400 to SQL Server
The process to import data from AS400 uses a SQL Server Linked server. The Linked Server points to an ODBC...
2011-09-16
17,088 reads
St. Louis SQL Server Users Group Feedback
You know I share what feedback I get from conferences. I don’t usually get feedback from users groups (well, I...
2011-09-16
857 reads
Ways to save money on Microsoft Software
If you are a developer and are on your own, or working for a company that does not have an...
2011-09-16
953 reads
Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,027 reads
PowerShell for the Easily Frustrated N00b, or, “A Simple and Useful Command”
The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro). Yes, I made...
2011-09-15
484 reads
Probe Residual on Hash Match
I have to say, I only recently noticed this on a tool tip:
and this in the property sheet:
The bad news...
2011-09-15
1,681 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