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

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 1 Ratings

more build out of SQL Server - 2007-01-03
Reviewer Rating:
Straight from Microsoft comes this authoritative guide to the many ways you can use the tools developed for SQL Server 2005. The book documents an impressive build out of functionality, to make the administrator more productive. No doubt, in part, the book is also a competitive response to IBM and Oracle's database offerings.

For those of you interested in protecting your database against attacks, there is a useful section on surface area reduction. SQL Server comes with several services. Quite possibly, your usage might not need some of these. So you are shown how to turn them off. Lessens the risk. Plus, some services are accessible on the network. If you only need these accessible locally, then you can disable remote network access. Simple precautions that can improve matters. In fact, many of the features described in the book can be disabled, and often are, as a default measure.

The most powerful tools appear to be those for data mining, in the Analysis Service 2005. You can add custom logic, in addition to various algorithms that come with the service. The narrative also shows examples of graphics of the analysis, where various methods can be easily plotted. For some readers, the data mining is where you can add or find the most value to your data.

My impression is that you should not need to read the book sequentially. Just pick the sections that are germane. The chapters seem largely independent of each other.

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > SQL Server