Session 1
Section A: Automating Databases
· Automation Benefits
· Automation Options
· Securing SQL Server Agent
· Configuring SQL Server
· Jobs
· Operators
· Alerts
· Scripting Jobs
Section B: Creating SQL Agent Jobs
· Viewing Scripts
· Creating New Jobs
· Creating Steps
· Scheduling Jobs
· Notifications
· Job Activity Monitor
· Dynamic Management Views
Section C: Database Maintenance Plans
· Assessing System Dependencies
· Backup Strategies
· Recovery Time
· Index Maintenance
· Data Integrity Checks
· Best Practices for Automating
Section D: Creating a Database Maintenance Plan
· New Maintenance Plan
· Adding Tasks
· Configuring Tasks
· Saving Tasks
· Maintenance Plan Wizard
Section E: Documenting the Environment
· SQL H2 Tool
· Microsoft Operations Manager (MOM)
· Microsoft Systems Management (SMS)
· SQL BPA
Section F: SQL Server Integration Services
· Using SSIS
· Defining ETL
· Transforming Data
· Data Transfer Tools
· Package Control Flow
· Data Flow Task
· SSIS Tools
· SSIS Packages
· Securing SSIS Packages
· SSIS and DTS
Section G: Creating SSIS Packages
· Import and Export Wizard
· Table Copy
· Saving Packages
· Control Flow
· Data Flow
· Other Tabs
· Creating New Packages
Section H: Replication
· Defining Replication
· Replication Types
· Replication Agents
· Choosing Replication Monitoring Tools
· Replication Monitor
Section I: Reporting Services
· Defining Reporting Services
· Configuration Manager
· Automating Best Practices
· Managing Report Services Databases
· Connecting to Reporting Services
· Creating Reports
· Viewing Report Web Sites
Session 2
Section A: Performance Monitoring Tools
· Pinpointing Performance Issues
· Methodology
· Baselines
· Creating a Baseline
· Ways to Monitor
· Dynamic Management Views
· SQL Server Profiler
· Error Logs
Section B: System Monitor
· Add Counters
· Physical Disk
· Memory
· Network Interface
· Processor
· SQL Server Objects
· Counter Averages
· Counter Logs
Section C: Activity Monitor
· Process Information
· Locks by Process
· Locks by Object
Section D: Working With Profiler
· Launch Profiler
· Creating Traces
· Selecting Events
· Using Locks
· Stored Procedures
· Running Traces
· Filter Results
· Deadlock Graph
Section E: Best Practices
· Performance Monitor
· Profiler
· Comparing Test Results
· Choosing a Monitoring Tool
Section F: Object Performance Issues
· Questions to Ask
· Resource Bottlenecks
· Tempdb Bottlenecks
· Query Performance
· Bottlenecks
· Locking and Blocking
Section G: Using Profiler With System Monitor
· Matching Traces
· Comparing Results
Section H: Choosing What to Monitor
· Accessing Methods
· Statistics
· Transactions
· Locks
· Determining Profiler Issues
Session 3
Section A: Query Optimization
· Query Environment
· Query Execution Plan
· Database Options
· Other Query Checks
· Circular Process
· Query Review
· Query Environment Review
· Implement Solution
· Optimization Model
Section B: Database Engine Tuning Advisor
· DTA Purposes
· DTA Uses
· DTA Recommendations
· Launching DTA
· Analyzing Queries
· Join Query
· DTA Analysis
Section C: Troubleshooting Connectivity Issues
· Connectivity Methodology
· Server-Side Issues
· Client and Server Issues
· Network Device Issues
· Connectivity Troubleshooting Process
· Authentication Troubleshooting Process
· SQL 2005 Endpoints
Section D: SQL Configuration Tools
· Services and Connections
· Feature Configuration
· Configuration Manager
Section E: Troubleshooting Data Issues
· Data Methodology
· Data Integrity Troubleshooting
· Torn Pages
· Detecting Torn Pages
· View Torn Pages
· Page Verify Best Practices
· Single-Page Restores
· Restoration Steps
Section F: Troubleshooting Concurrency Issues
· Concurrency Methodology
· Blocking
· Deadlocks
· Blocking and Deadlock Tools
Section G: Managing Concurrency
· Transactions
· Lock Types
· Lockable Resources
· Isolation Levels
· Transaction Levels
· Dirty Reads
· Non-Repeatable Read
· Phantom Reads
· Transaction Guidelines
Session 4
Section A: High Availability Solutions
· Overview
· Availability Scale
· High Availability Technologies
· Failover Clustering
· Log Shipping
· Database Mirroring
· Transactional Replication
Section B: Implementing High Availability
· Steps to Implementation
· Minimum Requirements
· SQL Versions
· Failover and Physical Configuration
· Management and Client Access
Section C: High Availability Requirements
· Costs
· Availability Goals
· Additional Costs
· Technical Constraints
· Non-Technical Constraints
· Failover/Failback
· Availability Metrics
· Financial Impact
Section D: High Availability Weaknesses
· Clustering Weaknesses
· Using RAID
· Other Clustering Weaknesses
· Log Shipping Weaknesses
· Collation Settings
· Database Mirroring Weaknesses
· Replication Weaknesses
· Storage Technology Weaknesses
Section E: Mixing High Availability Solutions
· Log Shipping and Clustering
· Log Shipping and Replication
· Log Shipping and Database Mirroring
· Database Mirroring and Clustering
· Replication and Clustering
· Replication and Database Mirroring
· Counting the Costs
Section F: Linked Servers
· Defining Linked Servers
· Link by Stored Procedures
· Security Considerations
· Linked Server Stored Procedures
· Linked Server Restrictions
· Linked Server Queries
· Creating Linked Servers
· Test Connection
