Precons in Richmond, Philadelphia and New York
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...
2018-03-09 (first published: 2018-02-28)
1,666 reads
The Scary DBA
Adaptive Joins
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...
2018-02-27
1,140 reads
GDPR: Your Hair Is Not On Fire
Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...
2018-02-26
478 reads
Wait Statistics on a Query
Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...
2018-02-14 (first published: 2018-02-05)
2,713 reads
Youtube Channel Update
Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...
2018-01-29
288 reads
You Need a New Hobby
Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...
2018-01-23
301 reads
Database Fundamentals #16: Removing Data With T-SQL
Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.
How it Works
In the same way...
2018-01-31 (first published: 2018-01-22)
2,240 reads
Updated YouTube Channel
Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...
2018-01-16
322 reads
Getting Started in a SQL Server 2017 VM in Azure
You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
Oh, you want...
2018-01-26 (first published: 2018-01-15)
1,212 reads
Statistics Use, Extended Events and Execution Plans
Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...
2018-01-17 (first published: 2018-01-08)
2,245 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
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