Directly from people within Microsoft: Hands-On Complete Guide SQL Server 2005? S Powerful Tools! Microsoft SQL Server 2005? S high-powered management tools can dramatically improve DBA productivity and effectiveness. Now there? Sa comprehensive guide for SQL Server 2005? s toolset, straight from the Microsoft team that created it. This book covers the entire toolset in unprecedented depth, guides database professionals in choosing the right tools, and shows them how to use various collective tools to solve real-world problems. The authors now? How-to? solutions and that has not been published tips for SQL 2005 Server installation, upgrades, configuration, authoring, schema design, development, deployment, optimization, troubleshooting, and more. Coverage includes Understanding how SQL Server 2005 tools differ from their predecessors Utilizing Business Intelligence Development Studio and new Management Studio to accomplish dozens of common tasks Increase security by reducing the surface area? You expose Executing queries with the new Query Editor and SQLCMD query tools Optimizing with the revamped SQL Server Profiler and Database Engine Tuning Advisor Scheduling maintenance tasks with SQL Server Agent Monitoring with Activity Monitor, SQL Server Agent, and other equipment Moving data efficiently and reliably with Integration Services Using SQL Server? S new e-mail tool, Database Mail Managing replication in complex distributed environment Mastering SQL Server? S Analysis Services? OLAP and Data Mining tools Using Notification Services 2.0, Reporting Services, and more Extending functionality using underlying APIs and includes CD-ROM? S code examples. Michael Raheem is a senior product manager of Microsoft SQL Server and led the design team and implementation of several SQL Server tools, such as as SQL Server Management Studio, Database Mail, Upgrade Advisor, and Surface Area Configuration. He currently heads the company's SQL Server marketing efforts, including high availability, scalability, and performance. DIMA SONKIN is the main development in SQL Server Tools group responsible for SQL Server Agent, SMO, DMO, SQL Profiler, Database Engine Tuning Advisor, Database Mail, SQLMail, SQLCMD and OSQL. Thierry D? HERS is the lead program manager for Microsoft Analysis? S SQL BI Services and the team has spent five years designing and setting Analysis Service tools. WE LEMONDS is a documentation manager for Microsoft User? S SQL Server Education team and contributed to the SQL Server 2000 Resource Kit. CD-ROM contains all code examples from books and related Visual Studio project files. Content Preface. . . . . . . . . . . . . . . . . . . . . . . . . xvii Preface. . . . . . . . . . . . . . . . . . . . . . . . . . xix Acknowledgments. xxvi About the Author. . . xxvii Chapter 1 Inside the Fundamentals. . . . . . . . . . . . . 1 In Chapter 2 Equipment Installation and Upgrade. . . . . . . 23 Chapter 3 Inside the Configuration Tools. . . . . . . . . . . . . . . 73 In Chapter 4 Equipment Management and Administration. . 129 Chapter 5 Inside Data Authoring Tools. . . . . . . . . . . . . . . . 181 "> Chapter 6 Inside SQLCMD Query Tools................ 199 x "> Chapter 7 Inside Tuning and Optimization Tools ......... 237 Chapter 8 On the Tools Scheduling. . . . . . . . . . . . . . . . . . . 273 Chapter 9 Inside Monitoring Tools. . 305 Chapter 10 Inside Email Tools. . 337 Chapter 11 Inside Programming Object Model. . 357 Chapter 12 On the Tools Replication. 385 Chapter 13 Inside Analysis Services OLAP Tools. 429 Chapter 14 Inside Analysis Services Data Mining Tools. . 519 Chapter 15 Inside Notification Services Tools. 543 Chapter 16 Inside Integration Services Tools. . 601 Chapter 17 Inside the Reporting Services Tools. . 679 Appendix A Sample KPI Client Code? Retrieving and Exposing Your First KPI. . 711 Appendix B KPI Utilities? Code for Parsing Display Folders and Getting Image Index. . 713 Appendix C KPI Viewer. 721 Appendix D Complete List of Data Mining Stored Procedure. 723 Index. . 733