SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Regular Columnist: Brian Kelley

SQLServerCentral.com profile

Brian is currently an Enterprise Systems Architect with AgFirst Farm Credit Bank (http://www.agfirst.com) in Columbia, SC. Prior to that he served as a senior DBA and web developer with AgFirst. His primary responsibilities include overhauling the current Windows NT infrastructure to provide for a highly available, network-optimized framework that is Active Directory ready. Brian assumed his Architect role in December 2001.

He has been at AgFirst since January of 2000 when he originally came on-board as an Intranet web developer and database programmer.

In addition to his role at AgFirst Farm Credit Bank, Brian heads Warp Drive Design Ministries (http://www.warpdrivedesign.org), a Christian ministry devoted to using technology for encouraging Christians in their faith as well as presenting the Gospel in a non-confrontational manner. The main focus is an email devotional ministry currently being penned by Michael Bishop (mbishop@clemson.edu), a computer engineering student at Clemson University (http://www.clemson.edu).

Prior to AgFirst, Brian worked as a system administrator and web developer for BellSouth's Yellow Pages group and served on active duty as an officer with the US Air Force. He has been a columnist at SQL Server Central since July 2001.

Brian is the author of the eBook, Start to Finish Guide to SQL Server Performance Monitoring, on sale here at SQL Server Central: http://www.netimpress.com/shop/product.asp?ProductID=1


Certifications: Windows NT 4 MCSE (December 1999), Federal Acquisitions Communications-Computers Level I (May 1999)

   Items 1 to 20 of 35    Next 20 >>
 

A Review of Typhon III

Maintaining SQL Server security is fast becoming a big part of a SQL Server DBA's job. Longtime security expert Brian Kelley takes a look at a security scanner: Typhon III   Read more...
By Brian Kelley 2007/02/05 | Source: SQLServerCentral.com | Category: Product Reviews
Rating: |  Discuss |  Briefcase | 5,501 reads

SQL Server 2005 Logins

Security was a major focus of SQL Server 2005 during its development, both in terms of making the product secure as well as enhancing the options. Security expert Brian Kelley brings us a look at how the paradigm of logins has changed and what you need to look for in SQL Server 2005.   Read more...
By Brian Kelley 2008/04/11 (first posted: 2006/07/05) | Source: SQLServerCentral.com | Category: SQL Server 2005 - Security
Rating: |  Discuss |  Briefcase | 81,466 reads

PromptSQL Review

Do you want intellisense for Query Analyzer? Many people would love this amazing enhancement that has long been available for Visual Studio users. It is now available as an add-in from PromptSQL and Brian Kelley reviews this amazing product.   Read more...
By Brian Kelley 2006/01/18 | Source: SQLServerCentral.com | Category: Product Reviews
Rating: |  Discuss |  Briefcase | 9,946 reads

Securing SQL Backups

SQL Server does many things very well, but securing itself is not one of them. While securing your server requires some effort, there is an area that many people forget. Securing your backups! Brian Kelley, our resident security expert, brings some advice and ideas for ensuring your data will not be stolen.   Read more...
By Brian Kelley 2005/03/21 | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 8,271 reads

Review - Apex SQL Edit

SQL Server includes Query Analyzer as a client editing tool for T-SQL code. It's a great tool, but it does have a number of shortcomings. Apex SQL has released an editor that includes a number of features missing in Query Analyzer. Read this review by Brian Kelley.   Read more...
By Brian Kelley 2004/11/08 | Source: SQLServerCentral.com | Category: Product Reviews
Rating: |  Discuss |  Briefcase | 7,259 reads

PASS Summit 2004

Our resident SQL Server security expert, Brian Kelley, went with the SQLServerCentral.com crew to the 2004 PASS Summit in Orlando last month. He was kind enough to jot down a few notes on the conference for those of you that weren't there and are considering going next year.   Read more...
By Brian Kelley 2004/10/12 | Source: SQLServerCentral.com | Category: SQLServerCentral.com
Rating: |  Discuss |  Briefcase | 4,113 reads

Review: Typhon III from NGSSoftware

Every shop with any sort of IT organization should be scanning for vulnerabilities and issues with their systems and SQL Server is no exception. Security software vendor has a tool that can scan and report on all your SQL Servers is an easy to use product called Typhon III. Our security expert Brian Kelley takes a look at this product.   Read more...
By Brian Kelley 2004/10/07 | Source: SQLServerCentral.com | Category: Product Reviews
Rating: |  Discuss |  Briefcase | 13,759 reads

Auditing with SQL Profiler

SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.   Read more...
By Brian Kelley 2007/04/20 (first posted: 2004/09/01) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 27,036 reads

SQL Server Auditing - Part 1

Our SQL Server Security expert, Brian Kelley, brings us the first part of a new series on auditing. Most of the auditing articles we've had are based on how you audit changes to data. Brian looks at auditing from the server itself, explaining the different levels of auditing built into SQL Server 2000.   Read more...
By Brian Kelley 2007/06/01 (first posted: 2004/08/05) | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 27,052 reads

SQL Server Security: Dealing with Anti-Virus Programs

Do you run an anti-virus product on your SQL Servers? After all, it's recommended, more and more, that you run anti-virus on ALL machines you have. There's just too much stuff running around out there. But putting this on a SQL Server creates some interesting issues. Our resident security guru, Brian Kelley, looks at some of the things you need to consider when deploying anti-virus products on your servers.   Read more...
By Brian Kelley 2004/05/13 | Source: SQLServerCentral.com
Rating: |  Discuss |  Briefcase | 18,347 reads

Review of SQL2K Resource Kit

Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.   Read more...
By Brian Kelley 2004/04/13 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 8,521 reads

Review of ApexSQL Log

Brian has been busy lately helping us with content for our magazine (you have checked out www.sqlserverstandard.com haven't you?) but he's back this week with a great write up a new product that let's you read from the transaction log.   Read more...
By Brian Kelley 2004/02/18 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 9,545 reads

SQL Server Security: Fixed Database Roles

Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.   Read more...
By Brian Kelley 2007/01/19 (first posted: 2003/12/12) | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 41,209 reads

SQL Server Security: Server Roles

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.   Read more...
By Brian Kelley 2007/05/04 (first posted: 2003/10/29) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 32,754 reads

SQL Server Security: Pros and Cons of Application Roles

Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.   Read more...
By Brian Kelley 2008/07/25 (first posted: 2003/08/27) | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 24,161 reads

SQL Server Security: Login Weaknesses

Brian writes regularly for us on sql security issues, this week he discusses the pros and cons of various authentication methods.   Read more...
By Brian Kelley 2003/08/14 | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 13,369 reads

SQL Server Security: Why Security Is Important

Regular columnist Brian Kelley reviews the real world impact that inadequate security can have by reviewing some recent incidents in the sql/security world. Very much worth reading, especially if you have credit card data.   Read more...
By Brian Kelley 2003/07/31 | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 6,571 reads

SQL Server Security: Security Admins

As we mentioned before, Brian will be writing a column covering all facets of security. Turns out that there is so much to cover, he has agreed to write two columns per month! This article talks about the principle least privilege, why it doesn't always work, and some good info about removing the Builtin\Admin account.   Read more...
By Brian Kelley 2003/06/27 | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 17,018 reads

SQL Server Security: The db_executor Role

Brian will be writing a monthly column for us on SQL Security, definitely a hot topic these days! He starts off by discussing the need for a built in db_executor role and how to grant permissions manually to achieve the same effect. Terrific concept, as granting table access can lead to bad things! If there is a security topic you'd like to see more info on, post a note to the article or email us at articles@sqlservercentral.com.   Read more...
By Brian Kelley 2003/05/16 | Source: SQLServerCentral.com | Category: Security
Rating: |  Discuss |  Briefcase | 17,378 reads

Getting Certified

Brian spends a lot of time in our forums helping out. Based on a recent question from a reader he put together some tips he used when he was preparing for the MCSE exams. Interesting reading!   Read more...
By Brian Kelley 2003/04/30 | Source: SQLServerCentral.com | Category: Certifications
Rating: |  Discuss |  Briefcase | 9,392 reads
   Items 1 to 20 of 35    Next 20 >>