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

534 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,071 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,423 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,440 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

323 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

Learning Tool – Deepstash

By Brian Kelley

A few months ago I started using Deepstash. Deepstash breaks books into the key...

New article – migrating from a named instance

By Brian Kelley

Do you have a case where you have a named instance you'd like to...

Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot

By Anthony Nocentino

I’ve been running this blog on Hugo for a long time, and like most...

Read the latest Blogs

Forums

Admin Rights for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Admin Rights for Everyone

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

By Arvind Toorpu

Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...

RegEx Functions I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions I

Visit the forum

Question of the Day

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

See possible answers