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