Where’s StrateSQL?
Earlier this year, I had started off with a bang. I think I had 51 posts in January with a...
2011-05-25
558 reads
Blog Posts
Data Mining in Excel Presentation
Wednesday I will be presenting for the PASS BI/DW group a session on Data Mining in Excel. This is a...
2011-05-24
1,194 reads
Double digits in posts!
Thank you to everyone reading this site - Please enjoy your stay!
HelpWithSQL has hit double digits in posts! I hope everyone...
2011-05-24
616 reads
EVENT: NYC SQL Server User Group Presents SSRS with Edwin Sarmiento.
Another great event coming to NYC this Thursday, May 26, 2011 @ 6PM! The NYC SQL Server User Group presents a...
2011-05-24
1,232 reads
Fun with Light Bulbs
I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr...
2011-05-24
923 reads
My advanced SQL Server Performance Troubleshooting workshop goes to the international level!
I’m working my whole professional work life (around 11 years) with SQL Server, and
have see so many pitfalls in configuration...
2011-05-24
1,625 reads
Pray For Me…I’m Writing the Bible!
Prayer Cat Prays
Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll...
2011-05-24
553 reads
SQL University Troubleshooting Week: Communication
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,434 reads
Your DBA Role is Changing. Are you Ready?
Where do you see yourself in the future? Are you working at the same company, are you working in a...
2011-05-24
1,095 reads
Collation Conflicts in a SQL Server Join
I went to run this query recently:
select TOP 10 *
from users a
inner join Banned b
on a.username = b.usernameand...
2011-05-23
4,363 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