Arun Sirpal

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

Azure Robots – Index Performance Recommendation

by Arun Sirpal

All About SQL

They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made....

2017-06-01

438 reads

Find when your SQL Server database grew

by Arun Sirpal

All About SQL

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...

2017-05-25

325 reads

AD Authentication and Azure SQL Database

by Arun Sirpal

All About SQL

Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...

2017-05-22

410 reads

Setting SQL Server Max Memory Dangerously Low

by Arun Sirpal

All About SQL

Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By...

2017-05-18

418 reads

Creating Azure Database for MySQL and using Azure Cloud Shell

by Arun Sirpal

All About SQL

After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...

2017-05-15

388 reads

SQL Server Wait Types Library – UPGRADED!

by Arun Sirpal

All About SQL

Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...

2017-05-11

363 reads

Extended Events – I am dangerous (sometimes)

by Arun Sirpal

All About SQL

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was...

2017-05-09

347 reads

SQL Server Recovering Data via a Hex Editor

by Arun Sirpal

All About SQL

I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...

2017-05-08

407 reads

Comparing Plans via Query Store

by Arun Sirpal

All About SQL

A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...

2017-05-04

314 reads

Adaptive Query Processing – Interleaved Execution

by Arun Sirpal

All About SQL

A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...

2017-05-02

478 reads

Blogs

Presenting with Visual Studio Code

By Andrew Pruski

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

Advice I Like: In 100 Years

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

dataMinds Saturday 2026 – Slides

By Koen Verbeeck

At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...

Read the latest Blogs

Forums

connections vs apis

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

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

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Missing the Jaro Winkler Distance

Visit the forum

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