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

Azure SQL Database scripts

by Arun Sirpal

All About SQL

I thought that this would be useful for others – couple of scripts that I have been using in Azure for...

2016-07-01

181 reads

Configuring geo-replication for an Azure SQL Database

by Arun Sirpal

SQLServerCentral.com

geo-replication

This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (5)

2016-06-27

1,470 reads

Discuss

sys.dm_db_wait_stats DMV

by Arun Sirpal

All About SQL

Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the...

2016-06-02

196 reads

PowerShell – Deleting those files

by Arun Sirpal

All About SQL

Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...

2016-06-01

158 reads

Wait Types and Latch Classes Library

by Arun Sirpal

All About SQL

Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...

2016-05-10

265 reads

SQL Server Resource Governor

by Arun Sirpal

SQLServerCentral.com

Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.65 (17)

2016-04-26

3,049 reads

Discuss

Migrating an on premise SQL Server Database to Azure

by Arun Sirpal

SQLServerCentral.com

SQL Server

For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.