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.

The world of Automatic Tuning – SQL Server 2017

by Arun Sirpal

All About SQL

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...

2018-01-31 (first published: 2018-01-22)

2,407 reads

Azure Portal – Bad Request

by Arun Sirpal

All About SQL

I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...

2018-01-16

263 reads

Azure SQL Database – Optimizing For Ad-hoc Workloads

by Arun Sirpal

All About SQL

Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...

2018-01-16 (first published: 2018-01-08)

1,598 reads

T-SQL Tuesday #98 Round Up

by Arun Sirpal

All About SQL

Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...

2018-01-11

574 reads

Azure SQL Analytics

by Arun Sirpal

All About SQL

Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to...

2018-01-04

985 reads

T-SQL Tuesday #98 – Your Technical Challenges Conquered

by Arun Sirpal

All About SQL

Welcome to the January 2018 edition of T-SQL Tuesday and I am your host BlobEater (Arun Sirpal).
If you do not...

2018-01-02

626 reads

A Basic Bot using Azure Bot Services

by Arun Sirpal

All About SQL

I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....

2017-12-19

566 reads

Moving to an Azure SQL Database via Command Line

by Arun Sirpal

All About SQL

I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...

2017-12-19 (first published: 2017-12-07)

1,520 reads

SQL Server DBCC CHECKDB – Going Parallel

by Arun Sirpal

All About SQL

DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...

2017-12-18

312 reads

Azure SQL Database – Using sp_BlitzIndex

by Arun Sirpal

All About SQL

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...

2017-12-14 (first published: 2017-12-05)

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