New upcoming events across Europe

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

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

SQLpassion

Copyright © 2017 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Go to Top