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

SQLRally 2012 - Dallas Registration Is Open!

by Brian Kelley

Databases – Infrastructure – Security

Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price...

2011-11-30

2,042 reads

No SQL Saturday - Columbia, SC in 2012

by Brian Kelley

Databases – Infrastructure – Security

Last week my partner in crime, Bobby Dimmick (blog | twitter) and I sat down for lunch and caught up and...

2011-11-14

1,677 reads

SQL Server security webinar now available on-demand

by Brian Kelley

Databases – Infrastructure – Security

Last week I was able to give a SQL Server security webinar with Quest Software and SQL Server MVP Kevin...

2011-11-08

1,171 reads

Meme Monday: #SQLFamily

by Brian Kelley

Databases – Infrastructure – Security

Tom asks what #SQLFamily means to me. This is a hard one, not because of what #SQLFamily does for me,...

2011-11-07

1,735 reads

Presenting Tomorrow (Thursday) via Webinar - SQL Server Security

by Brian Kelley

Databases – Infrastructure – Security

I have the privilege of being able to give a webinar tomorrow, November 3, at 11 AM EDT. It will...

2011-11-02

1,090 reads

Understanding Kerberos, Part III

by Brian Kelley

Databases – Infrastructure – Security

Welcome back to both our Kerberos coverage and to another topic for SQL University's Security and Auditing Week. In today's...

2011-10-28

16,893 reads

Webinar on SQL Server Security on November 3, 2011

by Brian Kelley

Databases – Infrastructure – Security

I have the privilege of being able to give a webinar next Thursday, November 3, at 11 AM EDT. It...

2011-10-28

1,012 reads

SQL University: SQL Agent Jobs That Run at SQL Agent Start

by Brian Kelley

Databases – Infrastructure – Security

Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...

2011-10-27

2,969 reads

Understanding Kerberos, Part II

by Brian Kelley

Databases – Infrastructure – Security

The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...

2011-10-18

4,079 reads

Understanding Kerberos, Part I

by Brian Kelley

Databases – Infrastructure – Security

A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...

2011-10-17

4,395 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

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