I recently found out that I will be one of the speakers at SQLSaturday #66 on February 12 in Colorado Springs. I will be talking about hardware evaluation and selection, and the full abstract is below:
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.
Here is the full schedule:
Time Slot | Room 1 | Room 2 |
8:00 – 8:15 | Welcome | |
8:15 – 8:45 | First activity | |
8:45 – 9:45 | DEV – 45 new 2005/2008 TSQL features in 45 minutes | ADM – Best Practices for SQL Server on VMWare |
9:45 – 10:00 | Break | |
10:00 – 11:00 | BI – Becoming DAX: An Introduction | ADM – Policy Based Management |
11:00 – 11:30 | Second Activity | |
11:30 – 12:30 | ADM – Securing your SQL Server | BI – Make it fast, make it pretty (SSRS) |
12:30 – 1:30 | PROF – The Modern Resume – Building Your Brand | Lunch – Meet the experts\WIT tables |
1:30 – 2:30 | DEV – SQL Server Performance tuning | ADM -Hardware 201: Selecting Database Hardware |
2:30 – 3:00 | Third Activity | |
3:00 – 3:15 | Break | |
3:15 – 4:15 | BI – A Data Mining Solution | DEV – Managing the Data Tier Application Lifecycle |
4:15 – 5:00 | Final Activity\Ending Comments |
This should be another fun SQLSaturday event, and I hope to see you there!
