Where are Profiler User Defined Templates Stored?
Someone asked me this recently and I really had no idea. Quick look in BOL didn't yield any results, so...
2008-04-21
1,819 reads
Blog Posts
More MVP Summit
As I thought might happen, I was too busy after Tuesday and Wednesday to report in. Tuesday was my first trip...
2008-04-17
433 reads
Professional Development Links
Someone asked me for these recently as they predate the blog. All were posted on SSC over the past couple...
2008-04-17
623 reads
Thoughts on Mentoring - Part 5
As a mentor I'm looking for someone with the drive to learn and grow, and willing to acknowledge that they...
2008-04-17
533 reads
MVP Day 2
Yesterday was an interesting day up at Microsoft. The SQL Server track is split into two sessions, with 2 assigned...
2008-04-16
684 reads
Service Pack 3 and Servicing
It was announced yesterday that Service Pack 3 for SQL Server 2005 is coming! I've been trying to get people...
2008-04-16
753 reads
Thoughts on Mentoring - Part 4
One of the dangers of mentoring someone on your team is that you can easily be perceived as biased, and...
2008-04-16
464 reads
MVP Monday
I'm sure that Monday was the most relaxed day that we will have this week. The conference did not start until...
2008-04-15
596 reads
Thoughts on Mentoring - Part 3
I think sometimes a lot of what we call mentoring might be appropriately called coaching. Before you go trying to...
2008-04-15
479 reads
Fast
I am actually stunned. I knew that more bandwidth makes a difference, but having way more bandwidth is truly amazing.
My...
2008-04-14
746 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