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

587 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

677 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

647 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

368 reads

Azure App Service Companion for iOS

by Arun Sirpal

All About SQL

This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...

2016-10-25

468 reads

The dark side of Fn_dump_dblog

by Arun Sirpal

All About SQL

I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...

2016-10-24 (first published: 2016-10-17)

1,973 reads

Another way to move SQL DB to Azure

by Arun Sirpal

All About SQL

About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...

2016-10-20

464 reads