Is your Team Willing to Take Control?
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community,...
2014-07-08
562 reads
Jason Brimhall
Free SQL Training In Sacramento
In a few short days the newest SQL Saturday event. This one will be on the far West coast of...
2014-07-07
472 reads
Free SQL Training In Sacramento
In a few short days the newest SQL Saturday event. This one will be on the far West coast of the United States. This marks the first time for...
2014-07-07
5 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for...
2014-07-03
2 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality...
2014-07-03
1,724 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some...
2014-06-02 (first published: 2014-05-28)
1,938 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too...
2014-05-29 (first published: 2014-05-23)
3,785 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
5 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too would wonder the same thing. That withstanding, it is...
2014-05-23
4 reads
Missing Indexes Script v2
Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them...
2014-05-22 (first published: 2014-05-15)
4,225 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