CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS
Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. Microsoft SQL Server 2005 Developer's Guide explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth — including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS
| Ch. 1 | The development environment | 1 |
| Ch. 2 | Developing with T-SQL | 21 |
| Ch. 3 | Developing CLR database objects | 77 |
| Ch. 4 | SQL Server service broker | 117 |
| Ch. 5 | Developing with notification services | 135 |
| Ch. 6 | Developing database applications with ADO.NET | 169 |
| Ch. 7 | Developing with XML | 221 |
| Ch. 8 | Developing database applications with ADO | 255 |
| Ch. 9 | Reporting services | 325 |
| Ch. 10 | SQL Server integration services | 373 |
| Ch. 11 | Developing Bl applications with ADOMD.NET | 415 |
| Ch. 12 | Developing with SMO | 439 |
| Ch. 13 | Using sqlcmd | 477 |
| App | SQL profiler | 491 |
Overview
CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS
Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. Microsoft SQL Server 2005 Developer's Guide explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth ? including .NET CLR Integration, Reporting ...