Database Configuration and Tuning

Real World Database Configuration and Tuning
Speaker: Kevin Kline, SQL Server MVP
This multi-module full day seminar covers the spectrum of best practices as they relate to database and application design and configuration, implementation, maintenance and performance tuning.
This session has a special focus on IT organizations with large SQL Server deployments.
Bare metal tuning of server and disk configuration
Benchmarking performance
Physical machine versus virtual machine deployment
Database conceptual… Show more design and normalization through to physical deployment of databases, indexing and partitioning
Understanding SQL Server query performance
Identifying performance bottlenecks and resolving performance issues
Automating as much as possible so that life gets easier!
Prerequisites: Basic understanding of SQL Server architecture and administration.
Â
Â

Show less