Windows 2000 Professional Certification Exam for Executives

• by Steve Jones

• SQLServerCentral.com

Give this test to your boss...only if he has a sense of humor!

What's a DBA? - An Overview

• by Steve Jones

• SQLServerCentral.com

• Miscellaneous

Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here's an overview of what a DBA does. Reader feedback will be used to update this article over time.

The Self-Taught DBA

• by Additional Articles

• Other

• Miscellaneous

Are you thinking of becoming a master DBA? If so, find out how you can in this article.

An Interview with Louis Davidson

• by Jon Winer

• SQLServerCentral.com

• Miscellaneous

Want to learn more about some of your favorite authors. Check out this interview with Louis Davidson, author of Professional SQL Server 2000 Database Design.

Installation Problems in SQL Server 7.0

• by Alexander Chigrik

• SQLServerCentral.com

• Installation

This article examines some of the common issues that may occur when installing SQL Server 7.0

Aggregating a Set of Hierachical Records

• by Les Smith

• SQLServerCentral.com

A great deal of data in any RDBMS is hierarchial. This article presents a technique for aggregating this data.

Review: Log Explorer 2.1

• by Steve Jones

• SQLServerCentral.com

• Product and Book Reviews

Lumigent has updated their transaction log analysis tool to include a number of features that every DBA will find handy. Read this review of a great new product.

Strategies for Backing Up and Restoring Transactional Replication

• by Additional Articles

• Microsoft MSDN

• Replication

Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.

Design Oversight - Preliminary Review

• by Brian Kelley

• SQLServerCentral.com

• Administration

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.

That's the nicest thing I've heard him called

• by Steve Jones

• SQLServerCentral.com

• The Lighter Side

Poor Dub-ya