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

377 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

432 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

315 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

353 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

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