Flylib.com
ppk on JavaScript, 1/e
ppk on JavaScript, 1/e
ISBN: 72227885
EAN: 2147483647
Year: 2005
Pages: 126
Authors:
Peter-Paul Koch
BUY ON AMAZON
Table of Contents
BackCover
SQL Server 2000 for Experienced DBAs
Introduction
Conventions Used in This Book
Part I: Managing a SQL Server Environment
Chapter 1: Architecture and Installation
Architecture Overview
Installation Tips
Chapter 2: Managing SQL Server
Managing the Database
DBA Roles
Managing Changes
Chapter 3: Securing SQL Server
Permissions
Security Audits of SQL Server
Common Security Concerns
Locking Down Your SQL Server
SQL Injection
Part II: Tuning SQL Server
Chapter 4: Optimizing and Automating SQL Server Administration
SQL Mail
Optimizing SQL Server Agent
Operators
Jobs
Centralized Administration
Administering DTS
Chapter 5: Monitoring and Tuning SQL Server
System Monitor
System Monitor Alerts
sp_monitor
Trace Flags
Alerts
Setting Job Notifications
Forecasting Growth
sqldiag
Black Box
Chapter 6: Automating Administrative Tasks
Administrative T-SQL
OLE Automation
Chapter 7: Optimizing and Troubleshooting SQL Server
Registry Dependencies
Managing and Configuring the Database
Database Standards
Performance Tuning Your Database Model
Using Sample Data
Optimizing Stored Procedures
Using Temporary Tables
Performance Tuning T-SQL
Returning Top Rows
Quoted Identifiers
Read-Only Databases
Optimizing Indexes
SQL Server Profiler
Web Troubleshooting Resources
Part III: SQL Server in the Enterprise Environment
Chapter 8: Disaster Planning and Recovery
Types of Backups
Database Recovery Models
Maintenance Plans
Restoring
Detaching and Attaching a Database
Chapter 9: Scaling SQL Server
Distributed Partitioned Views
Indexed Views
Scaling Up
Chapter 10: High Availability in SQL Server
Log Shipping
Log Shipping Step by Step
Log Shipping Role Changes
Failover Clustering
Chapter 11: Clustering Windows and SQL Server
Clustering Windows 2000 Advanced Server
Clustering SQL Server 2000
Uninstalling the Cluster and SQL Server
Troubleshooting Clusters
Service Pack Installations
Chapter 12: SQL Server Replication
Understanding the Types of Replication
Configuring SQL Server Agent Replication
Preinstallation Concerns
Initial Replication Setup
Disabling Replication
SnapshotTransactional Replication Setup
Merge Replication Setup
Creating Subscriptions
Schema Changes in Replication
Monitoring and Troubleshooting Replication
Troubleshooting Agents
Recovering from a Disaster
Optimizing Replication
Part IV: Appendixes
Appendix A: System Tables and Undocumented DBCC Commands
Undocumented DBCC Commands
Appendix B: Extended Stored Procedures
Index
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
Index_Y
Index_Z
List of Figures
List of Tables
List of Sidebars
ppk on JavaScript, 1/e
ISBN: 72227885
EAN: 2147483647
Year: 2005
Pages: 126
Authors:
Peter-Paul Koch
BUY ON AMAZON
Agile Project Management: Creating Innovative Products (2nd Edition)
Innovative Product Development
Phase: Speculate
Phase: Envision
Practice: Get the Right People
Practice: Participant Identification
VBScript Programmers Reference
Data Types
Error Handling and Debugging
Classes in VBScript (Writing Your Own COM Objects)
Windows Script Host
Appendix J VBA Features not in VBScript
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Storing Strings in a Sequence
Mapping strings to Other Things
Computing the Sum and Mean of Elements in a Container
Making a Resource Thread-Safe
Hardcoding a Unicode String
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Success Story #1 Lockheed Martin Creating a New Legacy
Success Story #2 Bank One Bigger… Now Better
The Value in Conquering Complexity
Raising the Stakes in Service Process Improvement
Designing World-Class Services (Design for Lean Six Sigma)
.NET-A Complete Development Cycle
Initial Requirements Analysis and Design
GDI+ Graphics Extensions
Design of the Image-Processing Components Using Late Binding
Implementing Dynamically Loadable Image Postprocessing Plugins
Secure Web Applications
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
History of the Quartz Framework
Getting Help from the Quartz Community
Running Quartz with JobStoreTX
Registering Your Plug-Ins
Quartz Cookbook
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