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
High-Speed Signal Propagation[c] Advanced Black Magic
Modeling Internal Impedance
Necessary Mathematics: Input Impedance and Transfer Function
Useful Fourier Transform-Pairs
150- W STP-A Noise and Interference
Intentional Clock Modulation
101 Microsoft Visual Basic .NET Applications
Working with Microsoft Visual Studio .NET 2003 and Microsoft .NET Framework 1.1
Advanced .NET Framework
Building Enterprise Services Applications
Visual Studio .NET
Securing Applications
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Five Stimulating Interest
Chapter Six Defining Pain or Critical Business Issue
Chapter Ten Vision Re-engineering
Chapter Fourteen Getting Started with the Process
Microsoft VBScript Professional Projects
Conditional Logic and Iterative Structures
Project Case Study Analyzing Application Logs
Scheduling Script Execution
Reporting Application Summary Data via the Web
Appendix B Whats on the Companion Web Site
Web Systems Design and Online Consumer Behavior
Chapter II Information Search on the Internet: A Causal Model
Chapter IV How Consumers Think About Interactive Aspects of Web Advertising
Chapter V Consumer Complaint Behavior in the Online Environment
Chapter VIII Personalization Systems and Their Deployment as Web Site Interface Design Decisions
Chapter XIII Shopping Agent Web Sites: A Comparative Shopping Environment
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Working Within the Visio Environment
Adding Shapes to Diagrams
Working with 1-D and 2-D Shapes
Creating Organization Charts
About the Authors
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