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.

SQL Server articles

by Arun Sirpal

All About SQL

Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...

2016-03-16

181 reads

Creating SQL databases on Azure Blob storage

by Arun Sirpal

SQLServerCentral.com

SQL Server 2014

Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.71 (7)

Log in or register to rate

You rated this post out of 5. Change rating

2015-09-17

4,166 reads

Discuss

An Extended Event script

by Arun Sirpal

All About SQL

I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...

2015-05-22

144 reads

Carving up CHECKDB

by Arun Sirpal

All About SQL

This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...

2015-05-16

168 reads

Welcome to BlobEater

by Arun Sirpal

All About SQL

I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...

2015-03-25

302 reads

A Handy function

by Arun Sirpal

All About SQL

If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...

2015-03-03

166 reads

Timed SQL Server tracing

by Arun Sirpal

All About SQL

Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...

2015-02-07

241 reads

Protected: Has it come true?

by Arun Sirpal

All About SQL

There is no excerpt because this is a protected post.

2015-02-06

191 reads

Blogs

Sic Transit Gloria Community

By Grant Fritchey

When Covid took out the PASS organization, I had someone say to me, “Well,...

DATEADD Truncates the Number Parameter: #SQLNewBlogger

This was an interesting thing I saw in a Question of the Day submission....

Our SQL Server is Slow! What Do I Do First?

Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

ExecutionLog3 table in Reportserver Database

I have a SSRS report for which users are complaining to be slow, but...

SQL Server Maintenance Plan Feedback

Hi I set this up today. I wanted to get some feedback. I have...

Visit the forum

Question of the Day

Counting Bits IV

What do these two selects return?

SELECT BIT_COUNT (CAST (-1 as smallint))
     , BIT_COUNT (CAST (-1 as bigint))

See possible answers