Participation
With a large election year in the US (President + all the other races), I've been more interested than in some...
2008-11-04
392 reads
Blog Posts
PASS Board of Directors, Part 2
A couple weeks ago I wrote about trying to decide whether to run for the PASS board. I talked about...
2008-11-04
534 reads
Election Day & Love of Country
I'm not trying to talk politics here, but I don't want to be so politically correct that I avoid important...
2008-11-03
451 reads
Microsoft Launches SQLServerEnergy.Com
Microsoft has launched a new SQL Server 2008 marketing-related website at www.sqlserverenergy.com. It is available in 11 languages, and offers...
2008-11-03
848 reads
Midlands PASS Chapter Meeting - November 6, 2008
Speaker: Brian Kelley
Midlands PASS Chapter - November 6, 2008 Meeting
Sponsored by Red Gate Software
The Midlands PASS chapter will hold our normally...
2008-11-03
515 reads
Professional Microsoft SQL Server 2008 Administration
When I came home from work tonight, there waiting on my was my copy of Professional Microsoft SQL Server 2008...
2008-11-03
1,162 reads
Sniffing out bogus data
/* Imagine that you have some names and addresses. You are anxious to look at the addresses that may be spurious....
2008-11-03
673 reads
The Wise Old Man Part 3
In my previous posts The Wise Old Man Part 1 and The Wise Old Man Part 2 I wrote about...
2008-11-03
712 reads
DBA and Doctor
I always feel it is harder to be a DBA than to be a doctor while we are doing almost...
2008-11-02
1,315 reads
How Many People Can a Manager Manage?
This question came up during lunch this past week, and it's a good question. I'll start with my stock 'It...
2008-11-02
554 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