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

68 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

33 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

29 reads

Blogs

Asking for Help Isn’t a Weakness

By

During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...

The Proof of the Backup Is in the Pudding

By

For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...

T-SQL Tuesday #204 – Are blogs still relevant?

By

Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....

Read the latest Blogs

Forums

The ##MS_DatabaseConnector## User

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The ##MS_DatabaseConnector## User

Planning for Change

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Planning for Change

Importing Excel files into SQL Server, Azure Edition

By Cláudio Tereso

Comments posted to this topic are about the item Importing Excel files into SQL...

Visit the forum

Question of the Day

The ##MS_DatabaseConnector## User

On SQL Server 2025, I run this code as a sysadmin:

CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567'
GO
ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo
GO
I then login as Demo and run this:
USE sandbox
go
SELECT CURRENT_USER
What is returned?

See possible answers