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,526 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

535 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,072 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

682 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

910 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,424 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,444 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

324 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,696 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

299 reads

Blogs

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

What Does It Mean to Make Data AI-Ready?

Making Data AI-Ready, Part 1 (This is the first article in a three-part series...

Using the Data API Builder–VS Live San Diego Resources

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...

Read the latest Blogs

Forums

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

Comments posted to this topic are about the item Practical Reporting Queries with CROSS...

Your Favorite Quotes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite Quotes

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers