Security Panics
I went to host the Red Gate SQL Source Control webinar recently and had a snag. I downloaded the GoToWebinar...
2010-08-23
846 reads
Blog Posts
SQL Saturday #28 - Lessons Learned
After spending a week in Tampa, FL at a client site I've had some time to unwind and reflect back...
2010-08-23
957 reads
SQL Server Trivia
Think you know SQL Server past and present? Here are the next-to-impossible questions I asked at the SQLSaturday #51 Stump...
2010-08-23
671 reads
SSIS: Conditional File Processing in a ForEach Loop
I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...
2010-08-23
23,005 reads
SQL Saturday 51 Presentation - Fortress SQL Server
Thanks to everyone who attended my presentation at SQL Saturday #51 - Nashville. I apologize for going long and not getting...
2010-08-22
773 reads
The application platform for the “Unlimited information” era
“The information age is an idea that the current era will be characterized by the ability of individuals to transfer information freely, and to have instant access to knowledge...
2010-08-22
9 reads
The application platform for the “Unlimited information” era
“The information age is an idea that the current era will be characterized by the ability of...
2010-08-22
4 reads
SQL Saturday 28 Baton Rouge - Recap
Last weekend I went to Baton Rouge (by way of New Orleans) to attend and speak at the second annual...
2010-08-21
1,076 reads
DBA Tracy Hamlin Wins the 2010 Exceptional DBA of the Year Award
Tracy Hamlin (Twitter) has been voted as the 2010 Exceptional DBA of the Year by the SQL Server community. The...
2010-08-20
1,051 reads
Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic (Blog|Twitter) recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Why...
2010-08-20
530 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