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.

Azure SQL Database / SQL Server – Paused Index Rebuild

by Arun Sirpal

All About SQL

I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...

2018-05-30 (first published: 2018-05-22)

1,883 reads

Extended Events – Using Azure Storage

by Arun Sirpal

All About SQL

Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks...

2018-05-21 (first published: 2018-05-08)

1,423 reads

Handy TSQL for Azure SQL Database

by Arun Sirpal

All About SQL

I do not always use the Azure portal to make database changes or to check for certain information. I use...

2018-05-14

321 reads

Getting my Twitter Data via Azure Logic Apps

by Arun Sirpal

All About SQL

As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...

2018-05-02

330 reads

Azure SQL Database – A Copying “Gotcha”

by Arun Sirpal

All About SQL

Creating copies of your Azure SQL Database is a common and relatively simple process. You can issue a TSQL statement...

2018-04-24

351 reads

Azure SQL Database vCore

by Arun Sirpal

All About SQL

vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...

2018-04-24 (first published: 2018-04-16)

2,369 reads

Azure SQL Database and Columnstore Indexes

by Arun Sirpal

All About SQL

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...

2018-04-19 (first published: 2018-04-09)

2,186 reads

4 Improvements to Azure SQL Database

by Arun Sirpal

All About SQL

If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...

2018-04-12 (first published: 2018-04-05)

2,177 reads

Azure SQL DW – Let’s Shuffle?

by Arun Sirpal

All About SQL

Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...

2018-04-12

866 reads

Azure SQL Database – Failed to Delete Database Nightmare

by Arun Sirpal

All About SQL

After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....

2018-04-03

359 reads

Blogs

My 2024 in Data: Reading

This is my last week of the year working (I guess I come back...

My 2024 in Data: Speaking

This is my last week of the year working (I guess I come back...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By Tracy McKibben

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

Need ADF pipeline suggestion to copy 1 million files

I have an ADF pipeline that copies Files from source to destination. Both Source...

Backup issues

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Visit the forum

Question of the Day

Function Defaults

I have created this function in SQL Server 2022:

CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
    RETURN @one + @two
END

How can I call this and invoke the default value for @two?

See possible answers