Mat has been a Dba since 2007 working in the finance and ecommerce industries in South Wales, UK.

Identity Crisis

I’m sure most people have identity values lurking somewhere in their databases. In fact I would guess that most people...

2012-05-02 (first published: 2012-04-25)

2,469 reads

The first blog post….

Daunting! By way of introduction, I’m Mat This blog is mostly for myself, to document what I know and maybe...

2012-04-03

602 reads

You could be tolerating limited reporting because there isn’t an off the shelf solution...

A while back I wrote a quick post on setting up key mappings in...

In 100 years a lot of what we take to be true now will...

Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...

hi , i hear more and more that we have too many connections to...

Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...

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?