This event has ended

The DBA Skills Upgrade Toolkit by Eddie Wuerch

SQL Saturday Tampa

Friday, March 9, 2012 from 9:00 AM to 5:00 PM (PST)

The DBA Skills Upgrade Toolkit by Eddie Wuerch

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
The DBA Skills Upgrade Toolkit 26 Tickets Ended $99.00 $6.44

Share The DBA Skills Upgrade Toolkit by Eddie Wuerch

Event Details

The DBA Skills Upgrade Toolkit

Course Description

This seminar provides a full day of tips, techniques, and scripts operational DBAs can use to better plan, monitor, and control their environments and simplify their lives. ‘Accidental’ DBAs and those experienced with other RDBMS products but new to SQL Server will find this seminar particularly useful.

Course Outline

Chapter 1: Databases, Filegroups, Files, and Disk

-          Optimal Windows Server settings for SQL Server

-          Database settings that affect performance

-          SQL I/O for the DBA:

o   Filegroups and files: How many? How Big? Why?

o   RAID levels and the effects on performance and uptime

o   Capacity planning and monitoring

 

Chapter 2: TempDB

-          What is TempDB

-          Optimizing TempDB

-          #temp tables vs. table variables

 

Chapters 3 & 4: The Transaction Log, Backups, and Recovery

-          What is the transaction log?

-          How is it used?

-          Sizing and optimizing the transaction log

-          The Restore Strategy – RPO/RTO

-          Database backup types

-          Transaction log backups and the log chain

-          Backup and restore performance

 

Chapter 5: Performance Monitoring

-          Waits

-          File performance

-          CPU monitoring

-          Deadlock trapping

-          PerfMon

-          Tracing

 

The seminar includes a printed book with all slides and notes. A collection of scripts is also provided covering the demos and full monitoring scripts.

Have questions about The DBA Skills Upgrade Toolkit by Eddie Wuerch? Contact SQL Saturday Tampa

When & Where



Hampton Inn & Suites / Ybor City

, FL 33605

Friday, March 9, 2012 from 9:00 AM to 5:00 PM (PST)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.