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.

Database Has Been Paused

by Arun Sirpal

All About SQL

I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...

2018-04-03 (first published: 2018-03-27)

3,431 reads

Azure SQL Database and Cost Threshold for Parallelism

by Arun Sirpal

All About SQL

We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...

2018-03-26 (first published: 2018-03-16)

2,294 reads

Backup and Restore Options for Azure SQL DB

by Arun Sirpal

All About SQL

I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...

2018-03-26

572 reads

SQL Vulnerability Assessment for Azure SQL Database

by Arun Sirpal

All About SQL

Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....

2018-03-22

984 reads

Understanding DBCC FLUSHAUTHCACHE

by Arun Sirpal

All About SQL

This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...

2018-03-14

717 reads

Azure SQL Database – Allow Azure Services to Access Server

by Arun Sirpal

All About SQL

When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...

2018-03-09 (first published: 2018-03-01)

2,478 reads

Saving Costs in Azure

by Arun Sirpal

All About SQL

Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...

2018-02-27 (first published: 2018-02-15)

1,777 reads

How to setup Azure SQL Analytics

by Arun Sirpal

All About SQL

I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...

2018-02-26

1,034 reads

Azure SQL Database sa Connections?

by Arun Sirpal

All About SQL

I was using a query on one of my local SQL Servers where I wanted to know what logins were...

2018-02-07

1,044 reads

Deleting Azure SQL Database VNETs

by Arun Sirpal

All About SQL

This is quite a new feature (currently in preview) but an important one where we now have the ability to...

2018-02-07 (first published: 2018-01-29)

1,023 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