Maintaining SQL Server 2008 for Experienced DBAs

5 Tage
SQ_ADVADM08


Einführung
Teilnehmer
Voraussetzungen
Seminarziele
Seminarinhalte

Einführung

Dieser Kurs liefert in die Tiefe gehendes Know-how zu den wichtigen Herausforderungen, denen DBAs gegenüber stehen. Wir behandeln dabei Fragen zu Architektur, Datenbankdesign und Disaster Recovery. Security und Concurrency werden ebenso nicht fehlen. Dazu kommen Erörterungen zur Verbesserung der Performance (Indexing und Query Tuning). Den Abschluss bildet der Themenbereich High Availability.

Teilnehmer

Dieser Kurs richtet sich an erfahrene SQL Server Administratoren, die weiter in die Tiefe gehen wollen, als das in üblichen Admin-Trainings getan wird.

Voraussetzungen

Gute SQL Server 2005 Kenntnisse.

Seminarinhalte



Installing and Configuring SQL Server
  • Installation
  • SQL Server Architecture
  • Tools enhancements
  • Central Management Server
Managing Databases and Files
  • Planning Databases
    • Database files
    • Filegroups
  • Optimizing Throughput and Reliability
  • Creating and Managing Databases
  • Table and Indexes Partitioning
  • Data compression
Disaster Recovery
  • BACKUP and RESTORE
    • Backup Types
    • Backup and Restore Best Practice
    • Online Restore
    • Page Restore
    • Backup Compression
  • Database Consistency Errors
    • DBCC CHECKDB
    • Handling DBCC CHECKDB Errors
    • Root Cause Analysis
  • Recovery Troubleshooting Scenarios
    • User Database
    • Repair and Restore Scenarios
    • EMERGENCY Mode
    • Recovering System Databases and the ResourceDB
    • TempDB Issue
Managing a SQL Server Environment
  • Policy Based Management
  • Extended events
  • Automation
    • Jobs
    • Alerts
SQL Server 2008 Security
  • Logins, User and Roles
  • Managing Permissions
  • Transparent Data Encryption
  • Encryption Key Management
  • SQL Server Audit
SQL Server Concurrency
  • Wait Types
    • Latches and Locks
    • IO Wait Types
    • CPU Wait Types
    • Other Wait Types
  • Monitoring Waits and Blocking
  • Identifying the Cause of Blocking
  • Deadlocks
  • Transactions and Locking
    • Transaction Isolation Levels
    • Row Versioning and Snapshot Isolation
    • Locking Hints
    • Best Practice
  • Lock Escalation enhancements in SQL 2008
SQL Server Indexes
  • How Indexes Affect IO
  • Architecture
    • Clustered and Non Clustered Indexes
    • Indexed Views
    • Access Methods and Physical Join Operators
    • Filtered Indexes
  • Index Fragmentation and Monitoring
    • Rebuild versus Reorganize
  • Monitoring Index Usage
Query Optimization
  • Cost based Optimization
  • Query Optimization and Execution Sequence
  • Cardinality and Cost Estimation
  • Statistics in SQL Server
  • Understanding and Analyzing Query Plans
    • Data Access Operations
    • Joins
    • Aggregations
    • Sorts
    • Parallelism
    • Working with Plan Guides and Query Hints
  • Dynamic SQL and Query Execution
Monitoring SQL Server 2008
  • Tools
    • SQL Server Trace and Profiler
    • Dynamic Management Views and Functions
    • Reports
    • Performance Monitor
    • Event Notifications
  • Common Scenarios
  • Implementing a Monitoring Solution
    • Data Collection in SQL Server 2008
    • Implementing a custom Solution
    • Third Party Tools
SQL Server 2008 High Availability
  • Technologies
    • Database Mirroring
    • Log Shipping
    • Failover Clustering
    • Peer to Peer Replication
  • Enhancements in SQL Server 2008
  • Resource Governor
 
04 Oct 2010  -  08 Oct 2010
Austria, Wien - Microsoft, MS Innovation Center

Register(€2250)