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.

Folks Who Have Made a Difference

by Arun Sirpal

All About SQL

TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...

2017-11-14

308 reads

SQL Server Phantom Reads

by Arun Sirpal

All About SQL

With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...

2017-11-08 (first published: 2017-10-26)

1,615 reads

Azure SQL Database Compatibility Levels

by Arun Sirpal

All About SQL

Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...

2017-11-06

520 reads

Microsoft MVP!?

by Arun Sirpal

All About SQL

What? Is probably the most common reply out there and if it is then that is how I felt when...

2017-11-02

406 reads

Query Store – SQL Server 2017 vs Azure SQL Database

by Arun Sirpal

All About SQL

I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...

2017-11-02 (first published: 2017-10-24)

2,055 reads

Azure SQL Database Automatic Tuning – Questions Answered

by Arun Sirpal

All About SQL

I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...

2017-11-01

377 reads

SQL Server: What will REPAIR do?

by Arun Sirpal

All About SQL

So I had a corruption issue and I was thinking about running repair but I wanted to know what would...

2017-10-24 (first published: 2017-10-16)

2,074 reads

Azure SQL Database Level Firewall Rules

by Arun Sirpal

All About SQL

I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...

2017-10-20 (first published: 2017-10-11)

1,703 reads

Connecting to Azure SQL Database Primary Endpoint – Failover Groups

by Arun Sirpal

All About SQL

When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...

2017-10-19

685 reads

SQL Server 2017 Encrypted Backups And Compression

by Arun Sirpal

All About SQL

Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...

2017-10-18 (first published: 2017-10-09)

3,091 reads

Blogs

RANK() vs DENSE_RANK(): #SQLNewBlogger

I haven’t done one of these in awhile, but I saw an article recently...

Using CAT for Testing of Data Agents

By Joyful-Craftsmen

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By ChrisJenkins

Do you spend so long manipulating your data into something vaguely useful that you...

Read the latest Blogs

Forums

Fun with JSON

Comments posted to this topic are about the item Fun with JSON

Creating JSON II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON II

Engineer Lessons

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Engineer Lessons

Visit the forum

Question of the Day

Creating JSON II

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO

See possible answers