22-25 April 2026 
SQLBits 2012
So How Does BI Workload Impact the Database Engine? Part I
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
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.
Speakers
Stacia Varga's previous sessions
Getting Your Story Straight with Data Visualizations
Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data.
Building a BI Performance Monitoring Solution
Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.
So How Does BI Workload Impact the Database Engine? Part I
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.