SQL Server MVP Andy Leonard on .NET Rocks!
SQL Server MVP Andy Leonard is on the latest edition of .NET Rocks! If you're not familiar with .NET Rocks!,...
2008-02-01
748 reads
Blog Posts
The Importance of Verifying Database Backups Regularly
Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and...
2008-01-31
1,664 reads
A Long Overdue Database Security Rant
I've been dealing with a security product from a security company in recent days that breaks best practices with respect...
2008-01-30
2,302 reads
First Heroes Happen Here (HHH) Comic
Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...
2008-01-29
1,561 reads
Hello Secure World - MS Site Worth Looking At
Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses...
2008-01-29
1,395 reads
IT Transparency Posted on SSC
As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to...
2008-01-29
1,304 reads
Ken Henderson has passed away
I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...
2008-01-29
1,909 reads
Part II of Troubleshooting Memory Issues
The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...
2008-01-29
1,669 reads
The Long Tail
Another book I read recently, The Long Tail by Chris Anderson of Wired Magazine goes into detail talking about some of the changes...
2008-01-29
1,482 reads
Thoughts and Prayers
Ken Henderson passed away this past week. I found out about it from the MVP forums as well as from...
2008-01-29
1,449 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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...
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