Mastering Microsoft SQL Server 2005 [Paperback]

Mike Gunderloy (Author), Joseph L. Jorden (Author), David W. Tschanz (Author)

Book Description

Publication Date: March 20, 2006 | ISBN-10: 0782143806 | ISBN-13: 978-0782143805 | Edition: 1

The Comprehensive Resource for SQL Server 2005 Administrators, Consultants, and Developers

Whether you're a systems administrator, database application developer, or IT consultant, you'll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005's enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.

Coverage Includes

• Integrating SQL Server with .NET Framework
• Understanding Service Broker, a distributed application framework
• Programming with ADO.NET, the data-access component of .NET
• Setting up Notification Services, which delivers personalized information to mobile devices
• Using SQL Server Management Studio instead of Enterprise Manager
• Designing made easier with new Business Intelligence Development Studio (BIDS)
• Printing multi-page reports
• Mastering Transact-SQL programming language

Leverage the Experience of Large-Scale Enterprises through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshooting

Discover What SQL Server 2005's Increased Emphasis on Connectivity Means to Your Installation

Start Developing Apps--All the Information You Need!

www.sybex.com

Editorial Reviews

From the Back Cover

The Comprehensive Resource for SQL Server 2005 Administrators, Consultants, and Developers

Whether you're a systems administrator, database application developer, or IT consultant, you'll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005's enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.

Coverage Includes

• Integrating SQL Server with .NET Framework
• Understanding Service Broker, a distributed application framework
• Programming with ADO.NET, the data-access component of .NET
• Setting up Notification Services, which delivers personalized information to mobile devices
• Using SQL Server Management Studio instead of Enterprise Manager
• Designing made easier with new Business Intelligence Development Studio (BIDS)
• Printing multi-page reports
• Mastering Transact-SQL programming language

Leverage the Experience of Large-Scale Enterprises through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshooting

Discover What SQL Server 2005's Increased Emphasis on Connectivity Means to Your Installation

Start Developing Apps—All the Information You Need!

www.sybex.com

About the Author

Mike Gunderloy is one of the world's foremost database developers. He has written Mastering SQL Server 2000, Visual Basic Developer's Guide to ADO, and SQL Server In Record Time and contributed to Access Developer's Handbook (in several versions), all from Sybex.

Joseph L. Jorden is the co-author of Mastering SQL Server 2000 and has served as the technical editor for several Sybex books.

David W. Tschanz has worked on a variety of pro-jects related to Web-accessible information and also serves as a computer security liaison.

Product Details

• Paperback: 1056 pages
• Publisher: Sybex; 1 edition (March 20, 2006)
• Language: English
• ISBN-10: 0782143806
• ISBN-13: 978-0782143805
• Product Dimensions: 7.4 x 2.1 x 9.2 inches
• Shipping Weight: 3.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.4 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #885,555 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

4.0 out of 5 stars Good book marred by hard to view "screenshots", April 10, 2006

By 

W. Salkin (North Hollywood, CA United States) - See all my reviews
(REAL NAME)   

This review is from: Mastering Microsoft SQL Server 2005 (Paperback)

I like everything I have read in this book but the screenshots the authors want you to see are too small to be seen clearly. (I use a magnifying glass (no joke) to enlarge the images). I'm sure Sybex reduced them to make them fit the page. I contacted Sybex to see if the book came in a pdf version or if the images were available in a seperate format. They have not gotten back to me and I take this to mean the answer is "no".

I particularly like the chapter on Analysis Services. It took me a long time on my own to learn what they lay out in that chapter. I wish I had their book before I started down my path.

Summary: good text, hard to view images.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Very good all-in-one book, April 2, 2006

By 

James Stark (Tampa, FL) - See all my reviews

This review is from: Mastering Microsoft SQL Server 2005 (Paperback)

For me, this book provides a very good balance between giving me enough information and not flooding me with unnecessary details. It gives a good overview of databases in general without spending half the book on it and is very easy to skim through and get the information I am looking for. IMO, it gives just the right amount of information to help one become very productive with sql server 2005. One last thing. Not that this is a big thing but the book is very large but paper and binding that were used for this book are fairly light weight and make it easy, even with the large size of the book, to read it.

6 of 6 people found the following review helpful:

2.0 out of 5 stars Ho Hum, December 19, 2006

By 

A. Vander Meulen "Omnivorous reader" (Boston, MA USA) - See all my reviews
(REAL NAME)   

This review is from: Mastering Microsoft SQL Server 2005 (Paperback)

"Mastering Microsoft SQL Server 2005" is a humdrum enumeration of SQL Server 2005's capabilities and how to configure and use them. It might be a reasonable starting point for novices learning about SQL Server 2005, but I did not find anything in the book that is not readily available via a few minutes of googling the internet, or exploring MS's support site and the many MS/SQL Server newsgroups out there.

There are a fair number of errors; for instance, I found a number of places where references in the text to "MS/SQL Server 2000" (from the previous version of this book) had not been updated.

Many parts of the book consist of page after page of screenshots - especially in the sections for configuring specific features. The screenshots are hard to read and take up alot of room. I question their value except for the most novice of users.

All in all, this is not a book a skilled DBA will need. It provides very little useful information when moving from SQL Server 2000 to 2005, nor is it of much benefit for those looking to transition from a competing vendor's solution to Microsoft SQL Server.

If you are new to SQL as a DBA or developer, or are installing a SQL Server for the first time, this book is a useful starting point. Even so, you will quickly outgrow "Mastering Microsoft SQL Server 2005", and may eventually decide the steep price of this book was not worth the investment.