Setting Goals for the New Year and Beyond
I've never been a big fan of "New Year's Resolutions" for the same reason most other folks are against them:...
2006-12-29
1,595 reads
Blog Posts
Phone books and Indexes
On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group. I really enjoy speaking to this...
2006-12-22
1,391 reads
SET QUOTED_IDENTIFIER
We recently received a script for a modified stored proc from a vendor. My colleague ran the script on the...
2006-12-15
2,564 reads
The Moto Q and Being Proactive
I am a big fan of automating whatever I can and being proactive. The more proactive you can be, the...
2006-12-14
1,506 reads
How to handle an invalid default database
My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...
2006-12-11
1,898 reads
Midlands PASS Chapter is official
A group of us met on Thursday, December 7th, 2006, and voted to approve the bylaws and a motion to...
2006-12-11
1,450 reads
Jason Haley recently began posting his interesting finds again
Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds...
2006-12-09
1,375 reads
SysInternals Tools Updated
Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass...
2006-12-09
1,432 reads
Windows 2000 Resource Kit Tools Available
If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively...
2006-12-09
1,858 reads
Log Buffer #22: A Carnival of the Vanities for DBAs
Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...
2006-12-08
1,590 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