Material: Managing and Administering SQL Server 2005.
Te dejo el material para la sesión: "SQL-02: Managing and Administering SQL Server 2005". Disfrútalo!.
Downloads for: Full Session, Slides and transcripts
•SQL Server Management Studio. In this demonstration we will show how to use the SQL Management Studio to perform common administration tasks. Demo 1 Download
•Backup and Restore. In this demonstration, we will show how to use SQL Server Management Studio to create backup devices, backup databases and transaction logs, and perform restores. Demo 2 Download
•SQL Server Configuration Manager. In this demonstration, we will see how to use SQL Server Configuration Manager to manage local and remote SQL Server configurations. Demo 3 Download
•SQLCMD. In this demonstration, we will show some of features of the new command line utility, SQLCMD. Demo 4 Download
•Database Tuning Advisor. In this demonstration, we will show how to use the Database Tuning Advisor to analyze workload and optimize database indexes. Demo 5 Download
•Database Maintenance Workflow. In this demonstration, we will show how to create Database Maintenance Plans in SQL Server 2005. Demo 6 Download
•Monitoring Tools. In this demonstration, we will show some of the monitoring tools available in SQL Server 2005. Demo 7 Download
Fuente: http://www.microsoft.com/technet/community/events/sql2005/sql-02.mspx
Más material acerca de otros temas muy interesantes, puedes bajártelos desde aqui: http://www.microsoft.com/technet/community/events/sql2005/default.mspx
Saludos,
Percy Reyes,