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.
1 Introduction
2 Database Design
3 Database Security
4 Transact-SQL for Developers
5 Programmability
6 ADO.NET 2.0
7 Notification Services
8 XML in SQL Server 2005
9 Service Broker
10 Performance Analysis and Tuning
11 Business Intelligence
12 Data Warehouse
13 SQL Server Integration Services
14 SQL Server Reporting Services
15 OLAP
16 Introduction to Data Mining in SSAS 2005