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

You Must Trust Your DBAs

by Brian Kelley

Databases – Infrastructure – Security

This is a follow-on post to You Must Trust Someone. My point in that post was to establish that being...

2009-02-20

1,945 reads

Another Reason to Avoid Cross-Database Ownership Chaining

by Brian Kelley

SQLServerCentral.com

Blogs

This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We went at the old tried and true way, we detached the databases, moved the files, and re-attached the databases. That seemed to work well...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-20

2,133 reads

Discuss

The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)

by Brian Kelley

Databases – Infrastructure – Security

This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...

2009-02-18

4,092 reads

Another Reason to Avoid Cross-Database Ownership Chaining

by Brian Kelley

Databases – Infrastructure – Security

This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...

2009-02-13

2,155 reads

Counterpoint: Against Specialization

by Brian Kelley

Databases – Infrastructure – Security

Brent Ozar wrote his Things you know now and in it he says this under his first point, Pick one...

2009-02-11

2,226 reads

New Security Bulletin for SQL Server 2000/2005 (MS09-004)

by Brian Kelley

Databases – Infrastructure – Security

Affected Versions:
SQL Server 2000 SP4SQL Server 2005 SP2Unaffected Versions:
SQL Server 2005 SP3 SQL Server 2008Original Vulnerability Report:http://www.securityfocus.com/archive/1/archive/1/499042/100/0/threaded
Microsoft Security Bulletin Link:http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx
Brief Analysis:
The...

2009-02-11

889 reads

Things you know now...

by Brian Kelley

Databases – Infrastructure – Security

This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I...

2009-02-10

1,264 reads

Speaking / Teaching Engagements

by Brian Kelley

SQLServerCentral.com

Blogs

I should have put this out earlier, before going to the SQL Server Innovators Guild , but I got too busy. Here are my current speaking / teaching engagements for the first half of the year: