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...
Comments posted to this topic are about the item Function Defaults
Comments posted to this topic are about the item Big Data or Small Data
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