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.
Come spend a session with us while we play games with Reporting Services…literally! Come watch Stacia Misner and Erika Bakse push the limits with what can be built in SSRS.
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.
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.