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.

Blog Post

MVPs

I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...

2017-01-20

658 reads

Blog Post

I used to shrink my databases!

This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...

2017-01-11

811 reads

Blog Post

TDE Recovery

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...

2016-12-26 (first published: )

1,496 reads

Blogs

Can I Change a Primary Key Value? #SQLNewBlogger

By

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

SQL Server Index Primer

By

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

Secure Azure SQL Server Backups Using Managed Identities

By

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

By cphite

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

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

By JDRocket

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

Report Server Configuration Manager - Change Database - SSL Error

By JDRocket

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