- Paperback: 480 pages
- Publisher: Prentice Hall; 1 edition (16 Oct 2001)
- Language English
- ISBN-10: 0130614300
- ISBN-13: 978-0130614308
- Product Dimensions: 23.7 x 17.8 x 2.6 cm
- Average Customer Review: 1.0 out of 5 stars See all reviews (1 customer review)
- Amazon Bestsellers Rank: 4,975,552 in Books (See Top 100 in Books)
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
This isn't just a start-to-finish guide to Microsoft SQL Server database administration: it's a practical guide for those migrating from Oracle or Sybase -- and an indispensable resource for managers who must hire and supervise SQL Server DBAs. Carl H. Speshock covers every DBA skill required to create robust, secure, and highly available SQL Server environments. Among the technical topics covered: applying service packs; optimizing performance, security, and availability; backup/disaster recovery planning; monitoring using system and third-party tools; OLAP administration; data modeling; clustering; quality assurance; and more. Unlike many introductory DBA books, this one doesn't just cover core technical skills: it helps DBAs with all their responsibilities, including communication and coordination with developers and business professionals throughout the enterprise. It also offers managers specific guidance on hiring effective SQL Server DBAs -- including comparisons of the skillsets needed by SQL Server, Oracle and Sybase DBAs, and 50 questions to ask every candidate. For all beginning-to-intermediate level Microsoft SQL Server DBAs; for Oracle and Sybase DBAs who want to cross-train on Microsoft SQL Server administration; and for database managers, DBA recruiters, and project managers who hire or supervise SQL Server DBAs.
From the Back Cover
Microsoft SQL Server 2000 Database Administrators Guidebook is a start-to-finish guide to every technical and business skill DBAs need to maximize SQL Server performance, security, and scalability. Coverage includes planning, design, installation, optimization, automation, clustering, technical writing, data modeling, and more. Also included: practical help for DBAs migrating from Oracle or Sybase - plus expert guidance for managers who hire DBAs. The CD-ROM includes an extensive library of support documents and scripts.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
Format:Paperback
The best source of SQL Server information is Books Online, Microsoft's own product documentation. If you're buying books, you're usually looking for either
- an accelerated introduction, because you haven't got time to distill the manuals yourself, or
- tips, tricks and advanced techniques: the stuff that just isn't in the manuals.
- an accelerated introduction, because you haven't got time to distill the manuals yourself, or
- tips, tricks and advanced techniques: the stuff that just isn't in the manuals.
This book fulfills neither need. Granted, most of the major SQL Server functional areas have a chapter, but these are mostly screenshots and lists of the type: 'the features of X are Y' - and the explanation of Y is usually minimal. For example (p74):
'The options for the Server Settings tab are further defined below
...
...
Allow modifications to be made directly to the system catalogs - allows modifications to be made directly to the system catalogs.
...
...
...
'
What value does this give?
The final section does attempt a different approach, dealing with the behaviours, characteristics of a SQL Server DBA. Perhaps if you are genuinely new to SQL Server, or perhaps have taken on a new managerial role which involves DBAs, this section may be useful. To me, it's stating the obvious.
I'm an Oracle DBA by training, and wanted an accelerated primer on SQL Server. If you're in my position, I'd recommend spending money elsewhere - even (gulp) on the pretty good Microsoft Press books.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
21 reviews
25 of 26 people found the following review helpful
Great book on SQL Server 2000 and the DBA role
27 April 2002
Format:Paperback
This is a very informative book that I consult with on a daily basis. The book exceeded my expectations! Before it came out, I could not find a book that completely defined the SQL Server DBA role, many just discussed the technology. This book goes over the SQL Server technology very well and contains extra chapters that discuss secondary, and important, responsibilites that a SQL Server DBA must perform with profiency. The book is written with much level of detail to assist me in finding a solution. The Designing a Database server chapter was extremely helpful for me to get my point across to the System Admins on what a database server needs to be a productive system by covering hardware considerations such as RAID controllers, file system, drive storage, memory and more.
The code samples in the book and the extra samples on the CD are excellent and are very helpful. The included CDROM is exceptional and definitely one of a kind. Many included CDROMs in technical books are useless. This book has a very productive and effective CDROM. It was definitely written by a DBA who works in the field and nows what he needs to have around for reference. The documents on the CDROM are effective templates to create DBA support documents. WOW!!!!
25 of 26 people found the following review helpful
An outstanding and very productive DBA guidebook!
20 April 2002
Format:Paperback
I am a DBA Manager and have purchased and read this book with much satisfaction. The book has been thought out and reads very well. The use of bullets throughout the book allows my DBAs to get to the information quickly without fumbly through alot of text. I am excited about the chapters that go beyond understanding SQL Server technology (which the book does a great job going ove: Backups and Restores, OLTP, Capacity Planning, OLAP, and much more) and help a DBA understand and better themselves in their role. I am talking about the Data Modeling, Technical Writing, Verbal/oral communication chapters. The chapters in the book that go over Oracle and Sybase Databases migrations to SQL Server have helped us tremendously during our Oracle to SQL Server Data Warehouse projects. The included CDROM is exceptional. I have not seen any CDROM like this included in any books before. It is a CDROM that my DBAs access and use on a daily basis. It helps many DBA support documents (for inventorying servers, creating a backup and disaster recovery plan, drawings that define SQL Server hardware configurations for Database servers, and much more) that have assisted me in my daily tasks.
I have purchased 5 additional copies for each DBA on my team and will suggest this to other SQL Server DBA Managers.
I have purchased 5 additional copies for each DBA on my team and will suggest this to other SQL Server DBA Managers.
I can definitely tell that this book was written by a DBA who has much interest in his work and the SQL Server DBA role.
I highly recommend purchasing this book!!
24 of 25 people found the following review helpful
Book was well written. Book and CDROM are VERY USEFUL!!
20 April 2002
Format:Paperback
Book was well written and contains many valuable sections that define a SQL Server DBA role in a detailed manner. The book contains many additional and crucial chapters not found in a typical SQL Server DBA book (i.e. technical writing, data modeling, Oracle and Sybase Migrations) that are needed to be a well-rounded DBA. The included CDROM is awesome!! It contains many sample scripts and support document templates that can be used every day on the job. It is a CDROM that I carry with me at all times.
I would strongly recommend buying this book!! Great job!!
I would strongly recommend buying this book!! Great job!!
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
