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

SQL University Starting Back Up

by Brian Kelley

Databases – Infrastructure – Security

Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...

2010-04-08

748 reads

New MSSQLTips Article: Nesting Database Roles in SQL Server

by Brian Kelley

Databases – Infrastructure – Security

I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...

2010-04-07

1,682 reads

What I Do to Prep a Technical Presentation

by Brian Kelley

Databases – Infrastructure – Security

This was a question asked on Twitter the other day, "How do folks prepare for a presentation?" Here are some...

2010-04-06

805 reads

So you want to write a blog?

by Brian Kelley

Databases – Infrastructure – Security

First, figure out what you want to write about. It should be something you have passion for. And it should...

2010-03-27

1,543 reads

Learning About Microsoft Certified Master: SQL Server

by Brian Kelley

Databases – Infrastructure – Security

Among the Microsoft certifications, the Microsoft Certified Master is the apex of all of them except maybe the Microsoft Certified...

2010-03-26

1,680 reads

SQL Saturday - Columbia

by Brian Kelley

Databases – Infrastructure – Security

I've talked about trying to do a SQL Saturday event in Columbia, SC, for the last couple of years, ever...

2010-03-26

686 reads

Have a Question? Use the Forums

by Brian Kelley

Databases – Infrastructure – Security

I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...

2010-03-25

538 reads

Avoiding Plagiarism

by Brian Kelley

Databases – Infrastructure – Security

Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...

2010-03-24

1,931 reads

Don't Throw Something New In At Production Deployment

by Brian Kelley

Databases – Infrastructure – Security

This post comes from a conversation I had with a developer last week as well as my experiences over the...

2010-03-22

1,824 reads

When It "Has" to Use SA...

by Brian Kelley

Databases – Infrastructure – Security

As an infrastructure and security architect, I cringe any time any one mentions the following:
Domain AdminrootsaThose accounts can do anything...

2010-03-19

652 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