Log-in / Create Account  
PASS Summit 2011 Session List
Click here to search this conference.

PASS Summit 2011 Learning Center

Access the PASS Summit 2011 streaming sessions, free for all 2011 attendees and PASS members. Scroll down to view all sessions, sorted by track, or jump to the track of interest using the links below:

Application and Database Development
BI Architecture, Development and Administration Topics
BI Client Reporting and Delivery Topics
Enterprise Database Administration and Deployment
Professional Development
SQL Azure

Select the session you wish to view. On each detail page, click on the "Login" link at the bottom of the page to login and access the session.

Please note that in order to view the PASS Summit 2011 streamed sessions, you must use Internet Explorer.

Display sessions grouped by:
Track Session Code Speaker Date

Track: 

Purchase PASS Summit 2011 DVD's Here
Application and Database Development
 BI Architecture, Development and Administration Topics
 BI Client Reporting and Delivery Topics
 Enterprise Database Administration and Deployment
 Professional Development
 SQL Azure
 Special Ops Tour attendee special offer
 

Application and Database Development

AD-100  "BEGIN...COMMIT" is Not Enough: Understanding Transactions   
AD-101-M  SQL Connectivity Leadership Unplugged   
AD-204  T-SQL : Bad Habits to Kick   
AD-205  Let Service Broker Help You Scale Your Application   
AD-206  3rd Normal Form: That's crazy talk!!!   
AD-207-S  DMOs as a Shortcut for Performance Tuning   
AD-208-S  Five Physical Database Design Blunders and How to Avoid Them   
AD-209  No More Bad Dates: Best Practices for Working With Dates and Times   
AD-210  Visualizing Your Indexes - the Science behind the Art   
AD-211-M  Developing Multi-Platform Applications for Microsoft SQL Server and Azure   
AD-213-M  Database Development with SQL Server Data Tools Code Name "Project Juneau"   
AD-215-M  What's New in ADO.NET4.5   
AD-216-M  Overview of Big Data on Windows and Windows Azure   
AD-302-HD  The Ultimate Session on Indexing   
AD-303  Parameter Sniffing: the Query Optimizer vs. the Plan Cache   
AD-304  Where should I be Encrypting my Data   
AD-305  Rewrite Your T-SQL for Great Good!   
AD-306  Working With XML In SQL Server   
AD-307  Database Design Fundamentals   
AD-308-S  T-SQL Awesomeness - 3 Ways to Write Cool SQL   
AD-309-S  Bug or Feature?   
AD-310-S  Joins, SARGability and the Evils of Residualiciousness   
AD-311-M  Migrating non-SQL Server Databases to SQL Server and the Cloud   
AD-312-M  Project Apollo: How to use Columnstore Indexes to Revolutionize Query Performance on your Data Warehouse   
AD-313-M  SQL Server Engine Team - Unplugged   
AD-314  Tips and Tricks for Writing Better Queries   
AD-315-M  What is New for T-SQL in SQL Server Code Name "Denali" & SQL Azure   
AD-316-M  What does it take to add MDS to your Data Warehouse / Data Mart?   
AD-317-M  SQLCAT: SQL Server Tier-1 Mission Critical Application at Progressive — Architecture Deployed and Lessons Learned   
AD-318  Characteristics of a Great Relational Database   
AD-400  Physical join operators   
AD-401  Code-First Development with the Entity Framework   
AD-402  Evolution of Security: What's New in Denali   
AD-403-S  SQL Server Execution Plans — From Compilation To Caching To Reuse   
AD-404-M  Performance Tuning of Spatial Queries in SQL Server: Deep Dive into Spatial Indexing   
AD-405-M  SQLCAT: Building Highly Scalable Cloud Analytics Solutions with SQL Azure and StreamInsight (Project Austin)   
AD-500-S  Query Tuning Mastery: Zen and the Art of Workspace Memory   
AD-501-M  Best Practices and Performance Tuning of XML Queries in SQL Server   
Back to Top
BI Architecture, Development and Administration Topics

BIA-100  ETL Smackdown: PowerShell vs SSIS -- with Aaron Nelson   
BIA-200  MDS in Denali   
BIA-201  HIPAA, ICD10, HL7, and... Data Warehousing?   
BIA-202-S  Zero to Cube - Fast Track to SSAS Development   
BIA-203-S  One Hard Problem: Multivalued Dimension Relationships   
BIA-204-M  What's New in SQL Server Code Name "Denali" Analysis Services   
BIA-205  Getting Started with RS   
BIA-303-HD  So How Does the BI Workload Impact the Database Engine?   
BIA-304  Building a Reporting Services Framework   
BIA-305  Common Analysis Services Design Mistakes and How to Avoid Them   
BIA-306  Anger Management: Overcoming SSIS Deployment and Configuration Challenges   
BIA-307  Vertipaq vs OLAP: Change Your Data Modeling Approach   
BIA-308  Delivering KPIs with Analysis Services   
BIA-309  Using ColumnStore/Vertipaq Indexes in Denali   
BIA-310-S  Introduction to Data Mining in SQL Server Analysis Services   
BIA-311-S  Upgrading SSIS to Denali —Management Considerations and Best Practices   
BIA-312  SSIS vs T-SQL: Loading a Data Warehouse   
BIA-313-M  Building the Perfect BI Semantic Model for Crescent   
BIA-314-M  Cloud BI - SQL Azure Reporting   
BIA-315-M  Deploying and Managing SQL Server Code Name "Denali" PowerPivot v2 for SharePoint   
BIA-316-M  Developing and Managing a Business Intelligence Semantic Model (BI SM) in SQL Server Code Name "Denali" Analysis Services   
BIA-317-M  Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"   
BIA-318-M  What's New in Microsoft StreamInsight?   
BIA-319-M  Data Quality Services in SQL Server Code Name "Denali" — A Closer Look   
BIA-402  Many-to-Many Relationships in DAX   
BIA-403  SSIS in the Enterprise   
BIA-404  Add It Up: Analysis Services Aggregations   
BIA-405  Advanced Components in SSIS   
BIA-406-S  Temporal Snapshot Fact Table   
BIA-407-M  Enriching your BI Semantic Models with Data Analysis Expressions (DAX)   
BIA-408-M  SQLCAT: Tier-1 BI in world of Big Data   
BIA-409-M  SQLCAT: Configuring and Securing Complex BI Applications in a SharePoint 2010 Environment with SQL Server Code Name "Denali"   
Back to Top
BI Client Reporting and Delivery Topics

BID-100  PowerPivot - A cool reporting tool!   
BID-101  Developers are from Mars, Report Servers are from Venus   
BID-201  See the Future with Visual Predictive Analytics   
BID-202  Reporting Services 201: From Basic To WOW!   
BID-203  Preventing the Oh, Poop! Reporting Situation   
BID-204  Information: Are you blinded by the Light?   
BID-205-M   End-user alerting with SQL Server Code Name "Denali" Reporting Services   
BID-206-M  Deep Dive into the new features of PowerPivot in SQL Server Code Name "Denali"   
BID-207-M  Reporting with Crescent: [Your organization]'s Got Talent   
BID-208-M  What's New in SQL Server Code Name "Denali" Reporting Services   
BID-209  Data Visualization: Chaos, or Patterns you haven't recognized yet?   
BID-300  Building a Reporting Infrastructure in SharePoint with SSRS 2008 R2   
BID-301  Reporting Services Techniques and Tricks   
BID-302  Multidimensional Reporting: MDX Essentials for Report Design   
BID-303  Creating Business Intelligence Dashboards with PerformancePoint Services 2010   
BID-304-S  Visual Report Design: Bringing Sexy Back   
BID-305-S  End-to-End SQL Server PowerPivot   
BID-306  Intelligent Laziness with the Management Data Warehouse — why work harder, when you can work smarter?   
BID-307-M  Configuring SQL Server "Denali" Reporting Services with SharePoint 2010   
BID-308-M  Project Crescent Solution Configuration   
BID-309-M  Tips and Tricks for Building Rich Reporting Services Reports   
Back to Top
Enterprise Database Administration and Deployment

