Inside Microsoft SQL Server 7.0 (Mps) - Hardcover

Soukup, Ron; Delaney, Kalen

  • 4.08 out of 5 stars
    13 ratings by Goodreads
 
9780735605176: Inside Microsoft SQL Server 7.0 (Mps)

Synopsis

A Microsoft SQL Server guru provides a comprehensive guide with updated, authoritative advice for installing, administering, and programming with version 7.0. The CD-ROM contains product evaluation documentation, sample code, and scripts, white papers, and a benchmarking kit.

"synopsis" may belong to another edition of this title.

Review

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

"About this title" may belong to another edition of this title.