Skip to main content
  • Book
  • © 2004

Beginning SQL Server 2000 DBA

From Novice to Professional

Apress

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xiii
  2. Being a DBA

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 1-19
  3. SQL Server Installation

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 21-92
  4. Creating a Database

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 93-146
  5. DML and Querying

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 147-190
  6. Basic Management Tasks

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 191-230
  7. Security

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 231-290
  8. Connectivity

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 291-330
  9. Backup and Recovery

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 331-399
  10. Replication

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 401-468
  11. Development with Transact-SQL

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 469-532
  12. Data Warehousing and Analysis

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 533-568
  13. Data Transformation Services

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 569-600
  14. Monitor, Profile, and Tune

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 601-623
  15. Keeping the Plates Spinning

    • Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
    Pages 625-651
  16. Back Matter

    Pages 653-682

About this book

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.

About the authors

Baya Pavliashvili is senior database administrator possessing extensive development experience with the latest client/server and web technologies, as well as Visual Studio .NET. He has in-depth knowledge of and demonstrated experience with Microsoft SQL Server database administration, and he specializes in systems and business analysis, logical and physical database design, database administration, replication, data warehousing and OLAP, query optimization, application performance tuning, and database programming. He is also experienced in systems integration, software testing, implementation, support, and training. Pavliashvili is a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Systems Engineer (MCSE). He is the coauthor of .NET E-Business Architecture and Knowledge Expert for SQL Server, and he contributed to SQL Server Security Distilled.

Bibliographic Information

  • Book Title: Beginning SQL Server 2000 DBA

  • Book Subtitle: From Novice to Professional

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

  • DOI: https://doi.org/10.1007/978-1-4302-0703-0

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Baya Pavliashvili and Michael Benkovich and Tony Bain and Brian Freeman and Joseph Sack 2004

  • Softcover ISBN: 978-1-59059-293-9Published: 08 January 2004

  • eBook ISBN: 978-1-4302-0703-0Published: 01 January 2008

  • Edition Number: 1

  • Number of Pages: XIII, 696

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access