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.

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

306 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,608 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

515 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

402 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,051 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

373 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,071 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,697 reads

Connecting to Azure SQL Database Primary Endpoint – Failover Groups

by Arun Sirpal

All About SQL

When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...

2017-10-19

682 reads

SQL Server 2017 Encrypted Backups And Compression

by Arun Sirpal

All About SQL

Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...

2017-10-18 (first published: 2017-10-09)

3,084 reads

Blogs

Query Intelligence in SQL Server 2025: What Developers Need to Know

When Microsoft announced SQL Server 2025, I was curious about what would truly change...

Finding and Killing Blockers with Redgate AI Tech

Redgate has a research arm, called the Foundry, that has been experimenting with AIs...

Back at Small Data SF in 2025

Today I’m in San Francisco at Small Data SF 2025. I went to the...

Read the latest Blogs

Forums

Poor Name Choice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Poor Name Choice

Getting the Indexed Columns

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Indexed Columns

T-SQL in SQL Server 2025: Substring Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Getting the Indexed Columns

I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?

SELECT   
    INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail')

See possible answers