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

SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness

by Brian Kelley

Databases – Infrastructure – Security

A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...

2006-06-21

2,140 reads

Whitepaper: SQL Server 2005 Physical Database Storage Design

by Brian Kelley

Databases – Infrastructure – Security

Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...

2006-06-15

2,052 reads

Distributing Database Connection Strings Using Active Directory Group Policy

by Brian Kelley

Databases – Infrastructure – Security

I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...

2006-06-13

2,328 reads

TechEd - DATTLC01 : Troubleshooting Performance Problems in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...

2006-06-12

1,580 reads

In Boston for TechEd

by Brian Kelley

Databases – Infrastructure – Security

This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...

2006-06-11

1,491 reads

Two things I wish they'd change about endpoints in SQL Server 2005

by Brian Kelley

Databases – Infrastructure – Security

I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...

2006-05-27

2,144 reads

When It Takes Time...

by Brian Kelley

Databases – Infrastructure – Security

Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:

Project Managing Latency or: How to...

2006-05-25

1,450 reads

Disaster Recovery and SQL Server, Part II

by Brian Kelley

Databases – Infrastructure – Security

In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...

2006-05-24

1,495 reads

SQL Prompt

by Brian Kelley

Databases – Infrastructure – Security

I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...

2006-05-23

1,622 reads

Disaster Recovery and SQL Server, Part I

by Brian Kelley

Databases – Infrastructure – Security

The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...

2006-05-20

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

Case part is sloooooow

Hi So the case statement is slowing this down - but for the life...

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...

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