July 2011

Featured Presentation

SQL Server Execution Plans - From Compilation To Caching To Reuse

Speaker: Maciej Pilecki

Summary: Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it’s also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we will discuss in details the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse and aging. You will leave this session with full understanding of how to improve your server’s performance by increasing execution plan reuse (or how to avoid reuse in case this is necessary).

About Maciej: Maciej Pilecki (Twitter: @DrHouseOfSQL) is a SQL Server Most Valuable Professional (MVP), Microsoft Certified Master in SQL Server 2008, Microsoft Certified Trainer and Senior Consultant with Project Botticelli. He has many years of international experience in Microsoft SQL Server database development, optimization and troubleshooting. He spends most of his time travelling around the world either advising his many customers on how to improve performance and reliability of their databases, or sharing the lessons learned with conference and user group audiences worldwide, where he is a popular and highly rated speaker. His favourite topics are the internals of the SQL Server database engine, including: SQLOS, Storage Engine and Query Optimizer and Performance Tuning.


Pre-Meeting Presentation

Dimensional Modeling Fundamentals

Speaker: (Video replay from 2010 PASS Summit DVDs)

Summary: A well designed dimensional model provides the best performing, most flexible, and most easily understood data architecture for the DW/BI system. The dimensional model underlies every successful Microsoft-based DW/BI project. This is true both for the relational platform, leveraging the Star Join optimization in SQL Server 2008 database engine, and for Analysis Services which was fundamentally re-architected in 2005 to support true dimensional models. This session covers the key concepts in dimensional modeling, including facts, dimensions, change-tracking with slowly changing dimensions, junk dimensions, mini dimensions, and bridge tables. We look at examples of each concept, and of several dimensional models for different business functions and industries. We’ll also explore the primary differences between 3rd normal form models and dimensional models.


Back to Top