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

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

488 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

468 reads

I use Elastic database pools – for now

by Arun Sirpal

All About SQL

When you have many SQL databases that are required to run your environments and they show signs of specific usage...

2016-12-12 (first published: 2016-12-02)

1,450 reads

NOLOCK

by Arun Sirpal

All About SQL

NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...

2016-12-09

2,341 reads

SQL Server Performance Dashboard Reports

by Arun Sirpal

SQLServerCentral.com

SQL Server

Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).