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

Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases

by Brian Kelley

Databases – Infrastructure – Security

Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...

2007-11-07

778 reads

SQL Server: Showing permissions for a given database user

by Brian Kelley

Databases – Infrastructure – Security

Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...

2007-11-06

602 reads

Becoming a DBA, Part II

by Brian Kelley

Databases – Infrastructure – Security

This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...

2007-11-05

907 reads

The Impact of Architecture/Design Choices

by Brian Kelley

Databases – Infrastructure – Security

I try my best to get things right the first time. So often, correcting a mistake or bad choice is...

2007-11-05

667 reads

Online Resource: Safari Tech Books Online

by Brian Kelley

Databases – Infrastructure – Security

I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...

2007-11-02

850 reads

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

by Brian Kelley

SQLServerCentral.com

Administration

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.