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.

A Basic Bot using Azure Bot Services

by Arun Sirpal

All About SQL

I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....

2017-12-19

576 reads

Moving to an Azure SQL Database via Command Line

by Arun Sirpal

All About SQL

I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...

2017-12-19 (first published: 2017-12-07)

1,553 reads

SQL Server DBCC CHECKDB – Going Parallel

by Arun Sirpal

All About SQL

DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...

2017-12-18

317 reads

Azure SQL Database – Using sp_BlitzIndex

by Arun Sirpal

All About SQL

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...

2017-12-14 (first published: 2017-12-05)

1,692 reads

SQL Server Failed to Open Loopback Connection – What?

by Arun Sirpal

All About SQL

I could not read my error log on one of my local SQL Servers, when I executed the following code:

EXEC...

2017-12-12

816 reads

I have a new Passion

by Arun Sirpal

All About SQL

Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...

2017-11-28

357 reads

Azure SQL Database – Service Tiers

by Arun Sirpal

All About SQL

Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...

2017-11-23

488 reads

SQL Server – DBCC CHECKTABLE

by Arun Sirpal

All About SQL

If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...

2017-11-20

449 reads

SQL Server 2017 – Interleaved Execution

by Arun Sirpal

All About SQL

I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...

2017-11-20 (first published: 2017-11-09)

848 reads

Azure SQL Database Alerting

by Arun Sirpal

All About SQL

It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...

2017-11-16

504 reads

Blogs

A bespoke reporting solution doesn’t have to cost the earth

By ChrisJenkins

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

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...

Read the latest Blogs

Forums

AllocationType as ROW_OVERFLOW_DATA

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

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...

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