Stacia Varga
blog.datainspirations.com
Stacia Varga has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft data platform technologies since 2000.
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.