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  | [PREVIOUS]  [NEXT]
Sessions Found: 160
Analysis Services the Right Way [200]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Craig Utley
This session offers an in-depth look at each step of the process in creating an SSAS solution using best practices. You'll learn why best practices exist, and the trade-offs you make at each step. You'll see the proper way to create dimensions, learn how and why cube partitions should be used, a road map for good aggregation design, a discussion about cube security, and much more. Craig Utley has been working with the Microsoft BI stack since the betas of SQL Server 7.0 and is a former Program Manager with the Microsoft SQL Server Customer Advisory Team (SQLCAT), where he worked with some of the world’s largest SQL Server data warehouses. He has seen warehouses at over fifty companies worldwide and draws on that experience to give you a no-nonsense approach to building an SSAS solution.

Anger Management: Overcoming SSIS Deployment and Configuration Challenges [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Erik Veerman
It is no secret that a main deficiency of SSIS is deployment. Have you wanted to punch a wall before when trying to move a package from one server to another? You’re not alone. This session will be more than just SSIS deployment anger management. We’ll look at how to overcome the deployment challenges by considering configurations, package and connection security, and deployment approaches. And don’t miss the decision workflows that will help you down the right on choosing the right storage and deployment approaches depending on your situation! But there’s more… you’ll also get a preview of the SSIS server in the next version of SQL Server.

Automating MDS: Techniques, Tips & Lessons [200]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Melissa Coates
This session will focus on importing data into MDS, as well as exporting data from MDS to other systems. Topics include:
* Using built-in stored procedures to import data
* Steps required to fully process and validate imported data
* Handling insert/update/delete situations in the GUI versus automated processes
* Potential difficulties using built-in views to export data
* Additional reports & processes to include as part of an overall solution
* Strengths & limitations of the 2008 R2 version of MDS
* Upcoming MDS changes in Denali.


Avoid environment change headaches with SSIS Package Configurations [200]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Amy Lewis
Come see best practice examples of using the various types of SSIS package configurations to reduce the headaches of recoding your packages due to changes in your environment.

Avoid Slow SSAS Queries: MDX Query Troubleshooting [400]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Craig Utley
Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.

BISM Tabular Basics [200]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Chris Webb
Building a tabular model in BISM is easy! This session will show how you can get up and running with it quickly, even if you've always been put off BI by the complexity of cubes.

Bring me the DMO's: Auditing SQL Server with SSIS [200]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Mike Davis
So your boss just called and said his database has been getting slower for weeks. Wouldn’t it be nice to have a trend analysis of all of the DMO’s to help determine the issue? Well now you can, with SSIS you can monitor all of your servers and databases. Mike will give you a complete BI solution that you can immediately start using to pull in all of the DMO data to a data warehouse and a cube. You will be able to catch trends that indicate problems before the boss calls.

Building a Reporting Services Framework [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): David Darden
Alright… So you've got your data warehouse in tip top condition. Now it's time to deliver a few hundred reports to your customers. Oh, and not just build them… you also need to maintain and improve them over the course of their lifetime. This session will walk you through building robust report templates, managing and maintaining report metadata, and creating a full featured deployment system to make deployments a breeze.


Building a Scale-Out SQL Server 2008 R2 Reporting Services Farm [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Edwin Sarmiento
Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. This session will walk you through building a scale-out SQL Server 2008 R2 Reporting Services farm from the ground up. You’ll be surprised how easy it is to do so that you can start building your own test environment.

Building the Perfect BI Semantic Model for Crescent [300]
Session Category: Regular Session (75 minutes)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Kasper de Jonge, Carl Rabeler
In this session we'll cover the new BI Semantic model capabilities and how you can create the right models for users to create their own insights using Project Crescent, the new Self-Service reporting technology as part of SQL Server code name "Denali".


Page:  of 16  | [PREVIOUS]  [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