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

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

217 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

165 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

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

You rated this post out of 5. Change rating

2016-04-26

3,541 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.