Synopses & Reviews
Capturing and analyzing data about customers, products, and the market is essential to staying competitive. Microsoft SQL Server is a leading database tool, and with its ease of use and low total ownership cost, you can customize it to meet your ever-changing business needs. SQL Server 2005 has many enhanced tools that fall into three main categories: data management, developer tools, and business intelligence. SQL Server 2005 for Developers teaches you how to leverage these new tools by covering the topics relevant to developers. Samples throughout the book illustrate the features of SQL Server 2005 in a realistic manner, and provide insights into the new ways for developers to manipulate servers and databases. Specific discussions of similarities and differences between SQL Server 2005 and past versions allow you to use what you already know and apply it efficiently. After working through the book, you'll be up to speed and ready to integrate SQL Server 2005 into your own projects.
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. After working through the book, developers will be up to speed and ready to integrate SQL Server 2005 into their own projects.
About the Author
Rob Ericsson (Roanoke, VA) is a project manager at Meridium Inc. He has written about business intelligence for numerous publications 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 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.
Table of Contents
Chapter 1: Introduction Chapter 2: Database Design Chapter 3: T-SQL Chapter 4: XML Technologies Chapter 5: ADO.NET 2.0 Chapter 6:DTS Chapter 7: Running the Database Chapter 8: Getting Information Out Appendix: About the CD-ROM Index