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

The Good The Bad and The SLA

by Arun Sirpal

All About SQL

Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA...

2018-08-20

257 reads

SQL Reserved vCores

by Arun Sirpal

All About SQL

Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...

2018-08-16

342 reads

Azure SQL DW – Query Labels

by Arun Sirpal

All About SQL

Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via...

2018-08-14

362 reads

Azure SQL Data Warehouse and Backups

by Arun Sirpal

All About SQL

Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...

2018-08-07

414 reads

SQL Server – Blocking a Truncate

by Arun Sirpal

All About SQL

The truncate option is fast and efficient but did you know that it takes a certain lock where you could...

2018-07-31

550 reads

PsPing your Azure SQL Server

by Arun Sirpal

All About SQL

PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...

2018-07-23

656 reads