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

March/April 2006 Edition of SQL Server Standard Available

by Brian Kelley

Databases – Infrastructure – Security

The March/April 2006 edition of SQL Server Standard magazine is now
available. This issue focuses on Transact-SQL for SQL Server 2005.
Though...

2006-04-03

1,504 reads

12-inch grass stem?

by Brian Kelley

Databases – Infrastructure – Security

Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...

2006-03-29

1,348 reads

Internet Explorer Vulnerability

by Brian Kelley

Databases – Infrastructure – Security

If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...

2006-03-28

1,546 reads

Rights within the database

by Brian Kelley

Databases – Infrastructure – Security

This is a follow-on to my post What are the actual rights?

First and foremost, I want to include membership in...

2006-03-14

1,412 reads

What are the actual rights?

by Brian Kelley

Databases – Infrastructure – Security

One of the things I've started to work on are some scripts to quickly
be able to pull what a user's...

2006-03-14

1,433 reads

First Impressions of Professional SQL Server 2005 Integration Services

by Brian Kelley

Databases – Infrastructure – Security

I received a copy of Professional SQL Server 2005 Integration Services
a few weeks back from Kathi. Because of illness and...

2006-03-13

1,474 reads

Tool Updates

by Brian Kelley

Databases – Infrastructure – Security

Catching up on recent updates for tools I've looked at and/or recommended.

SQL Server Tools:

PromptSQL is now up to version 1.4....

2006-03-13

1,561 reads

Microsoft MVP Program

by Brian Kelley

Databases – Infrastructure – Security

I think anyone who posts actively in the various on-line forums for
Microsoft products (such as SSC.com) hopes one day to...

2006-02-23

1,366 reads

Mavericks don't make it

by Brian Kelley

Databases – Infrastructure – Security

One of the blogs I most enjoy reading is Life Beyond Code.
This blog allows me to take off my technology...

2006-02-18

1,434 reads

My Reading list

by Brian Kelley

Databases – Infrastructure – Security

In the tradition of many others, I decided to add a reading list to my professional site. The reading list...

2006-02-16

1,408 reads

Blogs

My 2024 in Data: Reading

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

My 2024 in Data: Speaking

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

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By Tracy McKibben

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

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