I had a request regarding how to identify unused indexes across all databases on a SQL Server instance (rather than just the current one). I’ve written this script before...
2023-01-16 (first published: 2023-01-05)
908 reads
Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....
2023-01-16
13 reads
In my experiments with the Flyway CLI (fwcli), I’m finding some interesting behavior, some of which is catching my by surprise. This post looks at the baseline command and...
2023-01-16
27 reads
Today’s coping tip is to take five minutes to sit still and breathe. Sounds simple. I find this to be very challenging. If I’m just sitting here, why am...
2023-01-13
17 reads
As we’ve seen in previous posts, the process of turning TDE on for an empty database with no data is instantaneous. Most of the time though you’ll be applying...
2023-01-13
81 reads
When we consider how secure a form of encryption is there are two things we want to consider. Let’s discuss each of these in turn. What are We Protected...
2023-01-13 (first published: 2023-01-03)
386 reads
One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway...
2023-01-13 (first published: 2023-01-04)
192 reads
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode! At the...
2023-01-12
49 reads
Today’s coping tip is to write a list of things you feel grateful for and why. My wife – our relationship continues to grow, and I cherish this after...
2023-01-12
14 reads
Today’s coping tip is to do a kind act for someone else today to brighten their day This is one I’ve done before, but this tip reminded me to...
2023-01-11
9 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item 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