Microsoft SQL Server 2000 Unleashed [Paperback]

Ray Rankins (Author), Paul Jensen (Author), Paul Bertucci (Author), Chris Gallelli (Author), Alex T. Silverstein (Author)

Book Description

ISBN-10: 0672319977 | ISBN-13: 978-0672319976 | Publication Date: December 12, 2001 | Edition: Bk&CD-Rom

MicrosoftA (R) SQL Server 2000 Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This title includes topics such as: SQL Server and XML; high availability; SQL Server architecture; performance and tuning; SQL Server and the Web; scalability issues; integration with BackOffice and other MicrosoftA (R) products; enterprise issues; replication; Data Transformation Services (DTS); security; and analysis services. This book is written by authors who offer the benefits of their experiences to help readers understand and solve problems such as performance issues, implementing critical backup and recovery strategies, and code efficient applications that work across a variety of platforms and systems.

Editorial Reviews

From the Back Cover

Microsoft SQL Server 2000 Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level.

This title includes topics such as:

* SQL Server and XML;
* High availability;
* SQL Server architecture, performance and tuning;
* SQL Server and the Web;
* Scalability issues;
* Integration with BackOffice and other Microsoft products;
* Enterprise issues and replication;
* Data Transformation Services (DTS) security and analysis services.

About the Author

Ray Rankins is currently owner and president of Gotham Consulting Services, Inc. near Saratoga Springs, New York (the summer place to be). Ray has been working with Sybase and Microsoft SQL Server since 1987 as a DBA, application developer, database designer, project manager, consultant, and instructor. He has worked in a variety of industries including financial, manufacturing, health care, retail, insurance, communications, public utilities, and government. His expertise is in database performance and tuning, query analysis, advanced SQL programming and stored procedure development, and database application design and development. Ray's presentations on these topics at past user group conferences have been very well received. Ray is co-author of Sybase SQL Server 11 Unleashed, Microsoft SQL Server 6.5 Unleashed, and Sybase SQL Server 11 DBA Survival Guide, Second Edition, all published by Sams Publishing. He can be reached at [e-mail]. Paul Jensen is an MCDBA, MCT, MCSE, and OCP (Oracle Certified Professional) who has been involved with database and system administration for almost 15 years. His experience has made him a popular trainer, and the past few years have seen him bouncing around North America and Europe in his role as an MCT, bringing new SQL Server converts in to the fold. Paul lives in Ottawa, Canada, and can be contacted through his Web site at http://www.infojen.com. Paul Bertucci is managing principal and founder of Database Archi-techs (http://www.dbarchitechs.com), a database consulting firm based in San Francisco, California and with European offices in Paris, France. He has more than 20 years of experience doing database design, data architecture, data replication, performance and tuning, distributed data systems, data integration, and systems integration for numerous Fortune 500 companies including Intel, 3COM, Apple Computers, Toshiba, Lockheed, Wells Fargo, Safeway, Texaco, Charles Schwab, Cisco Systems, Sybase, Webgain, and i2 Technologies. He has authored numerous articles, standards, and courses such as Sybase's "Performance and Tuning" course and "Physical Database Design" course. Paul is a frequent conference speaker and regularly teaches database design, performance and tuning, data modeling, OLAP, Supply Chain Management, and SQL courses. He has worked heavily with MS SQL Server, Sybase, DB2, and Oracle, and has architected several commercially available tools in the database, data modeling, performance and tuning, and data integration arena. Paul serves part-time as chief technical advisor for a data integration server software company as well as an advisory board member of a software services company in Silicon Valley. Paul received his formal education in computer science from UC Berkeley. He lives in northern California with his wife, Vilay, and four children (with a fifth on the way). Paul can be reached at [e-mail] and by phone at 925-674-0000. Bennett McEwan is president of Parry Five Consulting, LLC, in Northern Virginia. Ben consults on SQL Server projects in the Washington, DC area. His top skills are in SQL Server replication, performance tuning, high availability database design, and data warehouse architecture. He is always on the lookout for challenging projects. Contact him at [e-mail]. Chris Gallelli is a database administrator working for Alltel Corporation in Latham, New York. Chris has more than seven years of experience with SQL Server and more than 15 years of computing experience. His experience is varied and includes work as both a Visual Basic developer and a DBA. He has a Bachelors degree in electrical engineering and a Masters degree in business administration from Union College. Chris currently lives near Albany, New York with his love

