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 – max server memory

by Arun Sirpal

All About SQL

Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...

2019-03-14

488 reads

SQL Server Deadlocks

by Arun Sirpal

All About SQL

A quick video clip showing how to create a deadlock in SQL Server and find information about it.

2019-03-13

1,119 reads

T-SQL Tuesday Sharing Cookies

by Arun Sirpal

All About SQL

It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do...

2019-03-12

431 reads

Azure SQL Data Warehouse Query Store

by Arun Sirpal

All About SQL

I personally think that query store has been a fantastic feature. I find myself using it for query performance troubleshooting...

2019-03-05

622 reads

Azure SQL Database and Trace Flags

by Arun Sirpal

All About SQL

You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...

2019-02-26

602 reads

Azure SQL Database Online Columnstore Unicorn and Rainbow Theory

by Arun Sirpal

All About SQL

As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...

2019-02-21

183 reads

Azure SQL Database and Transaction Log

by Arun Sirpal

All About SQL

Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...

2019-02-13

187 reads

Automating T-SQL for Azure SQL Database via Logic Apps

by Arun Sirpal

All About SQL

Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?...

2019-02-06

224 reads

SQL Server Looking into Differential Backups

by Arun Sirpal

All About SQL

I seem to be writing solely about Azure so to shake things up a bit I am going back to...

2019-02-05

184 reads

Classify your Azure SQL Database

by Arun Sirpal

All About SQL

Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...

2019-02-04

191 reads

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

March 2026 SQL Server Security Updates

By Brian Kelley

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

How Fabric Mirroring Transformed with SQL Server 2025

By Meagan Longoria

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

Read the latest Blogs

Forums

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

Upgrading Admin Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrading Admin Queries

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers