Beginning SQL Server 2000 Dba: From Novice to Professional
by Bain, Tony; Benkovich, Michael; Freeman, Brian; Pavliashvili, Baya; Sack, Joseph; Bain, TonyFormat: Paperback
Pub. Date: 2004-01-01
Publisher(s): Springer-Verlag New York Inc
Other versions by this Author
List Price: $49.99
Buy New
Usually Ships in 2-3 Business Days
$49.49
Rent Book
Select for Price
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
The book teaches a database novice the core job and roles involved in administering a SQL Server database. It follows the lifecycle of the database, from installation, design and modeling, through development, tuning and securing to growth and migration. It provides practical advice ("How to..."), answers typical questions that they'll encounter from managers and developers ("How do I..."), and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that will establish and maintain the health of a DB system ("How to be a good DBA").
Table of Contents
| Introduction | |
| Being a DBA | p. 1 |
| SQL Server Installation | p. 21 |
| Creating a Database | p. 93 |
| DML and Querying | p. 147 |
| Basic Management Tasks | p. 191 |
| Security | p. 231 |
| Connectivity | p. 291 |
| Backup and Recovery | p. 331 |
| Replication | p. 401 |
| Development with Transact-SQL | p. 469 |
| Data Warehousing and Analysis | p. 533 |
| Data Transformation Services | p. 569 |
| Monitor, Profile, and Tune | p. 601 |
| Keeping the Plates Spinning | p. 625 |
| Index | p. 653 |
| Table of Contents provided by Blackwell. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.