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