Practical Web Scraping–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-02-15
1,370 reads
Blog Posts
Speaker at SQL Saturday’s Guatemala city 2019
I’m very happy to announce that for the second year in a row I will be participating as speaker in...
2019-02-15
183 reads
Speaking at SQL Saturday Chicago
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
7 reads
Speaking at SQL Saturday Chicago
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on...
2019-02-15
100 reads
Cool Stuff in Snowflake – Part 6: Query History
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2019-02-14
52 reads
Information Measurement with SQL Server, Part 5.1: A Digression on the Unsuitability of Fisher Information for SQL Use Cases
By Steve Bolton
…………One of the major thrusts of my various mistutorial series has been to drive home the point that...
2019-02-14 (first published: 2019-01-25)
2,259 reads
It’s always parameter sniffing (Part 2): SET options
This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...
2019-02-14 (first published: 2019-01-23)
2,513 reads
Learn about the State of Database DevOps Next Week
It’s a week to my webinar with Donovan Brown (bt, yg), leader of the League of Extraordinary Cloud DevOps Advocates,...
2019-02-14
227 reads
Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
123 reads
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
187 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...
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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