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