On October 2nd and 3rd, I took part in an amazing event called AI Data Infrastructure Field Day as a delegate. If you’ve never heard of this event before,...
2024-11-20 (first published: 2024-11-11)
186 reads
IT and data professionals, I implore you – know thy platform. All of it. Not just the layer your job is tasked with. Modern public cloud (or any infrastructure...
2024-03-04 (first published: 2024-02-22)
204 reads
You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance....
2024-02-05 (first published: 2024-01-21)
195 reads
SQL Server query developers, listen up! Query execution time is not everything you should be worried about. You need to examine the parse and compilation time for each of...
2023-11-03 (first published: 2023-10-18)
585 reads
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective...
2023-10-11 (first published: 2023-09-18)
221 reads
I am overjoyed to announce a momentous occasion – we have officially reached the remarkable milestone of being in business for 10 years! This incredible journey began with a...
2023-09-01
15 reads
Are you bummed that you can’t attend the PASS Data Community Summit conference in-person this November during the week of November 13? There’s lots of reasons to be there,...
2023-08-25
8 reads
My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason...
2023-07-17 (first published: 2023-07-07)
372 reads
Heraflux is returning to deliver a new webinar with Rubrik and ActualTech Media titled “How to Secure Your Azure SQL Data.” With Azure SQL Server offerings continuing to grow...
2023-07-12 (first published: 2023-06-27)
68 reads
I’m thrilled to announce that the “Architecting Microsoft SQL Server on VMware vSphere” 8.0 best practices guide has been released! I’m pleased to have been able to contribute to...
2023-02-23
76 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