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

SysInternals EULA Updated

by Brian Kelley

Databases – Infrastructure – Security

The SysInternals licensing has been updated on the SysInternals website.
The new licensing is something you'll want to take a look...

2006-05-05

1,470 reads

PromptSQL purchased by Red Gate Software

by Brian Kelley

Databases – Infrastructure – Security

It appears that PromptSQL has been purchased by Red Gate Software. I
haven't seen a news announcement about it, and there's...

2006-05-04

1,524 reads

SQL Server 2005 Books Online (April 2006)

by Brian Kelley

Databases – Infrastructure – Security

SQL Server 2005 Books Online has been updated for SP1. The newest
version is labeled SQL Server 2005 Books Online (April...

2006-05-04

1,525 reads

SQL Server 2005 Security Overview Webcast - On Demand

by Brian Kelley

Databases – Infrastructure – Security

I'm catching back up on the TechNet webcasts
I found interesting from April. Most are during the day and with
meetings and...

2006-05-01

697 reads

Checking SQL Server Versions

by Brian Kelley

Databases – Infrastructure – Security

This question comes up enough on the forums and with SP1 for SQL Server
2005 released, I'll cover it again. You...

2006-04-30

1,599 reads

Sharing Internet Connections?

by Brian Kelley

Databases – Infrastructure – Security

This study out of the University of Illinois at Urbana-Champaign sounds great:

Software Allows Neighbors To Improve Internet Access At No...

2006-04-30

1,590 reads

More on xp_logininfo

by Brian Kelley

Databases – Infrastructure – Security

In this post,
I talked about using xp_logininfo in order to get the permission paths
for a particular Windows account. If you've...

2006-04-29

10,556 reads

Fix for SSIS SP1 "service failed to start" issue

by Brian Kelley

Databases – Infrastructure – Security

I was catching up on my blog reading and found the following post from Jamie Thomson:

SSIS: Another SP1 problem

The post...

2006-04-28

1,449 reads

Issues with SQL Server 2005 SP1

by Brian Kelley

Databases – Infrastructure – Security

There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...

2006-04-27

1,620 reads

When life intrudes

by Brian Kelley

Databases – Infrastructure – Security

I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...

2006-04-26

1,459 reads

Blogs

Advice I Like: Failure

If it fails where you thought it would fail that is not a failure....

Data Conferences – Worth Every Dollar

Some of the best career enhancers you can buy. Why I Go to...

SQL Server 2025 RegEx and AI

One of the language changes in SQL Server 2025 that I’ve seen a lot...

Read the latest Blogs

Forums

Select @ for different fields

I have a need where I need to pass a field name to a...

Getting the Object Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Object Code

T-SQL in SQL Server 2025: Concatenating Strings

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Getting the Object Code

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO

See possible answers