The Handbook for Reluctant Database Administrators / Edition 1

Paperback (Print)
Buy New
Buy New from BN.com
$38.07
Used and New from Other Sellers
Used and New from Other Sellers
from $23.08
Usually ships in 1-2 business days
(Save 53%)
Other sellers (Paperback)
  • All (14) from $23.08   
  • New (8) from $28.71   
  • Used (6) from $23.08   

Overview

Feeling reluctant? The Handbook for Reluctant Database Administrators provides you witha solid grasp of what you'll need to design, build, secure, and maintain a database. Author Josef Finsel writes from an understanding point of view; he also crossed over from programming to database administration. Furthermore,database administrationveteran Francis Stanisci comments throughout the book, sharing insight from his own years of experience.

Read More Show Less

Product Details

  • ISBN-13: 9781893115903
  • Publisher: Apress
  • Publication date: 9/27/2001
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 550
  • Sales rank: 1433899
  • Product dimensions: 9.25 (w) x 7.50 (h) x 1.17 (d)

Meet the Author

Josef Finsel is a software consultant specializing in .NET and SQL Server. He has published a number of Visual Basic, .NET, and SQL Server-related articles and is the Q&A columnist for asp.netNOW, the e-newsletter for asp.netPRO magazine. When not working for clients, he works out the syntax for FizzBin.net, a programming language that works the way programmers have always suspected a programming language should.
Read More Show Less

Table of Contents

Bios
Acknowledgments
Foreword
Introduction
Ch. 1 Where Did Databases Come From? 1
Ch. 2 How Do I Install SQL Server? 15
Ch. 3 How Do I Visually Manage Objects? 29
Ch. 4 How Do I Back Up and Restore My Data? 69
Ch. 5 How Do I Define and Structure a Database? 93
Ch. 6 What Is a View? 147
Ch. 7 The Power of Indexing 173
Ch. 8 Introduction to Query Analyzer 201
Ch. 9 Working with Data: Basic Stored Procedures 237
Ch. 10 Working with Data: Beyond the Basics 269
Ch. 11 How Do I Secure My Data? 303
Ch. 12 How Can SQL Server Agent Make Life Easier? 331
Ch. 13 If SQL Server 2000 Is a .NET Server, Where's the XML? 357
Ch. 14 What Are the Data Transformation Services (DTS)? 397
Ch. 15 Should I Bother to Learn SQL Profiler? 433
Ch. 16 What Are System Monitor and Performance Monitor? 461
Ch. 17 What a Reluctant DBA Needs to Know about .NET 493
Last Words: Does Reading This Book Make Me a DBA? 501
App. A How Do I Load the Examples? 503
App. B How Can I Find Information More Efficiently? 505
App. C Recommended for the Bookshelf 513
App. D Bulk Copy Program 517
Glossary 523
Index 531
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted Mon Oct 22 00:00:00 EDT 2001

    The Author speaks

    Whether you are a programmer who is now responsible for creating and maintaining a SQL Server database or someone who wants to understand the basics of database administration, this book is for you. Reluctant DBAs are those of us who haven't had formal training in administering a database and are surviving on a combination of our wits, Books Online and technical manuals. The biggest problem with Books Online and most tech manuals is they assume prior knowledge. This book, on the other hand, is designed for the programmer who has to handle database administration in addition to normal programming duties. It doesn't go into all of the arcane detail that some of the other books do. Instead, it gives you the knowledge you need to do your job and points you to where you can get more information if you're interested. And many of the headings are in the form of questions, making it easy to scan the table of contents to find the answer you need quickly and easily. In addition, the book comes with easy to use examples that build throughout the book. These examples explain everything from properly normalizing a database to the real reason for building error handling into your stored procedures, all written in a manner that relates back to my roots as a programmer. You can download a sample chapter from the book's supporting website.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)