POTW Webcast with Kevin Kline
Today I'll be tagging along with Kevin Kline for the Quest Pain of the Week webcast. We'll be talking about...
2010-02-11
943 reads
Blog Posts
SQL Server Trace Events
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,951 reads
A Tale Of Two Execution (Updated)
Update: Scroll to the bottom for more information added after originally posting.
Earlier this week a coworker asked me for help...
2010-02-10
708 reads
February OPASS Meeting Recap
Introduction
Last night we had our February OPASS meeting with Ron Dameron (@RonDBA) presenting on Database Hardening using PowerShell. We broadcast...
2010-02-10
406 reads
Negotiating Salary for a New Job
Slightly off topic, but I’m adding this one to the Modern Resume blog since I think it’s something to be...
2010-02-10
484 reads
Notes from the February 2010 oPASS Meeting
Really rainy in Orlando today, traffic is horrible. We had a higher than usual number of RSVP’s for the meeting,...
2010-02-10
476 reads
SQLSaturday #43 Announced!
Greg Larsen is hosting SQLSaturday in Redmond, WA again this year, this time on June 12, 2009. Call for speakers...
2010-02-10
588 reads
T-SQL Tuesday #3: Database Relationships
In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with...
2010-02-10
453 reads
Data Types Matter
I was watching Michelle Ufford’s (blog, Twitter) presentation from the 2009 PASS Summit recently on DVD. I had purchased them,...
2010-02-09
967 reads
February OPASS Meeting Tonight
It's here! Our February meeting is tonight at 6pm at End To End Training, 225 S. Westmonte Drive, Suite 2010,...
2010-02-09
377 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