SSWUG Online Course: Care and Feeding of the SQL Server Transaction Log

Online Event

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 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.

Attendance cost: $169 USD for SSWUG.ORG Members, $199 USD for Non-members

Event organizer: SSWUG.ORG

Register for the SSWUG Online Course: Care and Feeding of the SQL Server Transaction Log