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,604 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,106 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,356 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

758 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

699 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,148 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

843 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,570 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,097 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,163 reads

Blogs

From Planning to Practice: Setting Up Your FinOps Framework

As someone who works in DevOps, I’m always focused on creating systems that are...

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Read the latest Blogs

Forums

how to write this query?

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers