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.

Extreme situations require extreme commands

by Arun Sirpal

All About SQL

The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...

2017-03-14

369 reads

My take on presenting

by Arun Sirpal

All About SQL

This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have...

2017-03-10

377 reads

Copying your SQL Database

by Arun Sirpal

All About SQL

If you ever need to move a copy of a SQL database in Azure across servers then here is a...

2017-03-07

347 reads

Blog Challenge: I am watching you!

by Arun Sirpal

All About SQL

I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02/random-blog-post-challenge/ where we have to write a technical blog post that incorporates a certain...

2017-03-03

326 reads

Tempdb settings in SQL Server 2016

by Arun Sirpal

All About SQL

A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...

2017-03-02

400 reads

SQL Server Target vs Total Memory

by Arun Sirpal

All About SQL

For this blog post I want to discuss the meaning behind SQL Server: Memory Manager\Target Server Memory (KB) and SQL...

2017-03-01

436 reads

SSMS Presenter Mode

by Arun Sirpal

All About SQL

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...

2017-02-22

548 reads

SQL Server vNext: sys.dm_db_stats_histogram

by Arun Sirpal

All About SQL

Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...

2017-02-21

365 reads

Setting up SQL Server to SQL Database (Azure) Replication

by Arun Sirpal

All About SQL

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...

2017-02-20

385 reads

True story: Encryption in progress stuck

by Arun Sirpal

All About SQL

Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...

2017-02-16

369 reads

Blogs

Privacy Policy

By Cláudio Silva

We value your privacy. This policy explains what personal data we collect and why. What...

Why use XACT_ABORT?

By hellosqlkitty

This came up one day at my work when a developer was using it....

Using AI for Data Conversion

By Grant Fritchey

I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...

Read the latest Blogs

Forums

Find all records in a table whose values when summed up will equal another value

By kirkdevilliers

I have a list of transactions in a table. Each transaction has a unique...

sp_lock memory leak

By TheRedneckDBA

I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...

Migration related issue

I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...

Visit the forum

Question of the Day

Browsing for Instances

I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?

See possible answers