Advertisement

Beginning SQL Server 2000 DBA: From Novice to Professional

  • Authors
  • Tony Bain
  • Baya Pavliashvili
  • Joseph Sack
  • Michael Benkovich
  • Brian Freeman

Table of contents

  1. Front Matter
    Pages i-xiii
  2. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 1-19
  3. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 21-92
  4. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 93-146
  5. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 147-190
  6. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 191-230
  7. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 231-290
  8. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 291-330
  9. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 331-399
  10. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 401-468
  11. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 469-532
  12. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 533-568
  13. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 569-600
  14. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 601-623
  15. Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 625-651
  16. Back Matter
    Pages 653-682

About this book

Introduction

SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularity—anyone, not just database administrators, can use a SQL Server database.

This book recognizes that aspiring database administrators need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. Aspiring database administrators can benefit from the direction and advice of an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective database administrators. In essence, this book is that "mentor," which is what sets it apart from the other books on the market that only present feature overviews.

Database novices will learn the core job and roles involved in administering a SQL Server database. You'll follow the life cycle of the database from installation, design, and modeling through to development, tuning, and securing, and onto growth and migration. This comprehensive guide provides practical advice, answers typical questions that you'll encounter from managers and developers, and offers practical steps to overcome issues with which new database administrators traditionally struggle.

At every stage of the life cycle, this book supplies a range of tried-and-tested practices and techniques that will help you to establish and maintain a healthy database system.

Keywords

SQL SQL Server 2000 T-SQL Windows data warehouse database system design development modeling relational database

Bibliographic information