Product Details

• Paperback: 1512 pages
• Publisher: Sams; Bk&CD-Rom edition (December 12, 2001)
• Language: English
• ISBN-10: 0672319977
• ISBN-13: 978-0672319976
• Product Dimensions: 8.9 x 7.4 x 2.6 inches
• Shipping Weight: 5.5 pounds
• Average Customer Review: 4.4 out of 5 stars  See all reviews (27 customer reviews)
• Amazon Best Sellers Rank: #2,522,661 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

27 of 28 people found the following review helpful:

5.0 out of 5 stars Easy to Read (therefore remember) and Very Well Organized, December 22, 2002

By 

K. Ambrose (San Francisco, CA United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2000 Unleashed (Paperback)

I work as a Sql Server developer and DBA. SqlServer is a large application but because of the provided GUI is deceptively simple to get started with. However if your applications ever go into real production, then you (or someone in your organization) better become more than a beginner DBA. This book reads so easily and packs all the key info to become _proficient_ at administering (not application design/development-that is a different skill set) SqlServer. Concepts are balanced perfectly with keystrokes into well organzied and lucid explanations. The result is information that is easy to remember, because it is presented logically and succinctly. I am _very_ hard to please when it comes to tech books, but I would give this one 6 stars if I could. Especially useful in the move from 7.0 to 2000 version.

17 of 17 people found the following review helpful:

5.0 out of 5 stars The Best, November 1, 2003

By 

Jaewoo Kim "OB-Wan" (Santa Monica, CA) - See all my reviews
(TOP 1000 REVIEWER)    (VINE VOICE)    (REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft SQL Server 2000 Unleashed (2nd Edition) (Paperback)

I have read around 12 SQL books. If there is a highly rated SQL book, I probably read it. Along with "Microsoft SQL Server Performance Tuning and Optmization", this book is the best there is. This would be the book I will take with me if I had ended up in some isolated island with a SQL Server I had to manage. If you are some GUI button pushing SQL monkey, get this book fast and master its contents, only then you will become a real SQL DBA. One note, I also highly recommend "Inside SQL Server 2000" from Microsoft. But that book is not quite as comprehensive as this one.

18 of 19 people found the following review helpful:

5.0 out of 5 stars A good ubiquitous source for dba's and developers, August 20, 2003

By 

Tariq Ahmed "DopeJam.com | CFlex.net | FlexIn... (Tracy, CA USA) - See all my reviews

This review is from: Microsoft SQL Server 2000 Unleashed (2nd Edition) (Paperback)

I've spent quite a bit of time reading various SQL Server 2000 books at my local bookstore trying to evaluate which book I need. I'm a web application developer of content management systems, and custom web based tools and my primary systems are based on SQL2K. I wanted a book that covered as many of the topics that I needed information on, but at the same time went into enough detail to be useful. I mean you could get SQL 2000 High Availability which is like a 700 page book from Microsoft Press that talks nothing but high availability and nothing else. However I can't really justify spending on 4 or so books, and my job is not that of a DBA anyways.

I'm very pleased with SQL Server 2000 Unleashed. It gives enough detail that I as a developer can take advantage of advanced features of MSSQL, understand more how the internals of MSSQL work which allows me to optimize my queries... and since I'm a one man team and have to take care of my database server, it provides best practices on maintenance, backup, indexing strategies, etc... I was also interested in learning more about high availability, what the options are, so that I can propose a solution and the options to my manager. My I.T dept was telling me to use Log Shipping for various reasons, a DBA from a sister company was recommending Fail Over Clustering for various reasons... I was bouncing back and forth on what to do, but after reading up on the high availability section in this book my questions were answered.

Definitely an important read for those developing applications that use MSSQL for a DB, and an excellent reference for database administrators. Plus the wording isn't too dry.

Hope that helps in your decision making. BTW the Microsoft Press book SQL SERVER 2000 HIGH AVAILABILITY is also an excellent book if you're a DBA and have to implement H.A in a large high transaction critical environment...