Résumé
What do I need to do to keep the system running smoothly?
What do I do if something goes wrong?
Learn SQL Server 2000 Administration answers the first question in detail, with the expectation that this will prevent the second question from being asked.
SQL Server consultant Jeffrey Garbus focuses on
designing and implementing a preventive maintenance regimen
in order to ensure ongoing reliability and performance of
your SQL Server. The book begins by introducing basic
concepts, then progresses to advanced topics such as
configuring SQL Server for optimum performance, monitoring
activity on the server, and formulating a disaster recovery
plan. Topics covered in the appendixes include
troubleshooting tips, using wizards to automate tasks, and
replicating data.
Contents
- Definitions and concepts
- A preventive maintenance regimen
- Configuration values
- Activity monitoring
- Monitoring your error log
- Disaster recovery plan
- The database consistency checker (DBCC)
- Backing up and restoring your database
- Transaction log management
- Database space management
- Updating index statistics
- Index maintenance
- Alerts, operators, and jobs
- Appendixes
L'auteur - Jeffrey R. Garbus
Jeffrey Garbus is an experienced SQL Server consultant and the CEO of Soaring Eagle Consulting, Ltd. He has spoken at user conferences, and has written many magazine articles. His books on SQL and databases include Learn SQL Server 7.0 Administration.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Wordware Publishing, Inc |
| Auteur(s) | Jeffrey R. Garbus |
| Parution | 01/05/2001 |
| Nb. de pages | 258 |
| Format | 19 x 23,5 |
| Couverture | Broché |
| Poids | 575g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781556228148 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
