MVP No more, But It’s OK
Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was honored to receive the MVP award for my work in the
The post MVP No more,...
2024-07-26 (first published: 2024-07-12)
407 reads
Database Superhero’s Blog
Presenting at PASS Summit 2023 – Atomic Habits
I’m excited to be presenting at PASS Summit 2023, not only because it is PASS Summit but because of the topic. I do a lot
The post Presenting at PASS...
2023-08-11 (first published: 2023-07-26)
141 reads
Twenty Years as a Guardian ad Litem
Twenty years ago, I stood in a courtroom and took an oath for a volunteer job I had no idea I would fall so much
The post Twenty Years as...
2023-06-30 (first published: 2023-06-26)
195 reads
T-SQL Tuesday #163 – Career Advice I received
It’s time for our monthly blog party and thanks to Gethyn Ellis ( t | b) for hosting this month. Gethyn asks us for the best Career
The post T-SQL Tuesday #163...
2023-07-07 (first published: 2023-06-21)
233 reads
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up it in many various ways to run Ola’s Index Optimize and
The post Using Azure Automation...
2023-06-26 (first published: 2023-06-06)
391 reads
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots of fear as to how the community was going to take
The post WIT/DEI Mental Health...
2023-03-29 (first published: 2023-03-24)
96 reads
Call to Action for Female Speakers to Submit to EightKB
EightKB is a wonderfully ran conference by my friends Mark Wilkinson (T | B), Anthony Nocentino (T | B), Andrew Pruski (T | B), and
The post Call to Action...
2023-03-22 (first published: 2023-03-14)
115 reads
Script to Install the Tools I Use on My Jumpbox
I wrote a blog post a few months ago about the tools I use on my jumpbox you can read here. Since then, I have
The post Script to Install...
2023-02-06 (first published: 2023-01-24)
416 reads
Impact of Eliminating Implicit Conversions in JDBC Driver
Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop
The post Impact of Eliminating...
2023-01-27 (first published: 2023-01-18)
258 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2022 Edition
Trigger warning: suicidal ideation, depression, bipolar, mania If you would prefer to stick to all the positives skip to the numbered list at the bottom.
The post T-SQL Tuesday #121:...
2022-12-31
17 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