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.

AD Authentication and Azure SQL Database

by Arun Sirpal

All About SQL

Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...

2017-05-22

408 reads

Setting SQL Server Max Memory Dangerously Low

by Arun Sirpal

All About SQL

Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By...

2017-05-18

411 reads

Creating Azure Database for MySQL and using Azure Cloud Shell

by Arun Sirpal

All About SQL

After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...

2017-05-15

384 reads

SQL Server Wait Types Library – UPGRADED!

by Arun Sirpal

All About SQL

Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...

2017-05-11

357 reads

Extended Events – I am dangerous (sometimes)

by Arun Sirpal

All About SQL

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was...

2017-05-09

340 reads

SQL Server Recovering Data via a Hex Editor

by Arun Sirpal

All About SQL

I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...

2017-05-08

395 reads

Comparing Plans via Query Store

by Arun Sirpal

All About SQL

A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...

2017-05-04

310 reads

Adaptive Query Processing – Interleaved Execution

by Arun Sirpal

All About SQL

A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...

2017-05-02

474 reads

SQLBits Review

by Arun Sirpal

All About SQL

I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...

2017-04-26

490 reads

Redgate: SQL Search

by Arun Sirpal

All About SQL

I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...

2017-04-25

441 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