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

Setting Realistic Goals & Learning to Adjust

by Brian Kelley

Databases – Infrastructure – Security

There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...

2009-08-31

2,037 reads

Quick 2005/2008 Script to Export Permissions

by Brian Kelley

Databases – Infrastructure – Security

I had a need to export permissions to be run against the database once an older version was restored (but which didn't...

2009-08-28

13,587 reads

PASS Board of Directors Call for Nominations

by Brian Kelley

Databases – Infrastructure – Security

This is just a reminder that the call for nominations for the PASS Boards of Directors is open. The final...

2009-08-24

937 reads

The Need for a College Degree

by Brian Kelley

Databases – Infrastructure – Security

I'm reading through Brad McGehee'sHow to Be an Exceptional DBAand in chapter 4 he talks about having the right skill...

2009-08-24

2,433 reads

Keeping SQL Server Client Tools Up-to-Date

by Brian Kelley

Databases – Infrastructure – Security

In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...

2009-08-21

1,421 reads

Half-Way Through My Year as a Microsoft MVP

by Brian Kelley

Databases – Infrastructure – Security

I meant to write this earlier, like in July, but I suppose it's better late than never. I'm halfway through...

2009-08-18

1,318 reads

SQL Quiz #5

by Brian Kelley

Databases – Infrastructure – Security

Another SQL Quiz started by His Evilness, Chris Shaw. Okay, Chris isn't evil; I just wanted to say "evilness" and these quizzes...

2009-08-17

2,591 reads

"Just smile and wave, boys. Smile and wave."

by Brian Kelley

Databases – Infrastructure – Security

If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...

2009-08-13

13,953 reads

Getting Security Vulnerability Information

by Brian Kelley

Databases – Infrastructure – Security

Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...

2009-08-12

1,165 reads

Security is a Zero-Sum Game...

by Brian Kelley

Databases – Infrastructure – Security

but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...

2009-08-11

711 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

Perfermance result aftet purge operatio

By abdalah.mehdoini

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

10 Reasons the 2CT Engagement Ring Is the Most Popular Proposal Choice Right Now

By bellarose124578

Walk into any jewelry consultation these days and you’ll hear a familiar request: “Something...

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