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.

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

530 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,607 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

701 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,367 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,004 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

758 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,312 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,243 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)

930 reads

Azure Automation and SQL Index Maintenance

by Arun Sirpal

All About SQL

Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...

2017-08-21

970 reads

Blogs

Getting the SQL Server MCP Server Running

If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By MarlonRibunal

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Rambling about Data on Wheels – origins, branding, expansion

By DataOnWheels

I have been asked many times about how the name “Data on Wheels” came...

Read the latest Blogs

Forums

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

DBCC CHECKDB Limits III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKDB Limits III

CROSS APPLY Fundamentals: Part 1

Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1

Visit the forum

Question of the Day

DBCC CHECKDB Limits III

On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?

See possible answers