I’m very happy today to announce 4 new upcoming SQL Server workshops across Europe within the next months:
 

SQL Server Configuration Day

• Date/Location
  • April 26 in Zurich/Switzerland
  • May 16 in Vienna/Austria
• Agenda
  • Storage Configuration
    • IO Subsystem Tests
    • Disk Partition Alignment
    • RAID Configuration
    • Data-/Log-File Configuration
    • TempDb Configuration
  • CPU/Memory Configuration
    • Resource Governor
    • CPU Affinity Settings
    • Parallelism
    • NUMA Systems
    • Buffer Pool Management
    • Query Memory Configuration
  • Baselining & Monitoring
    • Performance Monitoring
    • Wait Statistics
    • PAL Tools
    • Baselining
  • Virtualization
    • Microsoft Hyper-V
    • VMware ESXi
    • Dynamic Memory
    • Memory Ballooning
    • CPU Co-Scheduling

You can find further information and registration details about the SQL Configuration Day at http://www.SQLpassion.at/events.html.

SQL Server 2012 Deep Dive Days

• Date/Location
  • May 28 – 30 in London/United Kingdom
• Agenda
  • SQL Server 2012 Development
    • SQL Server Data Tools
    • T-SQL Enhancements
    • Windowing Functions
    • File Table
    • Fulltext Indexes
    • Semantic Search
    • Contained Databases
    • SQL Server Integration Services
  • SQL Server 2012 Administration
    • Extended Events
    • Columnstore Indexes
    • LOB Online Index Rebuilds
    • Adding Online Non-NULL Values
    • Database Recovery Advisor
    • Distributed Replay
    • Memory Management
    • Troubleshooting Enhancements
    • Windows Server Core Support
  • SQL Server 2012 High Availability
    • Failover Clustering Enhancements
    • Local TempDb
    • Health Check Policies
    • Failover Policy Levels
    • Indirect Checkpoints
    • Availability Groups
    • Availability Group Listeners
    • Monitoring & Troubleshooting
    • Multiple Secondaries
    • Automatic Failovers
    • Read-Only Connections
    • Backups

You can find further information and registration details about the SQL Server 2012 Deep Dive Days in London at http://www.SQLpassion.at/events.html.
 

SQL Server Performance Tuning & Troubleshooting Workshop

• Date/Location
  • June 13 – 15 in Munich/Germany
• Agenda
  • Performance Tuning with Indexing
    • Database Internals
      • Structures
      • Fixed Data Types
      • Variable Length Data Types
      • Data Modification Internals
    • Execution Plans
      • Understanding Execution Plans
      • Plan Generation & Caching
      • Plan Reuse & Recompilations
      • Physical Join Operators
      • Plan Cache Pollution
    • Indexing
      • Table Scan/Index Scan/Index Seek
      • Clustered/Non-Clustered Index
      • Bookmark Lookups
      • Index Intersection
      • Filtered Indexes
      • Indexed Views
      • Page Fragmentation/Page Splits
      • Fill Factor
      • Searchable Arguments
    • Index Maintenance
      • Statistics
      • Overview
      • Working with Statistics
      • Statistics Maintenance
  • Troubleshooting Looking & Blocking
    • Concurrency
      • Pessimistic
      • Optimistic
      • Isolation Levels
    • Troubleshooting Locking
      • Viewing Locks
      • Lock Granularity
      • Lock Hierarchy
      • Lock Escalation
      • Lock Compatibility
      • Lock Manager Internals
      • Dynamic Management Views
    • Dead Locking
      • Detection
      • Avoidance
      • Troubleshooting
    • Latches
      • Latch Architecture
      • Latch Types
      • Latch Modes
  • Performance Monitoring & Troubleshooting
    • Performance Monitoring Methodology
    • Wait Stats
    • SQL Server Profiler
    • Perfmon
    • Dynamic Management Views/Functions
    • Memory Management
    • TempDb
    • PAL/RML Utilities
    • SQLDiag/SQLNexus

You can find further information and registration details about the SQL Server Performance Tuning & Troubleshooting at http://www.SQLpassion.at/events.html.

Thanks

-Klaus