<P style="MARGIN: 0px">Direct from Microsoft Insiders: the Complete Hands-On Guide to</P> <P style="MARGIN: 0px">SQL Server 2005&rsquo;s Powerful Tools!</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Microsoft SQL Server 2005&rsquo;s high-powered management tools can dramatically</P> <P style="MARGIN: 0px">improve DBA productivity and effectiveness. Now there&rsquo;s a comprehensive guide</P> <P style="MARGIN: 0px">to SQL Server 2005&rsquo;s toolset, straight from the Microsoft team that created it.</P> <P style="MARGIN: 0px">This book covers the entire toolset in unprecedented depth, guides database</P> <P style="MARGIN: 0px">professionals in choosing the right tools, and shows them how to use various</P> <P style="MARGIN: 0px">tools collectively to solve real-world problems. The authors present “how-to”</P> <P style="MARGIN: 0px">solutions and never-before-published tips for SQL Server 2005 installation,</P> <P style="MARGIN: 0px">upgrades, configuration, authoring, schema design, development, deployment,</P> <P style="MARGIN: 0px">optimization, troubleshooting, and more. Coverage includes</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">  Understanding how SQL Server 2005 tools differ from their predecessors</P> <P style="MARGIN: 0px">  Leveraging the new Business Intelligence Development Studio and</P> <P style="MARGIN: 0px">Management Studio to accomplish dozens of common tasks</P> <P style="MARGIN: 0px">  Improving security by reducing the “surface area” you expose</P> <P style="MARGIN: 0px">  Executing queries with the new Query Editor and SQLCMD query tools</P> <P style="MARGIN: 0px">  Optimizing with the revamped SQL Server Profiler and Database</P> <P style="MARGIN: 0px">Engine Tuning Advisor</P> <P style="MARGIN: 0px">  Scheduling maintenance tasks with the SQL Server Agent</P> <P style="MARGIN: 0px">  Monitoring with the Activity Monitor, SQL Server Agent, and other tools</P> <P style="MARGIN: 0px">  Moving data efficiently and reliably with Integration Services</P> <P style="MARGIN: 0px">  Using SQL Server&rsquo;s new e-mail tool, Database Mail</P> <P style="MARGIN: 0px">  Managing replication in complex distributed environments</P> <P style="MARGIN: 0px">  Mastering SQL Server&rsquo;s Analysis Services&rsquo; OLAP and Data Mining tools</P> <P style="MARGIN: 0px">  Using Notification Services 2.0, Reporting Services, and more</P> <P style="MARGIN: 0px">  Extending functionality using underlying APIs and the included</P> <P style="MARGIN: 0px">CD-ROM&rsquo;s sample code.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">MICHAEL RAHEEM is the senior product manager of the Microsoft SQL Server</P> <P style="MARGIN: 0px">team and led the design and implementation of several SQL Server tools, such</P> <P style="MARGIN: 0px">as SQL Server Management Studio, Database Mail, Upgrade Advisors, and</P> <P style="MARGIN: 0px">Surface Area Configuration. He currently leads the SQL Server enterprise</P> <P style="MARGIN: 0px">marketing efforts including high availability, scalability, and performance.</P> <P style="MARGIN: 0px">DIMA SONKIN is development lead in the SQL Server Tools group responsible</P> <P style="MARGIN: 0px">for SQL Server Agent, SMO, DMO, SQL Profiler, Database Engine Tuning Advisor,</P> <P style="MARGIN: 0px">Database Mail, SQLMail, SqlCmd, and OSQL.</P> <P style="MARGIN: 0px">THIERRY D&rsquo;HERS is the lead program manager on Microsoft&rsquo;s SQL BI Analysis</P> <P style="MARGIN: 0px">Services team and has spent five years designing and specifying Analysis</P> <P style="MARGIN: 0px">Services tools.</P> <P style="MARGIN: 0px">KAMI LEMONDS is the documentation manager for Microsoft&rsquo;s SQL Server User</P> <P style="MARGIN: 0px">Education team and contributed to the SQL Server 2000 Resource Kit.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">CD-ROM contains all sample code from the book and corresponding</P> <P style="MARGIN: 0px">Visual Studio project files.</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Contents</P> <P style="MARGIN: 0px">Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii</P> <P style="MARGIN: 0px">Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix</P> <P style="MARGIN: 0px">Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . xxvi</P> <P style="MARGIN: 0px">About the Authors . . . . . . . . . . . . . . . . . . . . . . . xxvii</P> <P style="MARGIN: 0px">Chapter 1 Inside the Fundamentals. . . . . . . . . . . . . . . . . . . . . 1</P> <P style="MARGIN: 0px">Chapter 2 Inside the Installation and Upgrade Tools. . . . . . . 23</P> <P style="MARGIN: 0px">Chapter 3 Inside the Configuration Tools . . . . . . . . . . . . . . . 73</P> <P style="MARGIN: 0px">Chapter 4 Inside Management and Administration Tools . . 129</P> <P style="MARGIN: 0px">Chapter 5 Inside Data Authoring Tools . . . . . . . . . . . . . . . . 181</P> <P style="MARGIN: 0px">Chapter 6 Inside SQLCMD Query Tools . . . . . . . . . . . . . . . . 199</P> <P style="MARGIN: 0px">Chapter 7 Inside Tuning and Optimization Tools . . . . . . . . . 237</P> <P style="MARGIN: 0px">Chapter 8 Inside Scheduling Tools . . . . . . . . . . . . . . . . . . . 273</P> <P style="MARGIN: 0px">Chapter 9 Inside Monitoring Tools. . . . . . . . . . . . . . . . . . . . 305</P> <P style="MARGIN: 0px">Chapter 10 Inside Email Tools . . . . . . . . . . . . . . . . . . . . . . . . 337</P> <P style="MARGIN: 0px">Chapter 11 Inside Programming Object Models . . . . . . . . . . 357</P> <P style="MARGIN: 0px">Chapter 12 Inside Replication Tools . . . . . . . . . . . . . . . . . . . 385</P> <P style="MARGIN: 0px">Chapter 13 Inside Analysis Services OLAP Tools . . . . . . . . . 429</P> <P style="MARGIN: 0px">Chapter 14 Inside Analysis Services Data</P> <P style="MARGIN: 0px">Mining Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . 519</P> <P style="MARGIN: 0px">Chapter 15 Inside Notification Services Tools . . . . . . . . . . . 543</P> <P style="MARGIN: 0px">Chapter 16 Inside Integration Services Tools . . . . . . . . . . . . 601</P> <P style="MARGIN: 0px">Chapter 17 Inside the Reporting Services Tools . . . . . . . . . . 679</P> <P style="MARGIN: 0px">Appendix A Sample KPI Client Code— Retrieving and</P> <P style="MARGIN: 0px">Exposing Your First KPI. . . . . . . . . . . . . . . . . . . . 711</P> <P style="MARGIN: 0px">Appendix B KPI Utilities—Code for Parsing Display</P> <P style="MARGIN: 0px">Folders and Getting Image Indexes . . . . . . . . . . 713</P> <P style="MARGIN: 0px">Appendix C KPI Viewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 721</P> <P style="MARGIN: 0px">Appendix D Complete List of Data Mining Stored</P> <P style="MARGIN: 0px">Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 723</P> <P style="MARGIN: 0px">Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 733</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"></P>