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

Thank you, Mr. Solomon

by Brian Kelley

Databases – Infrastructure – Security

On one of the newsgroups I follow, I received a message that David Solomon will no longer be teaching seminars...

2013-07-30

1,429 reads

Audio and slides are up for my webinar on SQL Server encryption

by Brian Kelley

Databases – Infrastructure – Security

The webinar audio and slides/demo scripts are up for the presentation I did for the PASS Security virtual chapter.

PASS Security...

2013-07-19

768 reads

Presenting for the new PASS Security Virtual Chapter on July 18

by Brian Kelley

Databases – Infrastructure – Security

The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...

2013-07-17

1,274 reads

Dealing with Auditors: Password Settings

by Brian Kelley

Databases – Infrastructure – Security

Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...

2013-06-19

8,263 reads

Update Your Audit Queries for SQL Server

by Brian Kelley

Databases – Infrastructure – Security

I was working with an auditor today who is working through a system with an external audit agency. The external...

2013-06-13

2,140 reads

Personally Identifiable Information (PII) and Data Encryption

by Brian Kelley

Databases – Infrastructure – Security

Hitting close to home, SC Governor Nikki Haley noted that after the SC Department of Revenue breach was reported, that the IRS didn't...

2013-06-07

5,091 reads

Why Anti-Virus Offers Limited Protection

by Brian Kelley

Databases – Infrastructure – Security

Sitting in the first Keynote for the 2013 Techno Security and Forensics Investigation Conference, I was not surprised to hear Kevin...

2013-06-06

1,500 reads

From the 2013 Techno Security Conference - Cloud Computing and Digital Forensics

by Brian Kelley

Databases – Infrastructure – Security

I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...

2013-06-05

1,168 reads

Notes from 2013 Techno Security Conference Tuesday Keynote

by Brian Kelley

Databases – Infrastructure – Security

There's enough from this morning's 2013 Techno Security and Forensics Investigation Conference to split into multiple blog posts. I'll focus this...

2013-06-04

1,162 reads

SQL Server security webinar series is coming soon!

by Brian Kelley

Databases – Infrastructure – Security

I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All...

2013-06-04 (first published: 2013-05-30)

2,547 reads

Blogs

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By Brian Kelley

Here is another short video (~ 15 minutes). This is by the author of...

A Fun Prize at the PASS Data Community Summit

I had a briefing for the 2026 PASS Data Community Summit, which is just...

Read the latest Blogs

Forums

BCA KCP Summarecon Mall Serpong Telp:0821°7555°651

Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...

Alamat BCA KCP ITC BSD Telp:0821°8200°203

Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...

Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233

By layanan_Bca88

Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers