PowerShell Usage In DBA Work — Case Study 1 / 7
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
958 reads
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
958 reads
For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from...
2013-02-04
777 reads
One thing lots of DBA teams, esp. the DBA managers, feel uncomfortable is that it is difficult to quantify/log DBA’s...
2012-10-22
1,812 reads
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,882 reads
As a DBA, when can you consider yourself as a senior DBA?
If you read online posts, you will find most...
2012-08-27
3,443 reads
As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...
2012-07-31
1,884 reads
I define DBA operation productivity as the total positive values brought to the work environment by a DBA in a...
2012-07-24
1,072 reads
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...
2012-06-23
923 reads
For the past few years, I have seen tens of sql server boxes added in my work environment every year,...
2012-06-04
4,627 reads
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....
2012-06-02
1,054 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 ENDHow can I call this and invoke the default value for @two? See possible answers