Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.
PHOTO CREDIT: Pat Wright

 

 

PASS Summit 2011 Sessions

You can browse all sessions or use filters to search for sessions you are interested in. The Keyword filter lets you enter a term to search for in the session title or abstract. The Category drop-down lets you set the session type (such as Regular session), and the Track drop-down lets you specify which topic track you want to search. You can also filter by speaker name and session skill level. To start a new search or return to the list of all sessions, simply click the Clear button.
Keyword:
Category:
Track:
Speaker:
Level:
Page:  of 16  |   [NEXT]
Sessions Found: 160
"I See a Control Flow Tab. Now What?" [100]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Andy Leonard
This highly-interactive, demo-intense presentation is for database professionals and developers who are just getting started with SSIS or want to know more about SSIS package development. Attend and learn how to build SSIS packages from the ground up from SQL Server MVP and author Andy Leonard!

5 Key Concepts for Defensive T-SQL Programming [100]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): David Stein
Do you have a database is missing foreign keys, improperly normalized, or allows nulls in inappropriate fields? I'll describe T-SQL programming techniques and habits which can protect you.

A BI Developer’s Guide to Dimensional Dating: Date Dimension Best Practices [200]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Ben Holcombe
The date dimension is one of the most important dimensions in your data warehouse and often the most overlooked. In this session we will review the best practices and common mistakes for modeling a multilingual date dimension with multiple calendar hierarchies . From there we will learn how to load the date dimension in a single SSIS Data Flow operation and then move to the cube where we will leverage named sets to determine common business time horizons such as the current day, current month, last month, year to date, year over year, rolling months and so on.

By the end of this session you will have an end to end understanding of how leverage dates to satisfy end user usability requirements while maintaining operational efficiency. A sample solution will be available that includes an SSIS package and cube project.


Add It Up: Analysis Services Aggregations [400]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Craig Utley
Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session.

Advanced Analysis Services Development [400]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): David Darden
Analysis Services has become the tool of choice for many organizations to quickly deliver ad hoc reporting capabilities to their end users. There are a number of challenges with using standard development best practices on this platform… everything from not quite working with a lot of standard tools to requiring a fairly advanced knowledge of the internals to get the most out of the platform. This session will guide you through techniques, approaches, and solutions to improve the quality and speed with which you can deliver robust solutions on this platform in your environment.


Advanced Components in SSIS [400]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Tim Mitchell
Spend a couple of hours creating data flows in SSIS and you'll quickly figure out how things work - initialize a connection, connect to a source, and write to a destination. Add a few components such as lookups, conditional splits, and derived column transformations, and you've covered the most common functions of data movement in SSIS. Move beyond the basics, though, and you'll find a treasure chest of components that are used much less often, but are no less valuable for some of the off-the-beaten-path ETL needs you'll eventually encounter. In this session, we'll examine some of these less frequently used tools. We'll briefly tour and then demonstrate SSIS components such as the fuzzy lookup, fuzzy grouping, term extraction, term lookup, and the script component.

Advanced SSAS Security [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Chris Webb
This session will show some advanced tips and tricks for Analysis Services:
* How the Allowed Sets and Denied Sets work in dimension security
* How to deny access to an entire level of a hierarchy
* Some of the strange behaviour you can see with cell security, when read permissions behave like read contingent permissions
* Implementing dynamic security using the DLL approach and the measure group approach
* How security works in BISM, and how it compares to the UDM


Agile Data Warehousing with Fast Track [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Doug Barrett
Fast Track is Microsoft’s initiative for creating scalable data warehouses on SQL Server 2008R2. Agile data warehousing is becoming the mainstream approach for data warehouse development as it improves project outcomes by working collaboratively with the business community. This session talks through the considerations for bringing these two topics together to make relevant and up to date data warehouses scale using Fast Track appliances and architectures.

This talk will cover data warehouse architectures, database setup, database refactoring and how to effectively collaborate with the business community. Agile works on the basis that design details can be worked out collaboratively during data warehouse development using design iterations. This may be true, but iterations are different in data warehousing from the classic agile projects because we are dealing with data as well as code.


Analysis Services Advanced Best Practices [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Marco Russo
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time. Other patterns concerns the use of Slowly Changing Dimensions in Analysis Services, evaluate whether to use parent-child hierarchies or not, the consolidation of independent attributes into a junk dimension. Finally, the session will analyze drillthrough issues and solutions and the technique necessary to create special calculation dimensions.

Analysis Services Power Tools [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Darren Gosbell
Analysis Services as a platform provides a number of places where it can be extended using custom code. In this session we will explore the different extension points that are available. We will look at a number free and open source utilities that demonstrate the extensibility of the Analysis Services platform. Finally you will see how you can build your own simple utilities.


Page:  of 16  |   [NEXT]

 

 
 

Why Attend?


■ All SQL Server. All the time

■ Over 170 technical sessions

■ Dr. David DeWitt Keynote

■ 2 days of Pre-Con Seminars

■ Networking with MVPs, experts, and peers

■ Face-to-face support with     Microsoft CSS and SQLCAT

■ Ask the Experts Pods
 

 
 
 

 

 

 


Premier Sponsor

 

Platinum Sponsor