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

Blog Post

DBCC HELP

I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new!...

2016-09-09

542 reads

All authors

Blogs

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

A Note and a Message: T-SQL Tuesday #193

By

This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...

More fun with Git: git restore

By

The setup My day job involves babysitting a lot of Git repositories hosted on...

Read the latest Blogs

Forums

This doesn't make sense to me - making me crazy - er

By krypto69

Hi So I have the below select query that won't return results if I...

Catalog max connection pool size: 100

By Pete Bishop

Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...

CAST datetimeoffset(7) as a datetime in UK format

By tylerschuler75

I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return? 

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers