Letter To My Father
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
499 reads
SQLFlipFlopsDBA
Some Time Away
Greetings everybody! It has been a while since I posted anything here. I figured I...
2019-04-26 (first published: 2019-04-15)
748 reads
Veterans At PASS Summit ’18
Hello all!
This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service...
2018-10-10
183 reads
Azure Runbook Configuration
Hello everybody! Greetings from the very warm state of Texas! One of the most popular questions I get when talking...
2018-08-23 (first published: 2018-08-02)
1,988 reads
Webinars, and Azure, and SQL… OH MY!
Hello everybody! Thank you once again for stopping by and reading. April has been pretty busy with presentations, and I...
2018-04-25
97 reads
Getting the Azure DTU Calculator to work on a 2008R2 OS w/ a 2008R2 SQL Server Instance
Hello everyone! I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator)...
2018-04-24
1,172 reads
Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 2
Hello everybody! Thanks for stopping by again. In Part 1 of this series, I gave the background of the project, and...
2018-04-02
109 reads
Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 1
Hello everybody!
I have been working with one of my favorite clients lately on migrating their SQL databases to a DBaaS...
2018-02-10
129 reads
Upcoming SQLSaturdays
I have the priveledge of speaking at two SQLSaturday events coming up in the near future. This is the first...
2018-01-02
110 reads
Creating and Using Failover Groups in Azure DBaaS – Part 2
Connecting to Failover Group
So in Part 1 of this series, we created and configured our Failover Group. Well, now that...
2017-12-26
108 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
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