Toad World Blog

Arun Sirpal

Mentored by Paul Randal - MVP (SQLskills) during 2015 finally completed my training in Internals and performance tuning with SQLskills during 2016. I have written online articles, created a centralised SQL Server dashboard project on CodePlex, iTunesU Podcasts and I have helped with data collection for SQLskills waits and latches library. Find me on:

Arun Sirpal

sqlPlatform

SQL Server

My path from a junior to a senior DBA
A non-technical post but something I have been asked about few times so I thought ... Keep reading >
Posted on Mar 22, 2017 8:00:50 AM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

TDE: Looking inside your database and backups
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget ... Keep reading >
Posted on Mar 20, 2017 1:30:45 AM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

Corrupt Database – I need that data now!
My database is in the recovery pending state and I want to get in and extract the ... Keep reading >
Posted on Mar 15, 2017 7:01:36 AM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

Extreme situations require extreme commands
The title is adapted from a child-hood movie of mine and is my daily ... Keep reading >
Posted on Mar 13, 2017 8:00:48 PM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

My take on presenting
This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new ... Keep reading >
Posted on Mar 10, 2017 2:06:19 AM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

Blog Challenge: I am watching you!
I decided to accept Grant’s (TheScaryDBA) challenge found ... Keep reading >
Posted on Mar 2, 2017 9:28:06 PM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

Tempdb settings in SQL Server 2016
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. ... Keep reading >
Posted on Mar 2, 2017 3:30:47 AM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

SQL Server Target vs Total Memory
For this blog post I want to discuss the meaning behind SQL Server: Memory ... Keep reading >
Posted on Mar 1, 2017 1:30:45 AM by Arun Sirpal
Tags: SQL Server 0 Comments
sqlPlatform

SQL Server

SSMS Presenter Mode
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side ... Keep reading >
Posted on Feb 22, 2017 3:45:54 AM by Arun Sirpal
Tags: SQL Server 0 Comments
SQLServerPlatform-1

SQL Server

SQL Server vNext: sys.dm_db_stats_histogram
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to ... Keep reading >
Posted on Feb 20, 2017 7:30:21 PM by Arun Sirpal
Tags: SQL Server 0 Comments
SQLServerPlatform-1

SQL Server

Setting up SQL Server to SQL Database (Azure) Replication
I had a need to setup transactional replication from my SQL Server to SQL Database ... Keep reading >
Posted on Feb 20, 2017 6:01:03 AM by Arun Sirpal
Tags: SQL Server 0 Comments
SQLServerPlatform-1

SQL Server

True story: Encryption in progress stuck
Working with a couple of databases that needed TDE I noticed when I enabled one of ... Keep reading >
Posted on Feb 16, 2017 4:00:02 AM by Arun Sirpal
Tags: SQL Server 0 Comments