This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity Virtual Group entitled “3 Reasons Why Focusing on Tech Is The Worst Way To Deploy...
2021-08-02
11 reads
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel 9 where I discuss setting up Linux storage appropriate for on-demand disk expansion for your...
2021-07-29
81 reads
I’m thrilled to be presenting with Deji Akomolafe a new session at this year’s VMworld 2021 conference called “Virtualization Microsoft SQL Server on vSphere – Stories from the Trenches”...
2021-07-22
41 reads
I’m pleased to announce that this month’s presentation for the Microsoft Data Platform Continuity Virtual Group will be on July 29th at 2pm Eastern time. This presentation from Edwin...
2021-07-20
6 reads
Do you have quite large MDF files on your database? By large, I mean hundreds of gigabytes (or larger). Have you ever noticed that your SQL Server disk stall...
2021-07-21 (first published: 2021-07-08)
675 reads
I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...
2021-07-09 (first published: 2021-06-28)
254 reads
Disasters big and small happen, and as data professionals, you should be prepared for the worst! I’m thrilled to announce that we’re launching the Microsoft Data Platform Continuity Virtual...
2021-06-15
12 reads
With the rise of Kubernetes and other completely cloud-based deployments, on-premises data centers seem to be on the way out to make way for the scalability and dynamism of...
2021-06-08
8 reads
I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey. He recently recorded a different podcast that talks about the journey from being an IT...
2021-05-28 (first published: 2021-05-18)
89 reads
April 21 to 23 saw a new milestone for me. I was a new delegate for the 23rd Tech Field Day! It’s an absolute honor and thrill to be...
2021-05-17
17 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
This is my last week of the year working (I guess I come back...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
I have an ADF pipeline that copies Files from source to destination. Both Source...
Comments posted to this topic are about the item 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