图书标签: 工作
发表于2024-11-27
Inside SQL Server 2005 Tools (Microsoft Windows Server System Series) pdf epub mobi txt 电子书 下载 2024
<P style="MARGIN: 0px">Direct from Microsoft Insiders: the Complete Hands-On Guide to</P> <P style="MARGIN: 0px">SQL Server 2005’s Powerful Tools!</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Microsoft SQL Server 2005’s high-powered management tools can dramatically</P> <P style="MARGIN: 0px">improve DBA productivity and effectiveness. Now there’s a comprehensive guide</P> <P style="MARGIN: 0px">to SQL Server 2005’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’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’s Analysis Services’ 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’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’HERS is the lead program manager on Microsoft’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’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>
评分
评分
评分
评分
Inside SQL Server 2005 Tools (Microsoft Windows Server System Series) pdf epub mobi txt 电子书 下载 2024