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.

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)

849 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

Folks Who Have Made a Difference

by Arun Sirpal

All About SQL

TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...

2017-11-14

308 reads

SQL Server Phantom Reads

by Arun Sirpal

All About SQL

With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...

2017-11-08 (first published: 2017-10-26)

1,615 reads

Azure SQL Database Compatibility Levels

by Arun Sirpal

All About SQL

Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...

2017-11-06

521 reads

Microsoft MVP!?

by Arun Sirpal

All About SQL

What? Is probably the most common reply out there and if it is then that is how I felt when...

2017-11-02

406 reads

Query Store – SQL Server 2017 vs Azure SQL Database

by Arun Sirpal

All About SQL

I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...

2017-11-02 (first published: 2017-10-24)

2,056 reads

Azure SQL Database Automatic Tuning – Questions Answered

by Arun Sirpal

All About SQL

I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...

2017-11-01

377 reads

SQL Server: What will REPAIR do?

by Arun Sirpal

All About SQL

So I had a corruption issue and I was thinking about running repair but I wanted to know what would...

2017-10-24 (first published: 2017-10-16)

2,074 reads

Azure SQL Database Level Firewall Rules

by Arun Sirpal

All About SQL

I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...

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

1,705 reads

Blogs

Upgrading SQL Server Containers on the Laptop

I don’t have SQL Server installed on my laptop. In an effort to keep...

How to Find Expensive Queries in Amazon Redshift

By Eduardo Pivaral

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

If you've been here before, you know this blog is usually about SQL Server,...

Read the latest Blogs

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

Hi all Can I get some perspective from the community please on performing in-place...

How Long is a Long I/O?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Long is a Long...

T-SQL Trigonometric Functions in SQL Server

Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...

Visit the forum

Question of the Day

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

See possible answers