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,606 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

513 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,695 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,077 reads

Blogs

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

By Klaus Aschenbrenner

Do you know if your SQL Server is really running at its best? To...

Retro Data 2025 – Slidedeck

By Koen Verbeeck

You can find the slides of my session on the €100 DWH in Azure...

The Book of Redgate: We Value Teams

This value is something that I still hear today: our best work is done...

Read the latest Blogs

Forums

Single User SQL Server on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Single User SQL Server on...

All the Costs of Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item All the Costs of Downtime

How Well Does the MSSQL Extension in VSCode Work?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Well Does the MSSQL...

Visit the forum

Question of the Day

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

See possible answers