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

#TSQL2sday: Interviewing Patterns

by Brian Kelley

Databases – Infrastructure – Security

This T-SQL Tuesday is hosted by Kendra Little.
I’ve been told interviewing is an art. Perhaps it is. I view it...

2017-08-08

318 reads

Remember What It’s Like to Be a Rookie

by Brian Kelley

Databases – Infrastructure – Security

File this under “soft skills.” Let me start with a recent experience.
Last week I was leading a team of youth...

2017-08-08 (first published: 2017-07-20)

1,691 reads

Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl

by Brian Kelley

Databases – Infrastructure – Security

This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will...

2017-07-24

289 reads

Security Basics: The Principle of Least Privilege

by Brian Kelley

Databases – Infrastructure – Security

Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...

2017-07-17 (first published: 2017-06-30)

2,939 reads

The Three A’s: Auditing

by Brian Kelley

Databases – Infrastructure – Security

Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...

2017-07-13 (first published: 2017-06-28)

1,620 reads

The Three A’s: Authorization

by Brian Kelley

Databases – Infrastructure – Security

Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know...

2017-07-10 (first published: 2017-06-27)

1,660 reads

The Three A’s: Authentication

by Brian Kelley

Databases – Infrastructure – Security

When I start talking with folks about security, one of the areas of confusion I often find has to do...

2017-07-05 (first published: 2017-06-26)

1,824 reads

Recording of PASS Security VC Webinar

by Brian Kelley

Databases – Infrastructure – Security

If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...

2017-06-29

558 reads

#SQLChat on Performance Issues

by Brian Kelley

Databases – Infrastructure – Security

Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource...

2017-06-23

370 reads

PASS Security VC Presentation – The Dirty Business of Auditing

by Brian Kelley

Databases – Infrastructure – Security

On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...

2017-06-19

367 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