I’m back! I’m still a Microsoft Data Platform MVP. And other minor life updates.
I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading
2023-07-27
28 reads
SQLStudies
SQL Agent job history on a Managed Instance
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading
2023-08-09 (first published: 2023-07-25)
249 reads
db_ddladmin Jr.
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading
2023-07-20
52 reads
How do I tell if a user is orphaned or actually created without a login?
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading
2023-08-02 (first published: 2023-07-18)
631 reads
The two hardest concepts of security are Who? and Where?
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading
2023-07-28 (first published: 2023-07-13)
297 reads
Code that made you feel a certain way : T-SQL Tuesday #164
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading
2023-07-26 (first published: 2023-07-11)
346 reads
End of year planning: T-SQL Tuesday #157
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the ... Continue reading
2022-12-15 (first published: 2022-12-13)
43 reads
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading
2022-12-08
120 reads
What’s next: Job search burnout
I was given 4.5 months notice this past June and was fortunate to find a new job. I blogged about ... Continue reading
2022-12-06
18 reads
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
438 reads
Blogs
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
My 2024 in Data: Travels
By Steve Jones
This is my last week of the year working (I guess I come back...
Forums
Function Defaults
Comments posted to this topic are about the item Function Defaults
Big Data or Small Data
Comments posted to this topic are about the item Big Data or Small Data
Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake
Comments posted to this topic are about the item Level 4 of the Stairway...
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