SQL RNNR

Blog Post

SQL Server Select – Back to Basics

Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
Related Posts:

Changing Default Logs Directory - Back to Basics...

2016-04-02

7 reads

Blog Post

SQL Agent Job Schedules

Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You...

2016-04-12 (first published: )

2,607 reads

Blog Post

SQL Agent Job Schedules

SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from...

2016-03-29

6 reads

Blog Post

The Virginia Tour 2016

Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:

An Experiment with Deadlocks...

2016-03-11

1 reads

Blogs

Presenting with Visual Studio Code

By

A while back I wrote a quick post on setting up key mappings in...

Advice I Like: In 100 Years

By

In 100 years a lot of what we take to be true now will...

Read the latest Blogs

Forums

connections vs apis

By stan

hi , i hear more and more that we have too many connections to...

is it true we cant debug c# scripts in ssis anymore under vs

By stan

Hi, i'm running vs2022.   I'm trying out a c# script that i'd like to...

Missing the Jaro Winkler Distance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Missing the Jaro Winkler Distance

Visit the forum

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