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

Veterans' Day

by Brian Kelley

Databases – Infrastructure – Security

I'll post Part III of Becoming a DBA tomorrow (meaning there will be two posts). Veterans' Day is typically celebrated...

2007-11-12

612 reads

Resources: SQL Server 2005 Security

by Brian Kelley

Databases – Infrastructure – Security

Work responsibilities took up my time on Thursday and Friday, so I never got around to posting. Here's the resources...

2007-11-11

618 reads

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

784 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

607 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

908 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

671 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

855 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.