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.

I Escaped from a SQL Server Service Pack Nightmare

by Arun Sirpal

All About SQL

I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...

2017-04-24

351 reads

Getting intimate with Brent Ozar (The First Responder Kit)

by Arun Sirpal

All About SQL

Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...

2017-04-12

500 reads

Microsoft Data Platform is changing – so am I

by Arun Sirpal

All About SQL

This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever...

2017-04-11

312 reads

Azure: SQL Database Elastic Pool and using Elastic Jobs

by Arun Sirpal

All About SQL

I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...

2017-04-04

575 reads

SQL Server DBCC CHECKDB

by Arun Sirpal

All About SQL

A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...

2017-04-01

363 reads

Azure – SQL Database Premium RS

by Arun Sirpal

All About SQL

A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...

2017-03-28

983 reads

SQLBits 2017

by Arun Sirpal

All About SQL

I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...

2017-03-27

301 reads

Why did my SQL Server database just go offline?

by Arun Sirpal

All About SQL

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...

2017-03-24

378 reads

My path from a junior to a senior DBA

by Arun Sirpal

All About SQL

A non-technical post but something I have been asked about few times so I thought that I would put pen...

2017-03-22

432 reads

TDE: Looking inside your database and backups

by Arun Sirpal

All About SQL

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...

2017-03-20

315 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