The SQLServerVideos.com BookShelf

Author(s): William R. Stanek

Rating: 4.5 / 5

Summary: A comprehensive overview of SQL Server 2005 Administrative tasks with lots of great tips and tricks.

Review: Official SSV Book Review Pending

Learn about the kinds of conditions that make log files adversely grow - and see how to troubleshoot and prevent these problems from blowing your databases out of space.

Covers: Log Files, Transactions, the SQL Server Storage Engine, and Backups.

Skill Level: 300 - Advanced

Video Length: 11:45

Release Date: 2008-07-18

Learn why SQL Server Backups can be hard to understand and master. A must-see video for anyone who isn't familiar with SQL Server Backup functionality.

Covers: Backups, Recovery, Log Files, Transactions, and the SQL Server Storage Engine.

Skill Level: 000 - Overview

Video Length: 11:09

Release Date: 2008-01-03

Learn how to set database recovery models and properly size and configure file-growth for your SQL Server 2005 and 2008 databases.

Covers: Log Files, Recovery, Backups, Management, and SQL Server Management Studio.

Skill Level: 100 - Beginner

Video Length: 10:28

Release Date: 2008-07-11

Learn about backup types, execution options, storage locations, and other options in order to best address your backup and recovery needs.

Covers: Backups, Recovery, Log Files, Storage Engine, and the SQL Server File System.

Skill Level: 000 - Overview

Video Length: 12:46

Release Date: 2008-01-03

Learn the ins and outs of manually executing backups for SQL Server 2005 and 2008 databases using SQL Server Management Studio.

Covers: Manual Backups, SQL Server Management Studio, Log File Management.

Skill Level: 100 - Beginner

Video Length: 09:49

Release Date: 2008-08-05

Learn about SQL Server Backup best practices and the role of disaster recovery plans.

Covers: Best Practices, Disaster Recovery, Backups, and Recovery.

Skill Level: 000 - Overview

Video Length: 12:14

Release Date: 2008-07-19

Learn how to create SQL Server 2005 and 2008 Maintenance plans using SQL Server Management Studio.

Covers: Maintenance Plans, Backups, and SQL Server Management Studio.

Skill Level: 100 - Beginner

Video Length: 10:45

Release Date: 2008-08-26

Check out troubleshooting tips and tricks and learn how to troubleshoot problems with your SQL Server 2005 and 2008 Maintenance Plans.

Covers: Backups, Maintenance Plans, and SQL Server Management Studio.

Skill Level: 200 - Intermediate

Video Length: 08:58

Release Date: 2008-08-28

Learn how to both test your database backups as part of your disaster recovery plan, as well as how to restore and recover your SQL Server 2005 and 2008 databases in the case of a disaster.

Covers: Backups, Recovery, Recovery Options, and SQL Server Management Studio.

Skill Level: 200 - Intermediate

Video Length: 12:35

Release Date: 2008-09-05

Learn the exact steps you'll need to take to successfully detach and attach SQL Server 2005 and 2008 databases in order to move or copy them.

Covers: SQL Server Management Studio, the SQL Server File System, and Database Management options required to attach and detach SQL Server 2005/2008 databases.

Skill Level: 100 - Beginner

Video Length: 10:33

Release Date: 2008-10-29

Learn how to transfer and re-map SQL Server Logins from one server to another, and see how to enumerate and troubleshoot logins against assigned users and roles within SQL Server databases.

Covers: Database Management, Logins, Security, Roles and Users.

Skill Level: 200 - Intermediate

Video Length: 09:56

Release Date: 2008-10-30