Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
683 reads
SQL Awesomesauce
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
489 reads
T-8d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelveeight days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-17
587 reads
Know a young IT go-getter? Get her nominated!
Yesterday, I told our Groupies: I feel give-y today. Is there anything you’d like me to promote for you? Wendy...
2010-09-15
475 reads
New Hotness: sys.sql_modules
I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or...
2010-09-15
519 reads
Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!
Content rating: Beginner
This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for...
2010-09-14
677 reads
Tip: Use System Views to Compare Column Datatypes
Let’s say that you have a staging table, that then loads to a destination table in the same database. If...
2010-09-13
542 reads
T-12d till SQL Saturday #52 (CO)
SQL Saturday: All the COOL kids are doing it!
It’s only twelve days until SQL Saturday #52 in Colorado! I’ll be...
2010-09-13
710 reads
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,731 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,560 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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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
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