---

Inside SQL Server 2005 Tools

ISBN: 0321397967
EAN: 2147483647

Year: 2006
Pages: 149

Authors: Michael Raheem, Dima Sonkin, Thierry Du00bfHers, Kami LeMonds

BUY ON AMAZON

• Inside SQL Server 2005 Tools
• Table of Contents
• 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
• Nave Bayes
• Neural Net
• Dependency Net
• Others
• Index
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y