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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Connecting to an Access Databasefrom ASP.NET
Merging Data
Exporting the Results of a Query to an Array
Enforcing Business Rules with Column Expressions
Getting SQL Server Column Metadata Without Returning Data
A+ Fast Pass
Domain 2 Diagnosing and Troubleshooting
Domain 3 Preventive Maintenance
Domain 5 Printers
Domain 2 Installation, Configuration, and Upgrading
Domain 3 Diagnosing and Troubleshooting
WebLogic: The Definitive Guide
Rowsets
JavaMail
EJBs and Transactions
Using CMP and EJB QL
The Java Security Manager
C++ GUI Programming with Qt 3
Creating Dialogs
Creating Custom Widgets
Enabling Drag and Drop
Lists
Session Management
SQL Hacks
Hack 47. Exploit an SQL Injection Vulnerability
Organizing Data
Hack 51. Display Rows As Columns
Hack 54. Denormalize Your Tables
Hack 86. Set Up Queuing in the Database
.NET-A Complete Development Cycle
Project Requirements
Advanced GDI+ Extensions
Three-Dimensional Rendering Technologies
Conclusion: Dont Reinvent the Wheel
Multithreading and Optimization Implementation
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