SQL Server 2005 for Developers (Paperback)

by Robert Ericsson (Author), Jason Cline (Author)

Editorial Reviews

Product Description
Databases are used in nearly every kind of business. Microsoft SQL Server is one of the leading database products in the market today because of its reputation for ease of use and low total cost of ownership. With the release of SQL Server 2005, Microsoft will significantly enhance the capabilities of the product. These enhanced features fall into three main categories: data management, developer tools, and business intelligence. Developer’s Guide to SQL Server 2005 explores these new and improved features and covers topics relevant to developers beyond simple administrative tasks. The book is structured around the construction of an Internet movie rental Web site, where the database maintains customer lists, the catalog of films, and transactions. It also shows how SQL Server can be used to store video. This application illustrates the features of SQL Server 2005 in a realistic manner, and provides many insights into the new ways for developers to manipulate servers and databases. Each of the chapters in the book builds up pieces of the application as they would be done through a real development lifecycle, and the end product is a fully functioning database application. Specific discussions of similarities and differences between SQL Server 2005 and past versions allow users to leverage what they already know and apply it. After working through the book, developers will be up to speed and ready to integrate SQL Server 2005 into their own projects. FEATURES:
* Provides developers with insight into the new features in SQL Server 2005, particularly data management, developer tools, and business intelligence
* Teaches developers how to create a complete database application based on a real-life project examined throughout the book
* Provides discussion of similarities and/or differences between SQL Server 2000 and SQL Server 2005, tips & tricks, and additional reference resources related to the topic being covered
* Examines best practices in design and development
* Includes a CD-ROM with all of the code from the book and the application, as well as all of the figures

About the Author
Rob Ericsson (Roanoke, VA) is a consultant and program manager at Meridium Inc.He has written about business intelligence for numerous publications, including .NET ASP Today and SQL Server Professional and is the author of Building Business Intelligence Applications with .NET.He holds an MS in the Management of Information Technology from the University of Virginia. Jason Cline (Roanoke, VA) is a software engineer and program manager at Meridium, Inc. He is active in the technology community and has written and reviewed numerous publications. He holds a BS in Computer Science from the University of Virginia.

Product Details

• Paperback: 424 pages
• Publisher: Charles River Media; 1 edition (June 30, 2006)
• Language: English
• ISBN-10: 1584503882
• ISBN-13: 978-1584503880
• Product Dimensions: 9.1 x 7.3 x 1.1 inches
• Shipping Weight: 1.9 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
• Amazon.com Sales Rank: #1,503,588 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

5.0 out of 5 stars At Last and Overview of the SQL Server System, August 13, 2006

By	John Matlock "Gunny" (Winnemucca, NV) - See all my reviews (REAL NAME)

This is a book that has been needed for some time.

When Microsoft first licensed what was to become SQL Server from Sybase it was basically just a database program. Since the split between the companies Microsoft has added a series of extensions to the package that effectively add front end packages to facilitate understanding what's going on inside the database, ease the programming task for certain applications like Data Warehousing and Data Mining, provide for notification of the manager in the event of certain events, a sophisticated reporting service and more.

The problem has been that all of these additional packages are big sophisticated programs in their own right. In fact, most of them have their own book or even books describing how to use them. What this has meant is that there is so much information on each of these packages that it is difficult to decide just which of these packages is worth the time it takes to implement them.

This book is sort of the first book in a series that gives you the overall view. I'd suggest that anyone starting out to implement a SQL Server system read this book first. It's more or the less the general introduction to the SQL Server system.

Obviously this book doesn't cover as much detail on any of the packages as a dedicated book, but it gives you enough information to tell you if the package will do the task you need performed.