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

SC Midlands Chapter of ISACA - SQL Server Auditing Course Materials

by Brian Kelley

Databases – Infrastructure – Security

If you attended my SQL Server Auditing course held for the SC Midlands Chapter of ISACA, I finally was able...

2012-03-09

1,334 reads

T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

by Brian Kelley

Databases – Infrastructure – Security

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?

Being a specialist means you're...

2012-03-06

1,231 reads

Speaking at oPASS on March 8th

by Brian Kelley

Databases – Infrastructure – Security

I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...

2012-03-01

1,034 reads

New Article: Exploiting SQL Server via CONTROL SERVER permissions

by Brian Kelley

Databases – Infrastructure – Security

I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...

2012-02-27

1,743 reads

Presenting Two Sessions at SQLRally

by Brian Kelley

Databases – Infrastructure – Security

I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....

2012-02-27

985 reads

A Plea: Have your guidance documentation reviewed

by Brian Kelley

Databases – Infrastructure – Security

Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...

2012-02-23

1,235 reads

Two Sessions Up for Vote at SQLRally!

by Brian Kelley

Databases – Infrastructure – Security

I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...

2012-02-21

867 reads

USB/Flash Drive Security

by Brian Kelley

Databases – Infrastructure – Security

Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...

2012-02-15 (first published: 2012-02-13)

2,217 reads

See You at SQL Saturday!

by Brian Kelley

Databases – Infrastructure – Security

I've been asked this question a few times, and Columbia, SC isn't hosting a SQL Saturday this year. Bobby Dimmick...

2012-02-13

1,183 reads

Discuss

Slides and Scripts from Idera February webcast

by Brian Kelley

Databases – Infrastructure – Security

For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:

Presentation (.PDF)Scripts (.ZIP)
If...

2012-02-10

1,051 reads

Discuss

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

MERGE in a nested TRY/CATCH won't roll back

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

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