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

533 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,070 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

681 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,422 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,433 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

322 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,694 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

298 reads

Blogs

Audit – Security Compliance Frameworks (Part 1)

By Vinay Thakur

This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...

Restore SQL Server Database to an OrbStack Container

By MarlonRibunal

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Day of Data Baton Rouge Slides and Code

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Read the latest Blogs

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

By Pablo Echeverria

Comments posted to this topic are about the item Can You Really Downgrade from...

What is CPU Usage?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is CPU Usage?

Limiting Checkpoints

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting Checkpoints

Visit the forum

Question of the Day

Limiting Checkpoints

If I use the -k parameter with a number after it, what does this change in SQL Server?

See possible answers