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.

Saving Costs in Azure

by Arun Sirpal

All About SQL

Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...

2018-02-27 (first published: 2018-02-15)

1,787 reads

How to setup Azure SQL Analytics

by Arun Sirpal

All About SQL

I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...

2018-02-26

1,049 reads

Azure SQL Database sa Connections?

by Arun Sirpal

All About SQL

I was using a query on one of my local SQL Servers where I wanted to know what logins were...

2018-02-07

1,087 reads

Deleting Azure SQL Database VNETs

by Arun Sirpal

All About SQL

This is quite a new feature (currently in preview) but an important one where we now have the ability to...

2018-02-07 (first published: 2018-01-29)

1,032 reads

The world of Automatic Tuning – SQL Server 2017

by Arun Sirpal

All About SQL

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...

2018-01-31 (first published: 2018-01-22)

2,415 reads

Azure Portal – Bad Request

by Arun Sirpal

All About SQL

I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...

2018-01-16

269 reads

Azure SQL Database – Optimizing For Ad-hoc Workloads

by Arun Sirpal

All About SQL

Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...

2018-01-16 (first published: 2018-01-08)

1,603 reads

T-SQL Tuesday #98 Round Up

by Arun Sirpal

All About SQL

Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...

2018-01-11

583 reads

Azure SQL Analytics

by Arun Sirpal

All About SQL

Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to...

2018-01-04

995 reads

T-SQL Tuesday #98 – Your Technical Challenges Conquered

by Arun Sirpal

All About SQL

Welcome to the January 2018 edition of T-SQL Tuesday and I am your host BlobEater (Arun Sirpal).
If you do not...

2018-01-02

630 reads

Blogs

A New Word: on tenderhooks

on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...

Ramblings about data communities and your contributions, no excuses

By DataOnWheels

I have been active in the data community throughout my career. I have met...

SQL Server Journey till 2025 (brief)

By Vinay Thakur

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Read the latest Blogs

Forums

how do i map the "current" object entry in for each to one variable

hi, in an ssis for each loop over an object variable called MyListVariable, i...

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

SQL Server is typically viewed as a transactional or analytical database engine. However, it...

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...

Visit the forum

Question of the Day

String Similarity I

On SQL Server 2025, when I run this, what is returned?

SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL')

See possible answers