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.

All authors

SQL Server – RECONFIGURE

by Arun Sirpal

All About SQL

When you want to change configuration settings for your SQL Server you would either do it via Management studio (under...

2016-11-08

704 reads

Copying your SQL Database

by Arun Sirpal

All About SQL

If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...

2016-11-07

396 reads

Always Encrypted Column Encryption

by Arun Sirpal

All About SQL

I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...

2016-11-04

711 reads

SQL Server Backup Compression

by Arun Sirpal

All About SQL

I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...

2016-11-03

468 reads

SQL Server DMA v2.0 – Migration Time

by Arun Sirpal

All About SQL

In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...

2016-11-02

580 reads

SQL Server DMA – Data Migration Assistant V2.0

by Arun Sirpal

All About SQL

One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...

2016-11-01

669 reads

SSMS 2016 Bug

by Arun Sirpal

All About SQL

I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...

2016-10-27

644 reads

More bytes for Row versioning

by Arun Sirpal

All About SQL

I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the...

2016-10-26

363 reads