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.

Blog Post

Azure VM Scale Sets

I really like scale sets. It lets you create and manage up to 1000 load balanced VMs per availability zone using windows or Linux images. (We can have flexible...

2022-06-09

9 reads

Blog Post

Azure VM Types

There are many different family groups for Azure VMs each with its own purpose. Below is a summary of what can be selected. This is important because for example...

2022-06-06

11 reads

Blog Post

Azure High Availability

Lets write about Microsoft Azure, specially the area of high availability when it comes to virtual machines. No doubt you will know about Azure Virtual Machines. IaaS approach is...

2022-05-31

13 reads

Blogs

Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21

By

You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...

The Effectiveness of Solar Estimation

By

We added a solar system to the ranch as a way to hedge against...

How do I tell if identity_insert is turned on and if so what table?

By

TLDR; The code to do this is below but it’s a bit hokey and...

Read the latest Blogs

Forums

Shared Work Spaces: Hell, Heaven, Both?

By Grant Fritchey

Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...

T-SQL : Slicing time Islands and gaps

By MrRobot

Hello, Consider the following table that gives the validity dates of an item :...

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers