PASS Summit 2009: Program Sessions

Listings of our regular program sessions, by track, can be found below.
Additional sessions will continue to be added on an ongoing basis.

Search by track: Application and Database Development | BI Information Delivery | BI Platform Architecture, Development and Administration | Enterprise Database Administration and Deployment | Professional Development


Application and Database Development

SQL Server 2008 - Create powerful XML Schema collections to validate your XML documents
Jacob Sebastian (beyondrelational.com)

Yes, I'm Actually Using The Cloud
Brent Ozar (Quest Software)

Understanding XQuery
Dejan Sarka (Solid Quality Mentors)

DMV's as a Shortcut to Procedure Tuning
Grant Fritchey (FM Global)

Data Access Layers A road map to smarter, efficient and effective queries
Steve Simon (State Street Corporation)

Enhance your T-SQL to perform better
Joe Webb (WebbTech Solutions, LLC)

What is MS Sync. Framework
Jean-Rene Roy (Technologies Softdesign Inc.)

Super Bowl, Super Load - A Look at Performance Tuning for VLDB''s
Michelle Ufford (GoDaddy)

Advanced Nested Sets model in SQL
Joe Celko (Joe Celko)

SQL Server Efficiencies: Sparse Columns and Filtered Indexes
Don Kiely (Don Kiely)

Solving the Bill of Materials Problem
John Cook (John Cook)

Passing information to SQL Server - Parameters
Andras Belokosztolszki (Oracle)

Tips and Tricks for Using SQL Server 2008 Integrated Full Text Search in a High Volume OLTP Environment
Glenn Berry (NewsGator Technologies)

Database Design
Louis Davidson (CBN)

Panel Discussion: SQL Injection
Arnie Rowland (Westwood Consulting, Inc)
Plamen Ratchev (Tangra, Inc.)

Whats new in SQL Azure
Patric McElroy (Microsoft Corp.)

Building Applications with SQL Azure and Windows Azure
Liam Cavanagh (Microsoft Corp.)
David Robinson (Microsoft Corp.)

Entity Framework 4.0 for DBAs
Alex James (Microsoft Corp.)

What's New in T-SQL Programmability in SQL Server 2008
Tobias Ternstrom (Microsoft Corp.)

Optimizing SQL Server 2008 Applications using Table Valued Parameters, XML and MERGE
Tobias Ternstrom (Microsoft Corp.)

Advanced Physical Database Design for SQL Server 2008
Boris Baryshnikov (Microsoft Corp.)

SQL Server Data-tier Application Lifecycle Management: Why and How
Balaji Rathakrishnan (Microsoft Corp.)

Building Event-driven, Low-latency Applications with Microsoft's Platform for Complex Event Processing
Roman Schindlauer (Microsoft)

SQLCAT: SQL Service Broker: High Performance Distributed Applications in Real World Deployments
Michael Thomassy (Microsoft Corp.)
Chrsta Stelzmuller (MySpace)
Pat Helland (Microsoft Corp.)

PHP Enterprise Ready Solutions Built on SQL Server
Jay Kint (Microsoft Corp.)

Developing Java Applications Against SQL Server 2008
Erin Hardiman (Microsoft Corp.)

Developing with SQL Server Spatial: Deep Dive into Spatial Indexing (90 Mins)
Michael Rys (Microsoft Corp.)

Developing with SQL Server Spatial: Flat Maps to Round Earth
Michael Rys (Microsoft Corp.)

Entity Framework in the .NET Framework 4.0 and Visual Studio 2010
Daniel Simmons (Microsoft Corp.)

Program, analyze and share data with almost any data source using ADO.NET Data Services
Pablo Castro (Microsoft Corp.)

Troubleshooting applications accessing SQL Server
Abirami Iyer (Microsoft CSS)
Lakshmi Jonnakuti (Microsoft CSS)

Understanding time zones and using them effectively in your database applications
Charley Hanania (QS2 AG - Quality Software Solutions)


BI Information Delivery

Enabling Analysis with Excel Services
Stacia Misner (Data Inspirations)

Monitor Your Business with PerformancePoint Services Monitoring and Analytics
Craig Utley (Solid Quality Mentors)

What's new in PerformancePoint Services 2010
Kevin Beto (Microsoft Corp.)
Ola Ekdahl (IT Mentors)

Self-Service Analytics with SQL Server 2008 R2 (Kilimanjaro)
Dave Fackler (Rolling Hills Enterprises, Inc.)
Josh Robinson (Key2 Consulting)

Creating a Digital Dashboard with SQL Server 2008
Brian Larson (Superior Consulting Services)

Adding SSRS Report Bells and Whistles
Jessica Moss (Solid Quality Mentors)

Introducing Reporting Services 2008 R2: Report Builder 3.0 and the new visualization capabilities (Maps, Sparkline, Indicators)
Bob Meyers (Microsoft Corp.)
Sean Boon (Microsoft Corp.)

Introducing PowerPivot for Excel
Amir Netz (Microsoft Corp.)
Julie Strauss (Microsoft Corp.)

Data Analysis Expressions in PowerPivot for Excel 2010
Howie Dickerman (Microsoft Corp.)

Business Intelligence with Excel 2010 and PowerPivot for Excel
Albert Chew (Microsoft Corp.)
Daniel Yu (Microsoft Corp.)

Advanced BI Capabilities in Excel & Excel Services
Diego Oppenheimer (Microsoft Corp.)

Business Intelligence in Microsoft SharePoint Server 2010
Pej Javaheri (Microsoft Corp.)

Advanced Dashboard creation with PerformancePoint Services
Steve Handy (Microsoft Corp.)
Ali Kazazi (Microsoft Corp.)

Introduction to PerformancePoint Services - Creating Dashboards is as easy as 1,2, 3
Jason Burns (Microsoft Corp.)
David Pilo Mansion (Microsoft Corp.)


BI Platform Architecture, Development and Administration

Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Davide Mauri (Solid Quality Mentors Italia)

SQL Server Integration Services and the modern financial institution.
Steve Simon (State Street Corporation)

The DW/BI System Lifecycle Overview the Kimball Approach
Warren Thornthwaite (Kimball Group)

A Checklist of Best Practices for Securing Reporting Services
Stacia Misner (Data Inspirations)

Super Reports: Patterns & Recipes
Paul Turley (Hitachi Consulting)

ETL from the Trenches: Using SSIS in the Real World
Dave Fackler (Rolling Hills Enterprises, Inc.)

Understanding Master Data Management and the Benefits
William McKnight (McKnight Consulting Group)

What All Microsoft BI Developers Need to Know About MDX so that They Can Create Required Business Calculations
Tim Peterson (Solid Quality Mentors)
Nathan Peterson (SDG Computing, Inc.)

Overcoming SSIS Deployment and Configuration Challenges
Rushabh Mehta (Solid Quality Mentors)

SQLBI Methodology
Marco Russo (SQLBI)
Alberto Ferrari (Sqlbi.com)

Custom Security in SQL Server Analysis Services
Marco Russo (SQLBI)

Do It Right: Best Practices for Analysis Services 2005 and 2008
Craig Utley (Solid Quality Mentors)

ETL: The Linchpin for the Complete Data Warehouse
Joy Mundy (Kimball Group)

Building Planning Applications without PerformancePoint
Dan Bulos (Symmetry Corp)

Designing Effective Aggregations in Analysis Services 2008
Chris Webb (Crossjoin Consulting Limited)

SQL Server BI in the Cloud
John Welch (Mariner)

Using Agile Development Techniques with Integration Services
John Welch (Mariner)

Creative Approaches to Large Dimensions in Analysis Services
Reed Jacobson (Hitachi Consulting)

Looking Inside the Beast: Dissecting Complex MDX Formulas
Reed Jacobson (Hitachi Consulting)

SQLCAT: A Preview of PowerPivot Best Practices
Denny Lee (Microsoft SQL CAT)
Dave Wickert (Microsoft Corp.)

SQLCAT: Analysis Services Consolidation & Virtualization
Carl Rabeler (Microsoft SQL CAT)
Josh Caplan (Microsoft Corp.)
Nicholas Dritsas (Microsoft Corp.)

SQLCAT: Madison Overview and Madison Technology Preview Results
Jesse Fountain (Microsoft SQL CAT)
Stuart Ozer (Microsoft Corp.)

Maximize Your SSIS Investment with Tuning Tricks and Tips
Matt Masson (Microsoft Corp.)

Introducing Master Data Services
John Mcallister (Microsoft Corp.)

Advanced Techniques for SSIS Package Development
David Noor (Microsoft Corp.)

Managing PowerPivot
John Hancock (Microsoft Corp.)

Reporting Services - Sharepoint 12 & 14 Integration
Prash Shirolkar (Microsoft Corp.)

Security and Deployment with Reporting Services 2008 R2
Lukasz Pawlowski (Microsoft Corp.)

BI Power Hour
Pej Javaheri (Microsoft Corp.)
Julie Strauss (Microsoft Corp.)
Philippe-Joseph Arida (Microsoft Corp.)
Scott Heimendinger (Microsoft Corp.)
Shahar Prish (Microsoft Corp.)
Thierry D''hers (Microsoft Corp.)

Microsoft Business Intelligence in 2010
Michael Tejedor (Microsoft Corp.)

Overview of Business Intelligence capabilities in SQL Server 2008 & R2
Herain Oberoi (Microsoft Corp.)

An End-to-End Introduction to SQL Server Reporting Services
Sabrena McBride (Microsoft Corp.)

Top customer support issues in Analysis Services 2005/2008 and how to resolve them
John Sirmon (Microsoft CSS)


Enterprise Database Administration and Deployment

DRP101: Learn The Difference Between Your Log And Your Cluster
Brent Ozar (Quest Software)

Storage for the DBA
Denny Cherry (Awareness Technologies)

Gather SQL Server Performance Data with PowerShell
Allen White (Scalability Experts)

DBAs Behaving Badly... Worst Practices for Database Administrators
Rod Colledge (Independant Consultant)

Upgrade to SQL Server 2008 Database Mirroring as fast as you can! For HA and distributed workloads topologies
Paul Bertucci (Database Architechs)

The Problem with Parallelism...
Victor Isakov (SQL Server Solutions)

The magic of replication: Whats new in SQL Server 2008 Replication?
Meir Dudai (Valinor)

Solid State Disks and SQL 2008: High Availability and Performance
Jamon Bowen (Texas Memory Systems)

Securing SQL Server from inside-attacks
Ralf Dietrich (datafino GmbH)
Andreas Wolter (Sarpedon Quality Lab)

Identifying SQL Server Performance Problems Using SQL Trace
Brad McGehee (Red Gate Software)

Opening the SQL Server 2008 Troubleshooting Toolbox: An Introduction to Extended Events
Jonathan Kehayias (OSI Restaurant Partners)

Using Policy Based Management to Mange your Environment
Randy Dyess (Solid Quality Mentors)

Advanced Failover Clustering Installation Techniques with SQL Server 2008 and Windows Server 2008
Allan Hirt (Megahirtz LLC)

Designing and Building Private SQL Server Clouds
Sarah Barela (MaximumASP)
Ryan Jones (MaximumASP)

Resource Governor? What is that?
Peter DeBetta (Microsoft)

Insight into Indexes
Gail Shaw (XpertEase)

Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads
Glenn Berry (NewsGator Technologies)

Transactional Replication: Beyond The Basics
Kendal Van Dyke (Channel Intelligence)

How the Query Optimizer Works
Ben Nevarez (AIG)

Practical Performance Monitoring and Troubleshooting for the graduated beginner but not yet expert.
Joe Yong (Scalability Experts)

The Impact of Native SQL Server 2008 Compression and Encryption on Various Database Workloads
Kevin Guinn (Dell, Inc.)

Securing and Hardening a SQL Server Implementation - Notes from the Field
Ross Mistry (Convergent Computing)

Designing a Highly Available SQL Server Infrastructure - Notes from the Field
Ross Mistry (Convergent Computing)

Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting
Trevor Barkhouse (Terremark Worldwide, Inc.)

To Partition or Not To Partition The questions .. and the answers
Don Vilen (Scalability Experts)

Getting To Know Your Indexes
Jason Strate (Digineer, Inc.)

Don't Wait! Consolidate on SQL Server 2008!
Rick Heiges (Scalability Experts)

SQL Server Execution Plans From Compilation To Caching To Reuse
Maciej Pilecki (Project Botticelli Ltd.)

The Ultimate Free SQL Server Toolkit
Kevin Kline (Quest Software)

Proactive DBA: Manage SQL Server Better
Ross LoForte (Microsoft Corp.)

Using SQL Server 2008 for Performance Tuning
Buck Woody (Microsoft Corp.)

SQLCAT: Addressing Security and Compliance Issues with SQL Server 2008
Denny Lee (Microsoft SQL CAT)
Ayad Shammout (Caregroup Healthcare System)
Il-Sung Lee (Microsoft Corp.)

SQLCAT: Designing High Performance I/O for SQL Server (90 Mins)
Thomas Kejser (Microsoft Corp.)
Mike Ruthruff (Microsoft SQL CAT)

Advanced Policy-Based Management for the Enterprise using the Enterprise Policy Framework (90 Mins)
Lara Rubbelke (Microsoft Corp.)

Disk Partition Alignment: Increase Disk I/O Throughput By 10%, 30%, or More - The Best Kept Secret in SQL Server Disk I/O Performance
Jimmy May (Microsoft Corp.)

SQLCAT: SharePoint on SQL Server - Implementation, Configuration and Tuning
Burzin Patel (Microsoft SQL CAT)
Bill Baer (Microsoft Corp.)
Neeraj Joshi (Microsoft Corp.)

SQLCAT: Customer Experiences with Data Compression
Sanjay Mishra (Microsoft Corp.)
Marcel van der Holst (Microsoft Corp.)
Sunil Agarwal (Microsoft Corp.)

Auditing in SQL Server 2008
Il-Sung Lee (Microsoft Corp.)

SQLCAT: SQL Server Always On Series. Part 3: SQLCAT Customer Deployments, Best Practices & Panel Discussion
Prem Mehra (Microsoft SQL CAT)

Scaling SQL Server beyond 64 hardware threads on Window 2008 R2: Challenges, Scalability numbers, and Best Practices
Pravin Mittal (Microsoft Corp.)
Vitaly Akulov (Microsoft Corp.)

Scaling Online Transaction Processing Applications with SQL Server 2008
Srik Raghavan (Microsoft Corp.)

TempDB Configuration and Management in SQL Server 2008
Dipti Sangani (Microsoft Corp.)

SQL Server Data Warehouse Query Acceleration: Under the Hood
Eric Hanson (Microsoft Corp.)

SQLCAT/SQL Server Consolidation Series - Consolidation and virtualization best practices and recommendations (90 Mins)
Lindsey Allen (Microsoft Corp.)
Madhan Arumugam (Microsoft Corp.)

Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support
Buck Woody (Microsoft Corp.)

Manageability Series: Understand and Troubleshoot with Policy-Based Management and Data Collector
Buck Woody (Microsoft Corp.)

SQL Server Always On Series: Part 2: SQL Server Failover Clustering Deep Dive (90 Mins)
Max Verun (Microsoft Corp.)
Ahmed Bisht (Microsoft Corp.)

SQL Server Always On Series: Part 1: Building a High Availability Strategy for your Enterprise
Gopal Ashok (Microsoft Corp.)
Justin Erickson (Microsoft Corp.)
Vineet Rao (Microsoft Corp.)

SQLCAT: Customer Experiences Deploying Data Warehouse Solutions using the FastTrack Architecture
Stuart Ozer (Microsoft Corp.)
Mike Ruthruff (Microsoft SQL CAT)

SQL Server Consolidation Series - Anatomy of a SQL Server consolidation Project
Clifford Dibble (Microsoft Corp.)
Sung Hsueh (Microsoft Corp.)

SQL Server 2005 / 2008 Performance Tuning and Optimization Techniques (90 Mins)
David Pless (Microsoft CSS)

SQL Server 2008 - What's in for SAP - First Experience and Features used
Clas Hortien (Microsoft Corp.)

Inside SQL Server Wait Types (90 Mins)
Bob Ward (Microsoft)

Implementing and Supporting SQL 2008 Failover Clustering
Shon Hauck (Microsoft CSS)

DBAs and the Dynamic Datacenter of the Future
Noel Yuhanna (Forrester Research)


Professional Development

A Tale of Careers and User Groups
Andy Leonard (Unisys Corporation)

Manage Your DBA Career, Dont Let it Manage You
Brad McGehee (Red Gate Software)

Doing more with less - Dell I/T's 7 steps to a highly effective Database management organization
Ravindra Gurram (Dell Inc)

Social Computing for the Database Professional
Jason Massie (Terremark)
Brent Ozar (Quest Software)

Achieving Work-Life Balance - What does it really mean?
Denise McInerney (Intuit)
Meredith Ryan Smith (TBA)
Wendy Pastrick (TBA)

Working in Management Will Rot Your Brain - How to Stay Technical and Advance Your Career
Rob Garrison (WebMD)

The Accidental Leader
Richard Bolesta (CA)

Soft Skills - Now More Than Ever
Chuck Heinzelman (Big Hammer Data)

Are You Cut Out to be a Consultant?
Rick Heiges (Scalability Experts)

Team Management Crash Course
Kevin Kline (Quest Software)