Find the TCP port used by a named instance
We know for SQL Server default instance, if TCP/IP protocol is used, the default TCP port number is always 1433....
2008-11-13
1,346 reads
DBA Philosophy
Database administration complexity model
I have been working as a DBA for sometime now, and have been exposed to various database environments and with...
2008-11-07
1,173 reads
DBA and Doctor
I always feel it is harder to be a DBA than to be a doctor while we are doing almost...
2008-11-02
1,297 reads
ways to find the name of a running job
From time to time, I need to check (in my script) which jobs are running at the moment.So far, I...
2008-10-23
1,784 reads
Database Administration Librarian
If I cannot find a book or info in a library, I always go to a librarian for advice and...
2008-10-07
604 reads
DBA team building
Whenver we start a somewhat big IT project, it is natural for us to build a team dedicated to the...
2008-09-20
2,652 reads
Wish-list for SQL Server Replication
I have been working on sql server replication (on sql server 2K5) for more than 1 year now, starting from...
2008-09-07
895 reads
Database administration culture
"Culture", according to Merriam-Webster Dictionary http://www.merriam-webster.com/dictionary/culture, has one definition as
"the set of shared attitudes, values, goals, and practices that characterizes an...
2008-08-16
1,815 reads
Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,295 reads
Cold backup and remote control of sql server services
I recently got a request to do a "cold" backup of a small yet complex db environment, I say "small" because...
2008-08-02
707 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
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...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
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