So How Does BI Workload Impact the Database Engine? Part I

The use of BI technologies to package and deliver data to business users requires a well-maintained infrastructure to support a demanding workload. In this first of two sessions, SQL Server MVPs  Denny Cherry and Stacia Misner review how the various components fit together and how decisions about where to install each component affect overall performance. We'll also discuss how day-to-day BI operations such as ETL and how to optimize data warehouse load operations.
Presented by Stacia Misner at SQLBits X
  • Downloads
  • SpeakerBIO

    Stacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She founded Data Inspirations in 2006. Stacia is a SQL Server MVP, MCITP, MCTS, and a frequent speaker at technical conferences, including Professional Association for SQL Server (PASS) and SQL Server Magazine’s Connections. She has over 14 years of experience in business intelligence architecture and implementation, data warehousing, OLAP, ETL, and reporting and analysis. During that time, Stacia has authored or co-authored multiple books about Microsoft business intelligence technologies.
  • Video