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.

All authors

SQL database built-in intelligence

by Arun Sirpal

All About SQL

I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in...

2017-01-18

513 reads

Looking at wait stats differently with SQL 2016

by Arun Sirpal

All About SQL

Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on sys.dm_os_wait_stats...

2017-01-16

640 reads

Checking Time Zones in SQL Server

by Arun Sirpal

All About SQL

I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...

2017-01-13

1,340 reads

I used to shrink my databases!

by Arun Sirpal

All About SQL

This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...

2017-01-11

831 reads

SQL Server Bugs & Enhancement Requests

by Arun Sirpal

All About SQL

T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...

2017-01-10

642 reads