Learn the power of SQL Server 2005’s capability to develop systems and applications that both meet your performance needs and store your data in a fashion that maintains the integrity of the data while keeping it reasonably usable. *The various add-on services, as well as advanced programming constructs and supporting object models *Backward compatibility issues with SQL Server 2000 and 7.0 *Ways to work with the completely rewritten SQL Server integration Servers *The new functionality of Analysis Manager and the new Reporting Services engine *How the new Notification Services engine allows you to subscribe to customizable events on your server or to specific data activity

Get ahead of the curve of using SQL Server 2005 Integration Services (SSIS) to transform your data

Learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language. *Ways to quickly move and transform data *How to configure every aspect of SSIS *How to interface SSIS with web services and XML *Techniques to scale the SSIS and make it more reliable *How to migrate DTS packages to SSIS *How to create your own custom tasks and user interfaces *How to create an application that interfaces with SSIS to manage the environment *A detailed usable case study for a complete ETL solution

Take full advantage of what SQL Server 2005 Reporting Services has to offer

Learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access. *Details of programming reports and report scripting *Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content *High-level strategies for business and support systems