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

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

519 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

519 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