FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Microsoft SQL Server 2000... has been added to your Basket
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Microsoft SQL Server 2000 DBA Survival Guide Paperback – 11 Oct 2002

4.3 out of 5 stars 16 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£36.50
£33.66 £5.51
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£36.50 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.




Product details

  • Paperback: 1032 pages
  • Publisher: Sams; 2 edition (11 Oct. 2002)
  • Language: English
  • ISBN-10: 0672324687
  • ISBN-13: 978-0672324680
  • Product Dimensions: 18.8 x 5.1 x 23.1 cm
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon Bestsellers Rank: 2,329,646 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.

About the Author

Mark Spenik is the vice president of Enterprise Technologies at Venturi Technology Partners located in Richmond, VA. Mark, a graduate of George Mason University in Fairfax, VA., entered the computer industry in 1985. He has designed and coded large-scale applications and has consulted with numerous firms in application development, implementation, and migration. He has a broad programming background, including assembly language, C, C++, HTML, Active Server Pages, and Visual Basic. Mark is a Microsoft Certified Solution Developer (MCSD) and charter member, and is frequently invited to speak at various developer conferences and seminars. Mark has also coauthored or contributed to several books on Microsoft SQL Server or Visual Basic. Mark can be reached via the Internet mspenik@venturipartners.com.

Orryn Sledge is a Practice Director with FullTilt in Pittsburgh, PA. He specializes in managing and developing large-scale eBusiness solutions. His background includes SQL Server, Microsoft's .NET platform, Plumtree, Oracle, and other popular eBusiness products. He has been actively involved with SQL Server consulting since 1992 and is a Microsoft Certified Solution Developer (MCSD). Orryn is also a frequent speaker at various Microsoft conferences and presentations. He can be reached at osledge@fulltilt.com.

Customer Reviews

4.3 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

By A Customer on 4 Jan. 2003
Format: Paperback
I have read this book cover to cover over the last month. It's pretty good really. If you've been working with SQL Server (7 or 2000) for any length of time it'll be mainly revision.
The main problem is the size of the subject, to try and cover everything in one book is brave and while I feel they make a fair job of it, you will need some additional digging to fill in all the details.
It is a very good starting point but needs to be supplemented with more detailed texts (books online for example).
Comment 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
A comprehensive guide to all aspects of SQL server which is clearly written in an accessible style. This book has helped me transfer my existing DBA skills in Informix/Ingres to SQL server. I liked the worked examples which help greatly in understanding key features such as backup and restore. One niggle is that the section covering master databse recovery omits the fact that the database must be in single user mode (sqlservr.exe -m). I can also recommend:- Microsoft SQL Server 7.0 Administrator's Pocket Consultant - Microsoft Press The Guru's Guide to Transact SQL - Henderson
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Although I have no particular problem with the book I was expecting more from it. Judging by the reviews it had received I was expecting in-depth technical detail. As far as I can tell this book is not much more than a summary or selection of the Books On Line documentation. Having said that it is probably a good start for someone new to SQL Server 7.0
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Unfortunately I cannot share excitement of those who gave this book 4,5 or 5 stars. This book is good but still contains some mixture of old and new information. For example on page 259 authors claim that "incomplete transactions that occur after database process is started are NOT backed up", this is not true. In SQL 7.0 manual stated "Extents containing data are written to the backup set without regard to synchronizing pages being modified by users during the backup". They don't even mention new "Fuzzy backup" technology (see "Fuzzy Backup and Restore Operations" in BOL). On page 260 Authors claim that "performing full database backup does not clear inactive part of transaction log" this is also not true. Page 272 "The database log must reside on separate device from database": first there is no such thing as "device" in SQL 7.0, second there is no way to put database and log on the same file. Looks like they didn't cleaned up 6.5 manuscript properly.
So, if you find something that does not supported by your practical experience, very likely you and not the authors are right.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book has saved my butt while I was having trouble during version 6.5-to-7 upgrading, ODBC Unicode and language headaches and while trying to understand proper application of transactional replication. The sections od database design are very good. As a DBA for a major Turkish user of SQL 7, this book is a good reference. I first look at it before calling online help. It lacks a bit on low-level details when compared to "Inside Microsoft SQL Server 7" by Soukup and Delaney. But, the language here is more business like rather than technical.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on 17 Mar. 1999
Format: Paperback
A great feature of this book is that each chapter begins with a summary of "what's new" in SQL 7 vrs 6.5. Also, each chapter concludes with a series of thought-provoking questions to summarize what was presented.
One of the few books of its kind you can actually read cover to cover and enjoy for the quality of writing as well as the good information.
Highly suggested for THE book to take you from 6.5 to 7.0
Thank you, Mark!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on 29 Jun. 1999
Format: Paperback
I have no experience at all with SQL and I was looking for book here and there and when I read through Mr. Mark's book I knew at that instant that this is the book I've been looking for. It helps me to understand from the basic to the utmost advanced one. This book also help me a lot in preparing for my SQL admin exams. It answer questions which we cannot find in other books. It's like a bible for every DBA. Bravo !!!!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on 24 Feb. 1999
Format: Paperback
As the previous editions, this is a required book for SQL 7 DBA's. It covers all the new features of SQL 7, describing what is different from SQL 6.5, with lots of practical examples. It has the best coverage of SQL 7 replication features I've seen. There are some mistakes, though, such as some illustrations from Beta versions. But it's very good overall.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse


Feedback