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
- Use SQL Server Management Studio and Business Intelligence Development Studio
- Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML)
- Create custom database objects with .NET CLR
- Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET
- Develop and deploy SQL Server Integration Services packages
- Design enterprise reports using Reporting Services and Report Builder
- Integrate cross-platform data using XML and Web services
- Extend SQL Server manageability using SQL Management Objects (SMO)
About the Author Michael Otey is the Senior Technical Editor of SQL Server Magazine and Windows 2000 Magazine. He is also the President of TECA, a consulting and software development company in Portland, Oregon that specializes in Windows, SQL Server and AS/400 utilities. Michael has published numerous articles in SQL Server Magazine and Windows 2000 Magazine. He is the co-author of the SQL Server 7 Developer’s Guide and the author of VB Answers! published by Osborne/McGraw-Hill. He is also the author of AS/400 Client Server Programming and the AS/400 Application Developer’s Guide published by 29th Street Press. Michael has a B.S. in psychology from Lewis and Clark college and he enjoys running, playing video games and building computers in his spare time.