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 Podcasts

by Arun Sirpal

All About SQL

Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...

2016-03-23

387 reads

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

182 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,175 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

170 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

Can I Change a Primary Key Value? #SQLNewBlogger

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Secure Azure SQL Server Backups Using Managed Identities

I do believe most people know about the ability to backup your SQL server...

Read the latest Blogs

Forums

Just a rant about the SQL Server 2022 upgrade

Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...

Report Server Configuration Manager - The target principal name is incorrect SSL

SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...

Report Server Configuration Manager - Change Database - SSL Error

I'm getting an ' SSL Provider, error: 0 - The target principal name is...

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096

But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers