Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

<< Previous 20    Items 21 to 40 of 42    Next 20 >>
 

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 published: 2003/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 53,583 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 published: 2003/08/27) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 39,110 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 | 17,207 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 | 7,047 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 | 20,505 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 | 24,620 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,800 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,966 reads

Implementing Encrypting File System (EFS) with SQL Server

EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.   Read more...
By Brian Kelley 2006/12/01 (first published: 2002/12/09) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,798 reads

Connecting With Perl Using Win32 : ODBC

Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.   Read more...
By Brian Kelley 2006/07/28 (first published: 2002/12/03) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 39,552 reads

Sneak Preview: Start to Finish Guide to SQL Server Performance Monitor

Get a sneak peak of some of the sections from Start to Finish Guide to SQL Server Performance Monitor. Find out what counters to watch and what their thresholds are.   Read more...
By Brian Kelley 2002/08/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,159 reads

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

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.   Read more...
By Brian Kelley 2005/01/07 (first published: 2002/08/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,683 reads

Citrix MetaFrame, SQL Server, and the DBA

In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.   Read more...
By Brian Kelley 2007/03/02 (first published: 2002/05/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 26,382 reads

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

Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers.   Read more...
By Brian Kelley 2004/12/31 (first published: 2002/03/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,614 reads

Getting the Most out of SQL Server 2000's Query Analyzer, Part I

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.   Read more...
By Brian Kelley 2004/12/23 (first published: 2002/02/21) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,567 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,389 reads

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.   Read more...
By Brian Kelley 2003/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,057 reads

Information Schema Views

SQL Server DBAs are often curious about the inner-workings of SQL Server. Indeed, it can save your job during disasters to know what's going on inside SQL Server. This article shows you how to use some of the SQL Server internal views to view some meta data about your servers.   Read more...
By Brian Kelley 2002/01/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,110 reads

Services for SQL Server 2000

In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.   Read more...
By Brian Kelley 2006/05/12 (first published: 2002/01/03) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 49,859 reads

Triggers in SQL Server 7.0 and 2000 - What's New

This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.   Read more...
By Brian Kelley 2005/06/24 (first published: 2001/09/03) | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 72,572 reads
<< Previous 20    Items 21 to 40 of 42    Next 20 >>