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

Extreme Work

by Brian Kelley

Databases – Infrastructure – Security

"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:

'Extreme' jobs...

2006-12-05

1,474 reads

Guidance on Microsoft Certified Architect Submissions

by Brian Kelley

Databases – Infrastructure – Security

For those considering the Microsoft Certified Architect program, some guidance on what to submit as documentation has been posted to...

2006-12-05

1,445 reads

Excellent post on encryption

by Brian Kelley

Databases – Infrastructure – Security

Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the...

2006-12-01

1,638 reads

Professional Association of SQL Server - Midlands Chapter First Meeting

by Brian Kelley

Databases – Infrastructure – Security

If you are in South Carolina or a nearby location (Charlotte, Augusta, etc.) and are interested in participating in an...

2006-12-01

1,566 reads

TechEd 2007 tracks announced

by Brian Kelley

Databases – Infrastructure – Security

The Microsoft TechEd tracks have been released early here:

Sneak Peak at the 2007 Tracks

For those who are interested in attending...

2006-12-01

1,475 reads

ApexSQL SQL Server VIP/MVP Offer

by Brian Kelley

Databases – Infrastructure – Security

ApexSQL has an offer to anyone who is a SQL Server MVP or VIP for a gratuity of their ApexSQL...

2006-11-29

1,734 reads

Measuring pi by throwing frozen hot dogs?

by Brian Kelley

Databases – Infrastructure – Security

I saw this today on my Google front page under the How To section:

How to Calculate Pi by Throwing Frozen...

2006-11-29

1,607 reads

Microsoft Network Monitor 3.0 Released

by Brian Kelley

Databases – Infrastructure – Security

If you aren't familiar with Network Monitor, it's a packet sniffer that's a Windows component on the server builds (Control...

2006-11-29

1,588 reads

SysInternals now on Microsoft TechNet

by Brian Kelley

Databases – Infrastructure – Security

It wasn't too long ago that Mark Russinovich announced he was becoming a Microsoft employee (new link as his old...

2006-11-27

1,677 reads

NGSSoftware compares Oracle and SQL Server security

by Brian Kelley

Databases – Infrastructure – Security

I first saw this at SQL Server MVP Jasper Smith's blog post Which database is more secure? Oracle vs. Microsoft:

NGSSoftware...

2006-11-25

1,696 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