ISBN:0735605173Amazon.com
As the title implies, Inside Microsoft SQL Server 7.0 examines SQL Server from the inside out, investigating the technical workings of this complex database product. Author Kalen Delaney has updated this popular title, penned originally by Ron Soukup. Both authors emphasize that Inside Microsoft SQL Server 7.0 does not work well as an introductory tutorial but is designed to elevate existing SQL Server knowledge to the next level.
The initial 31-page overview describes the colorful history of SQL Server with an excellent rundown of composite technologies and important features of the database. A very insightful analysis of SQL Server's engine internals follows, which breaks down all of the various manager components and explains how they work.
The remainder of the book focuses on the intelligent implementation of SQL Server in a number of areas. A chapter on planning and installation gives an unusually detailed look at hardware and software strategies for high performance and reliability. The book then covers how to effectively work with databases, tables, queries, transactions, triggers, and cursors.
Each subject receives highly detailed coverage with the goal of enhancing your decision making skills with knowledge of the inner workings of the product. Inside Microsoft SQL Server 7.0 is a database administrator's (DBA) gold mine--a rare treasury of in-depth product knowledge from true masters. --Stephen Plain/p>
Reviews From AMAZON.COM
Extremely well written
I purchased three things to help me prepare for the 70-029 exam: This book, the Exam Cram Book, and Transcender. The Exam Cram is garbage, but this book consistently presents the material in an accurate and logical fashion. It fully explains the concepts to the degree that fosters understanding as well as retention. Concept explanations are followed up by numerous examples and it's written in a way that makes a relatively dry subject interesting. It's impossible to go wrong with this book either as a reference or as a study guide.
Best Book for SQL 7
If you only have one reference for SQL 7..this is it.