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

Learning to Give Presentations Well (Part 1)

by Brian Kelley

Databases – Infrastructure – Security

I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...

2017-11-17 (first published: 2017-11-06)

1,510 reads

Learning to Give Presentations Well (Part 2)

by Brian Kelley

Databases – Infrastructure – Security

Presentation Zen cover
In Part 1, I gave some advice from Toastmasters. We’ll return to the Toastmasters advice in Part 3....

2017-11-15

529 reads

Don’t “Test” Against Production

by Brian Kelley

Databases – Infrastructure – Security

A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...

2017-10-30 (first published: 2017-10-18)

2,062 reads

If You’re Stuck at Home for the PASS Summit

by Brian Kelley

Databases – Infrastructure – Security

Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...

2017-10-30

674 reads

Automating Everything with PowerShell – Getting Started #tsql2sday

by Brian Kelley

Databases – Infrastructure – Security

I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...

2017-10-17

907 reads

Randomness in Security Configuration

by Brian Kelley

Databases – Infrastructure – Security

We were deploying a new web service. Because of the nature of the service, we wanted it to listen on...

2017-08-24 (first published: 2017-08-14)

1,412 reads

Just Say No to Social Engineering Memes

by Brian Kelley

Databases – Infrastructure – Security

These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...

2017-08-11

1,421 reads

#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

320 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,693 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

290 reads

Blogs

Designing a Storage Load Test for SQL Server

By Anthony Nocentino

I’ve been doing storage load tests for SQL Server for a long time, both...

Questions and Answers from Running a Local LLM

I had a few random questions from my Running a Local LLM on Your...

Overview of Claude AI Models: Which One to Choose?

For those entering the AI space whether professionally or personally I wanted to give...

Read the latest Blogs

Forums

A question about how to store the address in the database

I have an app that has an address field on the customer and the...

SSIS package failing intermittently on last Excel Component

Good Afternoon, I have a Job which "fires" off an SSIS package (that is...

T-SQL in SQL Server 2025: JSON_ARRAYAGG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Multiple Sequence Values

How do I easily get the next 12 sequence values from a sequence object?

See possible answers