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

On Leadership - Lead by Example

by Brian Kelley

Databases – Infrastructure – Security

This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...

2011-04-07

1,612 reads

SQL Injection: It's not just about your data

by Brian Kelley

Databases – Infrastructure – Security

On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...

2011-04-06

1,122 reads

SQL PASS ERC: How to Score the Interview?

by Brian Kelley

Databases – Infrastructure – Security

One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...

2011-04-06

1,363 reads

Epsilon Data Breach and Staying Safe

by Brian Kelley

Databases – Infrastructure – Security

By now, you may have received an email from one of the larger businesses you've given your email address to...

2011-04-05

770 reads

A SQL Story in Eleven Words or Less

by Brian Kelley

Databases – Infrastructure – Security

Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...

2011-04-04

707 reads

Isolating SQL Server from other systems

by Brian Kelley

Databases – Infrastructure – Security

In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...

2011-04-04

2,165 reads

Reflections on Dev Connections / SQL Connections

by Brian Kelley

Databases – Infrastructure – Security

When SQL Connections in the spring was announced, the folks at Red Gate and SQL Server Central reached out to...

2011-04-01

854 reads

Presenting with a Mac

by Brian Kelley

Databases – Infrastructure – Security

My name is Brian Kelley and I used to be a PC bigot. That was back in 1989. I was...

2011-03-31

1,578 reads

Improving Meetings

by Brian Kelley

Databases – Infrastructure – Security

Most folks I know hate meetings. They especially hate meetings about meetings. Recently I was working with a developer who...

2011-03-30

2,109 reads

On Leadership - Lead from the Front

by Brian Kelley

Databases – Infrastructure – Security

This topic actually came up at SQL Saturday #70 - Columbia, SC. I spent the first 15 years of my life...

2011-03-29

2,168 reads

Blogs

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By MarlonRibunal

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By Brian Kelley

Here is another short video (~ 15 minutes). This is by the author of...

Read the latest Blogs

Forums

MERGE in a nested TRY/CATCH won't roll back

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers