Certification
There seems to be quite a flurry of talk these days about certification. There is evidence of it in the...
2010-03-26
1,266 reads
Jason Brimhall
Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,780 reads
Another Presentation Down
This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV). I...
2010-03-12
623 reads
Log Growing Pains
Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.
2010-03-11
18,869 reads
Log Growing Pains Article
I Just had an article published at SQLServercentral on troubleshooting the cause of log growths. At the conclusion of that...
2010-03-11
475 reads
IO IO IO
Once again it is that time. It is TSQL Tuesday. This time it is being hosted by Mike Walsh. Mike...
2010-03-09
1,358 reads
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
866 reads
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral...
2010-03-05
757 reads
DBA MD
I just had the opportunity to spend some time with my four year old son at the doctor’s office. It...
2010-02-25
604 reads
Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some...
2010-02-23
788 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