Six On-Demand Sessions Opening July 17, 2012 and Closing After August 15, 2012

Course Overview

In SSWUG.ORG’s virtual class, you will learn how to manage and maintain your SQL Server transaction log, as the log is critical to optimizing operability and functionality. By the end of the six sessions, you will know why the transaction log is considered to be one of the most important components of a database, as it records all changes to your database, to allow recovery of transactions in the event of a crash.

Kalen Delaney, course instructor and celebrated author of SQL Server 2008 Internals, will start by examining how SQL Server manages the transaction log internally and looking at some undocumented commands for examining log usage and low growth. Then, Kalen will discuss what happens as the log grows and shrinks, exploring best practices for physical placement of your log file(s). She will also review various SQL Server operations to explore what gets written to the log when various operations are performed. Finally, Kalen will demonstrate how the log is processed during BACKUP and RESTORE commands, and how that processing changes in different recovery models.

The target of this class for administrators, developers or IT professionals who have basic experience with database administration tasks, such as backups and recovery processes. This is not a “DBA 101” course for the non-formally trained, “accidental” DBA.

Session Descriptions

Throughout the 30-day course, you will learn how to:

• Keep your SQL Server transaction log healthy through proper management
• Recover information up to the point of failure
• Utilize the transaction log’s capabilities
• Properly protect your data
• Determine the best recovery model for a database
  
   

Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).