Register your product to gain access to bonus material or receive a coupon.
This PDF will be accessible from your Account page after purchase and requires PDF reading software, such as Acrobat® Reader®.
The eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.
Direct from Microsoft Insiders: the Complete Hands-On Guide to
SQL Server 2005’s Powerful Tools!
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.
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
Understanding how SQL Server 2005 tools differ from their predecessors
Leveraging the new Business Intelligence Development Studio and
Management Studio to accomplish dozens of common tasks
Improving 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 the SQL Server Agent
Monitoring with the Activity Monitor, SQL Server Agent, and other tools
Moving data efficiently and reliably with Integration Services
Using SQL Server’s new e-mail tool, Database Mail
Managing replication in complex distributed environments
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 the included
CD-ROM’s sample code.
MICHAEL RAHEEM is the senior product manager of the Microsoft SQL Server
team and led the design and implementation of several SQL Server tools, such
as SQL Server Management Studio, Database Mail, Upgrade Advisors, and
Surface Area Configuration. He currently leads the SQL Server enterprise
marketing efforts including high availability, scalability, and performance.
DIMA SONKIN is development lead in the 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 on Microsoft’s SQL BI Analysis
Services team and has spent five years designing and specifying Analysis
Services tools.
KAMI LEMONDS is the documentation manager for Microsoft’s SQL Server User
Education team and contributed to the SQL Server 2000 Resource Kit.
CD-ROM contains all sample code from the book and corresponding
Visual Studio project files.
Contents
Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . xxvi
About the Authors . . . . . . . . . . . . . . . . . . . . . . . xxvii
Chapter 1 Inside the Fundamentals. . . . . . . . . . . . . . . . . . . . . 1
Chapter 2 Inside the Installation and Upgrade Tools. . . . . . . 23
Chapter 3 Inside the Configuration Tools . . . . . . . . . . . . . . . 73
Chapter 4 Inside Management and Administration Tools . . 129
Chapter 5 Inside Data Authoring Tools . . . . . . . . . . . . . . . . 181
Chapter 6 Inside SQLCMD Query Tools . . . . . . . . . . . . . . . . 199
Chapter 7 Inside Tuning and Optimization Tools . . . . . . . . . 237
Chapter 8 Inside Scheduling Tools . . . . . . . . . . . . . . . . . . . 273
Chapter 9 Inside Monitoring Tools. . . . . . . . . . . . . . . . . . . . 305
Chapter 10 Inside Email Tools . . . . . . . . . . . . . . . . . . . . . . . . 337
Chapter 11 Inside Programming Object Models . . . . . . . . . . 357
Chapter 12 Inside Replication Tools . . . . . . . . . . . . . . . . . . . 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 Indexes . . . . . . . . . . 713
Appendix C KPI Viewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 721
Appendix D Complete List of Data Mining Stored
Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 723
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 733
Contents
Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . xxvi
About the Authors . . . . . . . . . . . . . . . . . . . . . . . xxvii
Chapter 1 Inside the Fundamentals. . . . . . . . . . . . . . . . . . . . . 1
Chapter 2 Inside the Installation and Upgrade Tools. . . . . . . 23
Chapter 3 Inside the Configuration Tools . . . . . . . . . . . . . . . 73
Chapter 4 Inside Management and Administration Tools . . 129
Chapter 5 Inside Data Authoring Tools . . . . . . . . . . . . . . . . 181
Chapter 6 Inside SQLCMD Query Tools . . . . . . . . . . . . . . . . 199
Chapter 7 Inside Tuning and Optimization Tools . . . . . . . . . 237
Chapter 8 Inside Scheduling Tools . . . . . . . . . . . . . . . . . . . 273
Chapter 9 Inside Monitoring Tools. . . . . . . . . . . . . . . . . . . . 305
Chapter 10 Inside Email Tools . . . . . . . . . . . . . . . . . . . . . . . . 337
Chapter 11 Inside Programming Object Models . . . . . . . . . . 357
Chapter 12 Inside Replication Tools . . . . . . . . . . . . . . . . . . . 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 Indexes . . . . . . . . . . 713
Appendix C KPI Viewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 721
Appendix D Complete List of Data Mining Stored
Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 723
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 733