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

Deleting Azure SQL DB

by Arun Sirpal

All About SQL

So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...

2018-08-28

230 reads

My Azure SQL Database Elastic Job is Broken!

by Arun Sirpal

All About SQL

I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...

2018-08-23

331 reads

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

343 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

363 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

553 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