DBA-102  The Top Ten SQL Server Skills You Need   
DBA-103  Understanding Storage Systems and SQL Server   
DBA-104-S  BLITZ! The SQL - More One Hour SQL Server Takeovers   
DBA-105  Policy-Based Management in a Nutshell   
DBA-202-HD  Performance Tuning Made Easy   
DBA-203  What's New in SQL Server "Denali" - Engine and Tools   
DBA-205  Utility Databases   
DBA-207  Baseline Basics: Where to Start, What You Need   
DBA-209  Paging DR Availability, You're Wanted In The Recovery Room   
DBA-211  The Periodic Table of Dynamic Management Objects   
DBA-213-M  Optimize SQL Server for Private Cloud part1   
DBA-214-M  SQL Server Code Name "Denali" AlwaysOn: Solution Overview   
DBA-215-C  Introducing the Microsoft SQL Server 2012 Performance Dashboard Reports   
DBA-216  Evaluate your Daily Checklist Against 100+ instances of SQL Server while you get a cup of coffee   
DBA-217  Solid State Storage Deep Dive   
DBA-218  Dynamic Management Views From the Eyes of Alice   
DBA-302-HD  Scaling SQL Server   
DBA-303  Automate Policy-Based Management using PowerShell   
DBA-304  SQL2008 Query Statistics   
DBA-305  Inside the SQL Server Transaction Log   
DBA-306  Extended Events, Work Smarter Not Harder   
DBA-307  100% Availability without 100% Uptime   
DBA-308  SQL Server Memory Management   
DBA-309  Important Trace Flags That Every DBA Should Know   
DBA-310  Best Practices for Deploying SQL Server on VMware - "What every DBA needs to know to be successful for virtual deployments"   
DBA-311-S  Bad plan! Sit!   
DBA-312-S  Hardware 301: Diving Deeper into Database Hardware   
DBA-313-S  Using Event Notifications in SQL Server 2005/2008   
DBA-314-S  What Happened? Exploring the Plan Cache   
DBA-315-S  Isolated Disasters in VLDBs   
DBA-316-S  More DBA Mythbusters   
DBA-317  Discovering the Plan Cache   
DBA-318  Crash! Boom! Bang! 10 Ways to Blow Up Castle SQL Server and the Techniques that Catch Them   
DBA-319-C  All the Magic Knobs   
DBA-320  Why are we Waiting..   
DBA-321-M  A DBAs Guide to Administering BI Systems   
DBA-322-M  Data Tier Applications in SQL Server Code Name "Denali"   
DBA-323-M  Improving Your PowerShell Productivity   
DBA-324-M  SQLCAT: Optimize SQL Server for Private Cloud part2: Best Practices and Lessons Learned   
DBA-325-M  SQLCAT: SQL Server HA and DR Design Patterns, Architectures and Best Practices using SQL Server Code Name "Denali" AlwaysOn   
DBA-326-M  SQLCAT: What are the Largest SQL Server Projects in the World and how do they Scale   
DBA-327-M  What's New in Manageability for SQL Server Code Name "Denali"   
DBA-328-M  SQLCAT: SQL Server Consolidation at Travelers — How we did it and Lessons Learned   
DBA-329-M  Managing and Gaining Insight in Unstructured Data   
DBA-330-M  SQL Server Code Name "Denali" AlwaysOn: Solution Drilldown   
DBA-331-M  SQL Server Code Name "Denali" AlwaysOn: Active Secondaries   
DBA-332-M  SQLCAT: HA/DR Customer Panel -- SQL Server Code Name "Denali" AlwaysOn Deployment Consideration   
DBA-333-M  Upgrading to SQL Server 2008R2 and SQL Server Code Name "Denali"   
DBA-334-M  Learn about SQL Server Database Consolidation Solutions   
DBA-400  Inside the SQL Server Query Optimizer   
DBA-401  Page and Row Compression: Deep Dive   
DBA-403  Advanced SQL Server 2008 Troubleshooting   
DBA-405  PDW Architecture and Internals   
DBA-406  Tips for handling large data volumes   
DBA-407  SQL Server Storage Engine under the hood: How SQL Server performs I/O   
DBA-408-S  Implementing SQL Server Denali Using Windows Server Core   
DBA-410-M  Data Warehousing: from SMP to MPP using SQL Server Parallel Data Warehouse   
DBA-411-M  Using Correlated Tracing to Diagnose Query Level Performance   
DBA-412-M  What's New in Security for SQL Server Code Name "Denali"   
DBA-413-M  SQLCAT: Enterprise SQL I/O Optimization Best Practices   
DBA-414-M  Are You Smarter Than An MCM?   
DBA-415  Troubleshooting SQL Server with SysInternals Tools   
DBA-416  The Backup Tune-up   
DBA-500-HD  Inside Tempdb (cont)   
Back to Top
Professional Development

LT-100-W  Lightning Talks - Wednesday   
LT-101-T  Lightning Talks - Thursday   
LT-102-F  Lightning Talks - Friday   
PD-101  Understanding Microsoft Certification in SQL Server with Chris Testa-O'Neill, Brent Ozar and Christian Bolton   
PD-102  Data Ownership, Data Stewardship and Data Governance   
PD-103  Meet the Presenter: How to Make a Killer Presentation   
PD-104  Branding Yourself for a Dream Job -The Modern Resume   
PD-200  Are you a Linchpin? Career management lessons to help you become indispensible.   
PD-201  Who's Responsible? The Vendor or the DBA?   
PD-300  Building a Professional Development Plan   
Back to Top
SQL Azure

AZ-100  SQL Azure Sharding with the Open Source Enzo Library   
AZ-101  This Ain''t Your Father's Cloud 
AZ-200  Everything Your Developer Won't Tell You About SQL Azure   
AZ-201-M  SQL Azure - Where We Are Today, and Microsoft's Cloud Data Strategy   
AZ-202-M  Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications   
AZ-300  How to migrate your databases to SQL Azure (and what's new)   
AZ-302-M  SQLCAT: What are the Largest Azure Projects in the World and how do they Scale   
AZ-400-M  Migrating Large Scale Application to the Cloud with SQL Azure Federations   
Back to Top
Copyright © 2011 by MultiView, Inc. All website graphics, text, design, software, and other works are
the copyrighted works of MultiView, Inc. All audio, video, presentation materials, logos and text
are the copyrighted works of their respective owners. All Rights Reserved. Any redistribution or
reproduction of any materials herein is strictly prohibited.