Table of Contents

Inside SQL Server 2005 Tools
By Michael Raheem, Dima Sonkin, Thierry D'Hers, Kami LeMonds
...............................................
Publisher: Addison Wesley Professional
Pub Date: October 30, 2006
Print ISBN-10: 0-321-39796-7
Print ISBN-13: 978-0-321-39796-6
Pages: 816

Table of Contents  | Index

		Copyright
		Foreword
		Preface
		Acknowledgments
		About the Authors
		Chapter 1.  Inside the Fundamentals
			History of SQL Server Tools
			Why Database Tools Are Important
			Introducing the SQL Server 2005 Family of Products
			SQL Server 2005 Tools
			Comparing SQL Server 2005 with SQL Server 2000 Tools
			Summary
		Chapter 2.  Inside the Installation and Upgrade Tools
			SQL Server 2005 Installation Issues
			Installing SQL Server 2005
			Upgrading to SQL Server 2005
			Summary
		Chapter 3.  Inside the Configuration Tools
			SQL Server Configuration Tools
			Common Configuration Scenarios
			Summary
		Chapter 4.  Inside Management and Administration Tools
			SQL Server Management Studio
			Management and Administration Scenarios
			Summary
		Chapter 5.  Inside Data Authoring Tools
			Query Editor in SQL Server Management Studio
			Bulk Copy Utility (BCP)
			Summary
		Chapter 6.  Inside SQLCMD Query Tools
			Command Line Options
			Scripting Variables
			SQLCMD Commands
			SQLCMD Startup Script
			Authoring of SQLCMD Queries Using SQL Server Management Studio Query Editor
			Summary
		Chapter 7.  Inside Tuning and Optimization Tools
			Using SQL Server Management Studio for Query Optimization
			SQL Server Profiler
			Database Tuning Advisor
			Summary
		Chapter 8.  Inside Scheduling Tools
			SQL Server Task Scheduling Via SQL Server Agent
			Monitoring Job Execution
			SQL Server Agent Security
			Job Step Logging
			SQL Server Agent Multi-Server Administration
			SQL Server Agent Architectural Overview
			SQL Server Agent Advanced Service Configuration
			Summary
		Chapter 9.  Inside Monitoring Tools
			Monitoring Server Activity
			Using SQL Server Agent Monitoring Capabilities
			Using SQL Server Profiler for Monitoring Server Activity
			Monitoring Using Microsoft Operations Manager and SQL Server Management Pack
			Summary
		Chapter 10.  Inside Email Tools
			SQL Mail
			Database Mail
			SQL Agent Mail
			Summary
		Chapter 11.  Inside Programming Object Models
			The SMO Object Model
			Some Uses of SMO Objects
			Capture Mode
			Scripting
			Backup and Restore
			Architecture
			Local Trees
			Monitoring Server Events
			Optimized Instantiation
			Pre-fetch Capability
			Summary
		Chapter 12.  Inside Replication Tools
			Database Replication Basics
			Wizards in Management Studio
			Administering Replication in Management Studio
			Monitoring Replication Activity in Replication Monitor
			Summary
		Chapter 13.  Inside Analysis Services OLAP Tools
			Analysis Services OLAP Tools Overview
			Using Analysis Services Tools to Address Business Scenarios
			Summary
		Chapter 14.  Inside Analysis Services Data Mining Tools
			Analysis Services Tools Overview
			Using Analysis Services Data Mining Tools to Solve Problems in Business Scenarios
			Summary
		Chapter 15.  Inside Notification Services Tools
			Overview of Notification Services
			Overview of the Notification Services Tools
			Other Tools
			Common Deployment and Management Scenarios
			Summary
		Chapter 16.  Inside Integration Services Tools
			Integration Services Overview
			Integration Services Tools Overview
			Using Integration Services Tools in Business Scenarios
			Summary
		Chapter 17.  Inside the Reporting Services Tools
			Reporting Services Tools Overview
			Building Reports
			Managing and Securing Reports
			Using Reporting Services Tools to Solve Problems in Business Scenarios
			Summary
		Appendix A.  Sample KPI Client CodeRetrieving and Exposing Your First KPI
		Appendix B.  KPI UtilitiesCode for Parsing Display Folders and Getting Image Indexes
		Appendix C.  KPI Viewer
			Website Installation
			Website Usage
			Known Issue
		Appendix D.  Complete List of Data Mining Stored Procedures
			Association Rule
			Clustering
			Decision Trees
			Decision Tree Dep Net
			Naïve Bayes
			Neural Net
			Dependency Net
			Others
		Index