Flylib.com
Inside SQL Server 2005 Tools
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
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
Lotus Notes and Domino 6 Development (2nd Edition)
Creating Calendar Views
Understanding Folders
Knowing Where to Use @Functions and @Commands
Enabling Database Encryption
Frameset Tags
MySQL Clustering
Installation
Restarting a Cluster
Upgrading MySQL Cluster
Indexes
B Management Commands
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Photoshop Layers and After Effects
Blue-Screen Garbage Mattes
Rotoscoping Techniques with Photoshop
Motion Matte Painting in Photoshop
Motion Titling Effects
Comparing, Designing, and Deploying VPNs
Deploying MPLS Layer 3 VPNs
The Carriers Carrier Architecture
Ensuring High Availability in an IPsec VPN
Operation of L2TP Voluntary/Client-Initiated Tunnel Mode
Strengthening SSL Remote Access VPNs Security by Implementing Cisco Secure Desktop
Python Programming for the Absolute Beginner, 3rd Edition
The Compulsory Features List
Packing and Unpacking Files
A Simple Python File Server
The PyErrata Web Site
Other Integration Topics
User Interfaces in C#: Windows Forms and Custom Controls
Creating Usable Interfaces
Forms
Custom Controls
Design-Time Support for Custom Controls
Dynamic User Interface
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies