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

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

638 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

690 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,144 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...