“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.
“Isn’t That Spatial?”
Isn’t that Spatial” is a 30 minute whirlwind tour of the spatial features introduced in SQL Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.
This meeting should be a lot of fun, and I hope to see you there!