Microsoft SQL Server 2005 Development Guide

Author: Michael Otey
Publisher:
Publish Date: 2007-01-01
Features: Using Microsoft SQL Server 2005 and the extensive information contained in this authoritative book, you can build powerful enterprise-level database programs. The book introduces how to develop server-side and client-side database applications, as well as how to analyze business intelligence data. It also provides in-depth coverage of all the new features, including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Some examples and tips in the book detail how to use SQL Server 2005 as a multi-tiered database platform with Visual Studio 2005, how to create custom management scripts using SQLCMD, and how to improve performance using SQL Profiler.
Main Content:
· Using SQL Server Management Studio and Business Intelligence Development Studio
· Writing stored procedures and using T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML)
· Creating custom database objects using .NET CLR
· Building enterprise-level database applications using ADO, ADO.NET, and ADOMD.NET
· Developing and deploying SQL Server Integration Services packages
· Designing enterprise reports using Reporting Services and Report Builder
· Integrating data from different platforms using XML and Web services
· Extending SQL Server management performance using SQL Management Objects (SMO)
Using Microsoft SQL Server 2005 and the extensive information contained in this authoritative book, you can build powerful enterprise-level data programs. The book introduces how to develop server-side and client-side database applications, as well as how to analyze business intelligence data. It also provides in-depth coverage of all the new features, including .NET CLR Integration, Reporting Services, Integration, Notification Services, and Service Broker. Some examples and tips in the book detail how to use Microsoft SQL Server 2005 as a multi-tiered database platform with Visual Studio 2005, how to create custom management scripts using SQLCMD, and how to improve performance using SQL Profiler.
About the Author: Michael Otey is the president of TECA (a software development and consulting company) and a senior technical editor for SQL Server Magazine. His works include SAMS SQL Server 2000 Developer's Guide, SQL Server 7 Developer's Guide, and ADO.NET: The Complete Reference.