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

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,528 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,526 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

699 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,602 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,592 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,558 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,450 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,461 reads

Issues tracking members of the sysadmin fixed server role

by Brian Kelley

Databases – Infrastructure – Security

I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...

2006-04-25

1,588 reads

Blogs

A New Word: Dolorblindness

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Claude Code Helps Analyze Test Data Manager Log Files

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

I had an idea for an animated view of a sales tool, and started...

Read the latest Blogs

Forums

Why the following cmds in sequence do not work

By hoa.nguyen 64423

I need to delete rows from both the temporal main and history tables. The...

When SQL Server Central Went Down

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When SQL Server Central Went...

The String Distance I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The String Distance I

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')

Assume preview features are enabled.

See possible answers