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.

SSMS 17 Dark Theme

by Arun Sirpal

All About SQL

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...

2017-09-29

2,715 reads

Azure SQL Database Active Geo Replication Changes

by Arun Sirpal

All About SQL

Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...

2017-09-25

534 reads

SQL Server Tracking Suspect Pages

by Arun Sirpal

All About SQL

Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...

2017-09-25 (first published: 2017-09-19)

1,609 reads

SQL Server Schema Compare

by Arun Sirpal

All About SQL

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...

2017-09-18

735 reads

Azure SQL Database Resumable Online Index Rebuild

by Arun Sirpal

All About SQL

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...

2017-09-14

1,370 reads

[Video] SQL Server Deadlocks

by Arun Sirpal

All About SQL

SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...

2017-09-08 (first published: 2017-08-24)

2,008 reads

DBCC CHECKDB Azure SQL Database

by Arun Sirpal

All About SQL

Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...

2017-09-04

761 reads

Azure SQL Database – Scaling up

by Arun Sirpal

All About SQL

Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...

2017-09-01 (first published: 2017-08-23)

1,313 reads

SSMS and MFA support for Azure SQL DB

by Arun Sirpal

All About SQL

Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...

2017-08-30

2,253 reads

Azure Cloud “Fear” Busting #4 – Losing Control?

by Arun Sirpal

All About SQL

So the decision to move to the cloud has been made but there is a fear from people that once...

2017-08-25 (first published: 2017-08-14)

932 reads

Blogs

Monday Monitor Tips: Configuring Access to the MCP Server

I have been experimenting with MCP servers in a few ways, including the Redgate...

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

By Meagan Longoria

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

Read the latest Blogs

Forums

A Challenge of Our Knowledge

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Challenge of Our Knowledge

The memory toll of VARCHAR(MAX) in SQL Server

Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...

Transaction Log Truncation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Transaction Log Truncation

Visit the forum

Question of the Day

Transaction Log Truncation

In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?

See possible answers