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

Clearing Plan Cache in SQL Database (Azure)

by Arun Sirpal

All About SQL

Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot...

2017-01-05

685 reads

Checking DBCC CHECKDB

by Arun Sirpal

All About SQL

I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to....

2017-01-03

580 reads

TDE Recovery

by Arun Sirpal

All About SQL

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...

2016-12-26 (first published: 2016-12-07)

1,500 reads

Why I am called BlobEater

by Arun Sirpal

All About SQL

It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...

2016-12-17

520 reads

Locking Resources in Azure

by Arun Sirpal

All About SQL

I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...

2016-12-16

520 reads

CHECKDB and Page Restoring from SSMS

by Arun Sirpal

All About SQL

Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management...

2016-12-15

468 reads

Don’t blink you might READPAST it

by Arun Sirpal

All About SQL

Following on from my previous post on NOLOCK (https://blobeater.blog/2016/12/09/nolock/) I want to talk about another hint called READPAST. This hint tells...

2016-12-13

451 reads