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.

SQL Server – Pause VS Stop

by Arun Sirpal

All About SQL

You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...

2017-10-02

353 reads

SSMS 17 Dark Theme

by Arun Sirpal

All About SQL

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...

2017-09-29

2,686 reads

Azure SQL Database Active Geo Replication Changes

by Arun Sirpal

All About SQL

Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...

2017-09-25

522 reads

SQL Server Tracking Suspect Pages

by Arun Sirpal

All About SQL

Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...

2017-09-25 (first published: 2017-09-19)

1,586 reads

SQL Server Schema Compare

by Arun Sirpal

All About SQL

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...

2017-09-18

519 reads

Azure SQL Database Resumable Online Index Rebuild

by Arun Sirpal

All About SQL

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...

2017-09-14

1,194 reads

[Video] SQL Server Deadlocks

by Arun Sirpal

All About SQL

SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...

2017-09-08 (first published: 2017-08-24)

1,978 reads

DBCC CHECKDB Azure SQL Database

by Arun Sirpal

All About SQL

Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...

2017-09-04

638 reads

Azure SQL Database – Scaling up

by Arun Sirpal

All About SQL

Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...

2017-09-01 (first published: 2017-08-23)

1,294 reads

SSMS and MFA support for Azure SQL DB

by Arun Sirpal

All About SQL

Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...

2017-08-30

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