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 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

442 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

557 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

371 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

390 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

375 reads

Azure Advisor Recommendations

by Arun Sirpal

All About SQL

Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...

2017-02-15

334 reads

Lightweight Statistics Profiling (with a potential bug)

by Arun Sirpal

All About SQL

The great thing about new versions of SQL Server is the fact that they are packed full of new features...

2017-02-13

399 reads

Using Extended Events in Azure

by Arun Sirpal

All About SQL

Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...

2017-02-10 (first published: 2017-02-06)

1,302 reads

SQL Server vNext

by Arun Sirpal

All About SQL

I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...

2017-02-03

729 reads

Compare Execution Plans

by Arun Sirpal

All About SQL

Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...

2017-02-02

437 reads

Blogs

Upgrading SQL Server Containers on the Laptop

I don’t have SQL Server installed on my laptop. In an effort to keep...

How to Find Expensive Queries in Amazon Redshift

By Eduardo Pivaral

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

If you've been here before, you know this blog is usually about SQL Server,...

Read the latest Blogs

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

Hi all Can I get some perspective from the community please on performing in-place...

How Long is a Long I/O?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Long is a Long...

T-SQL Trigonometric Functions in SQL Server

Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...

Visit the forum

Question of the Day

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

See possible answers