Migrating SQL Server logins
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...
2014-05-15 (first published: 2014-05-07)
8,511 reads
Blog Posts
Missing Indexes Script v2
As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a...
2014-05-15
7 reads
PASS SQLSaturday Events: June 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-05-15
684 reads
Password Cracking–Part 1
I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...
2014-05-15
1,014 reads
Peace Officers Memorial Day and Half Staff
Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...
2014-05-15
312 reads
Powershell Tips–PSEdit
I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked...
2014-05-15
1,431 reads
Teamwork Keeps The Ship Afloat
I’m back from my
on the
with a big on
my face.
Like a good
I took lots (over 1400) pictures of
and
and
I also swam with...
2014-05-15
791 reads
2014-05-14
764 reads
Building the SQLSaturday Orlando Marketing Plan-Part 7
Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...
2014-05-14
532 reads
Drop Me? No, I Don’t Think So–Question of the Day
Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping...
2014-05-14
400 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