Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

Teaching Children to Program

by Brian Kelley

Databases – Infrastructure – Security

One of the blogs I follow is Andrew Coates' blog over at MSDN. He has posted about starting to help...

2006-11-21

1,451 reads

Mixed Feelings about the SQL Server Central Sale to Red Gate

by Brian Kelley

Databases – Infrastructure – Security

I've read numerous posts and several blogs discussing the SQL Server Central sale to Red Gate and at the end...

2006-11-20

1,622 reads

SQL Server 2005 SP2 CTP Available for Download

by Brian Kelley

Databases – Infrastructure – Security

The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download...

2006-11-08

1,970 reads

Chess

by Brian Kelley

Databases – Infrastructure – Security

Recently I started getting back into the game of chess as I began coaching my boys. Chess is a great...

2006-11-02

1,678 reads

Picking back up on blogging

by Brian Kelley

Databases – Infrastructure – Security

It has been a trying month to month and a half with the implementation of Microsoft's CRM 3.0 product. By...

2006-10-30

1,368 reads

Diversions

by Brian Kelley

Databases – Infrastructure – Security

I've been rather quiet for a while and there's a reason. I've been
helping some friends get a general gaming site...

2006-09-22

1,501 reads

SQL Server 2005 Scripts on TechNet

by Brian Kelley

Databases – Infrastructure – Security

I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...

2006-09-01

1,450 reads

Removing SQL Server Express from VS Team System for Database Professionals CTP 5

by Brian Kelley

Databases – Infrastructure – Security

As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...

2006-08-24

1,378 reads

Visual Studio Team System for Database Professionals CTP 5 Out

by Brian Kelley

Databases – Infrastructure – Security

If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...

2006-08-23

1,418 reads

The Importance of Database Coding Standards

by Brian Kelley

Databases – Infrastructure – Security

I was working with a developer the other day and the question came up
of how to return status from a...

2006-08-17

1,816 reads

Blogs

My 2024 in Data: Health and Workouts

This is my last week of the year working (I guess I come back...

My 2024 in Data: Reading

This is my last week of the year working (I guess I come back...

Book Review – Agile Data Warehouse Design

By Koen Verbeeck

I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...

Read the latest Blogs

Forums

Need ADF pipeline suggestion to copy 1 million files

I have an ADF pipeline that copies Files from source to destination. Both Source...

Backup issues

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Visit the forum

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