All About SQL

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...

2017-03-24

382 reads

My path from a junior to a senior DBA

by Arun Sirpal

All About SQL

A non-technical post but something I have been asked about few times so I thought that I would put pen...

2017-03-22

442 reads

TDE: Looking inside your database and backups

by Arun Sirpal

All About SQL

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...

2017-03-20

318 reads

Corrupt Database – I need that data now!

by Arun Sirpal

All About SQL

My database is in the recovery pending state and I want to get in and extract the data out into...

2017-03-15

361 reads

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

379 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

385 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

350 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

335 reads