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

All authors

SQL Server Security Basics: Logins vs. Users

by Brian Kelley

Databases – Infrastructure – Security

When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...

2009-04-21

22,738 reads

Security Basics - The C-I-A Triad

by Brian Kelley

Databases – Infrastructure – Security

In the course of giving my security presentations over the past year, I've learned that quite a few folks have...

2009-04-20

9,095 reads

Getting Started with Technical Presentations

by Brian Kelley

Databases – Infrastructure – Security

I was talking with a gentleman last night after the Greater Charleston .NET User Group about career development. He's not...

2009-04-17

788 reads

It's a .NET World!

by Brian Kelley

Databases – Infrastructure – Security

Next week I'll be giving presentations in Charleston and in Florence here in South Carolina.
Tuesday, April 14, 2009 - Pee Dee...

2009-04-07

635 reads

Midlands PASS Meeting Tonight!

by Brian Kelley

Databases – Infrastructure – Security

Next Meeting - April 2, 2009
SPEAKER:Paul S. Waters
During Paul’s 16 years of working in IT, he has held a variety of...

2009-04-02

688 reads

SQL Server Authentication Modes and Surface Area Test

by Brian Kelley

Databases – Infrastructure – Security

One of the videos I did for JumpStart TV is up on the front page:
SQL Server Authentication Modes
It is an...

2009-03-16

1,138 reads

CONTROL SERVER vs. sysadmin membership

by Brian Kelley

SQLServerCentral.com

Blogs

In a previous blog post on Detecting When a Login Has Implicit Access to a Database, I mentioned that having CONTROL SERVER rights means having implicit rights into the databases. Robert Davis posted a comment asking if there was a difference with respect to explicit permissions between being a member of the sysadmin fixed server role and having CONTROL SERVER rights.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-03-16

3,550 reads

[Off-Topic] Eleven Year-Old Making a Difference

by Brian Kelley

SQLServerCentral.com

Blogs

Those who know me personally know that I grow my hair out to donate for kids. I have donated a couple of times to Locks of Love . This past Saturday I participated in a hair collection drive led by 11 year-old Sarah Brotman: Midlands girl gets a haircut...