Sams Teach Yourself Microsoft SQL Server 7 in 21 Days [Paperback]

Richard Waymire (Author), Rick Sawtell (Author)

Book Description

Series: Sams Teach Yourself...in 21 Days | Publication Date: December 18, 1998

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the new features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.

Editorial Reviews

Amazon.com Review

Teach Yourself Microsoft SQL Server 7.0 in 21 Days introduces you to every aspect of Microsoft's flagship back-end database engine. Organized with a FAQ-like summary at the end of every chapter, the book familiarizes you with all the features and even brings you up to expert level on a few of them.

Focusing on SQL Server Standard Edition, authors Waymire and Sawtell explain how to install the software under Windows NT Server 4. After a quick synopsis of the tools and utilities on the SQL Server CD-ROM, the authors walk you through the process of creating databases (and related entities) and establishing accounts for the people and processes that will access them.

The authors place considerable emphasis on security, showing you exactly how to set up user logins and access permissions. They also include information on preparing for and recovering from disasters, RAID schemes, backup routines, and restoration of backed-up data. The book wraps up by showing you how to use SQL Server's programming abilities to create customized applications. On top of their coverage of triggers and stored procedures--and of Structured Query Language (SQL) generally--the authors include a good tutorial on the fundamentals of Transact-SQL programming. There's also information on automating administrative tasks with the SQL Server Agent. --David Wall

From the Back Cover

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the new features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.

See all Editorial Reviews

Product Details

• Paperback: 800 pages
• Publisher: Sams; 1st edition (December 18, 1998)
• Language: English
• ISBN-10: 0672312905
• ISBN-13: 978-0672312908
• Product Dimensions: 9 x 7.5 x 1.8 inches
• Shipping Weight: 2.9 pounds
• Average Customer Review: 4.6 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #2,649,061 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

29 of 30 people found the following review helpful:

5.0 out of 5 stars The Best Book Available for Begginers, July 13, 2000

By 

Matt Bridges - See all my reviews

This review is from: Sams Teach Yourself Microsoft SQL Server 7 in 21 Days (Paperback)

As a SQL Server trainer I am often asked to recommend books, and this is one that's always on the top of my list! It presents a wealth of information in a logical progression of 21 lessons. Spending an hour or two a day with this book will give a solid foundation for adminstering SQL 7 databases.

There are several criticisms I think are off base and a few that are unfair. With respect to criticisms about the book's technical accuracy, it's by far one of the most technically accurate. Knowing both the authors personally, I can assure you that both Richard (who happens to work on the SQL Server Team at Microsoft) and Rick are very concerned that they published the most technically accurate book they could. With respect to comments emphasizing a lack of emphasis on developing applications for SQL Server, the cover says the book is targeted towards administrators.

You won't learn everything there is know about SQL or SQL Server administration (no one knows everything). You will learn the fundamentals, and more importanly where to look for further information.

21 of 22 people found the following review helpful:

5.0 out of 5 stars Excellent learning and reference tool from start to finish., September 3, 1999

By A Customer

This review is from: Sams Teach Yourself Microsoft SQL Server 7 in 21 Days (Paperback)

I was in the middle of the MOC SQL 7.0 class and being a newbie, my brain was feeling like mush. On the second day the instructor recommended this book. I checked out the reviews. This book has made it so easy to understand everything that is going on in class. I'm not of fan of "Learn x in x Days", but this book is awesome!!! I highly recommend it if you're new to SQL Server!

15 of 15 people found the following review helpful:

5.0 out of 5 stars It's worth the money, December 14, 1999

By 

Glenn Naval (Toronto, Canada) - See all my reviews

This review is from: Sams Teach Yourself Microsoft SQL Server 7 in 21 Days (Paperback)

I bought this book after reading the reviews. My boss told me to research on SQL Server 7 because our Foxpro tables are now more than 2GB in sizes and still growing. This book helped me on how to install SQL Server 7, configure it then setup the databases. I then started to import our Foxpro databases directly using DTS. Then I learned the data types and how they differ from Foxpro's field types. Their explanation on data types is clearer than the BOL. I must add though that I still use BOL with this book whenever I run into a wall or something. It's really a beginner's book so guys, buy it. My boss is happy I'm making progress in just a week of installing and using this book. They even reimbursed the cost of the book to me.