2008 PASS Community Summit Session List
Click here to search this conference.

PASS Community Summit 2008 Sessions
To access presentation decks or other handouts associated with PASS Summit 2008 sessions, please click on the session from the list below and scroll to the bottom of that particular session page to access the related media.

Display sessions grouped by:
Track Session Code Speaker Date

Track: 

Buy DVD set of All PASS Summit Session Recordings
Application Development
 Business Intelligence
 Database Administration
 Professional Development
 

Buy DVD set of All PASS Summit Session Recordings

Didn’t make all the sessions you were hoping to take in at PASS Community Summit 2008?

With over 150 to choose from, we’re certain there many more sessions you would like to review. Here’s your chance to access all of the great content presented at the largest ever PASS Community Summit in Seattle this past November. One of the key benefits all PASS Summit 2008 attendees receive is the ability to purchase one copy of the Full Conference DVD set, with over 150 dedicated SQL Server sessions for $125 USD until Dec 31, 2008.

The price goes up to $595 USD in the new year so don’t delay your purchase. Non Summit attendees will only have the opportunity to purchase these highly sought after DVDs in February 2009.

Buy NOW! 
Back to Top
Application Development

The primary audience for this track is developers and database administrators who are focused on building and supporting successful applications using SQL Server and related technologies. This track provides the in-depth knowledge from industry experts, as well as other developers who have successfully used the technologies to solve complex tasks and build real solutions. The track is designed to cover all aspects of SQL Server and related application development such as architectural design, coding, testing troubleshooting, eCommerce solutions, data access methods, optimization etc.

AD-201-M  WiE, a Location-Based Social Networking Application Built with SQL Server, SQL Server Data Services, Sync Framework, SQL Server Compact and Virtual Earth.     
AD-202  Big Data: Working with Terabytes in SQL Server     
AD-203  Designing a Secure SQL Server 2008 Solution     
AD-204-S  [Anti]Patterns and [Mal]Practices: Learning to do Things Right by Evaluating How Others Have Done Them Wrong     
AD-205  SQL Server CLR     
AD-206  The dirty dozen... 12 Ways to write badly performing T-SQL     
AD-207-M  Managed user defined types, aggregates and functions demystified     
AD-300-M  Learn more about software + services with SQL Server   
AD-301-M  Take Control of the Enterprise: Effective Solutions for Governing your Environment With Policy Based Management     
AD-302-M  Optimizing bulk operations involving data cleansing and merging with Table-Valued Parameters     
AD-304  Smart Database Design with MVPs Dr. SQL and Paul     
AD-305  Building Data Models with SQL Server 2005 Management Studio     
AD-306-S  Using spatial data in SQL and in clients     
AD-307  XML Data Type Methods in the Real World     
AD-308  Hacking SQL Server     
AD-309  DTS 2000 migration to SSIS...makes financial sense !!     
AD-310-S  Tips & Tricks for Writing Better Queries     
AD-311  SQL Server Indexes   
AD-312-S  Supporting Highly Concurrent Business Processes with SQL Server 2005 and 2008     
AD-314-M  Programming T-SQL in SQL Server 2008, and Beyond!     
AD-315-M  Entity Framework Futures: Empowering the data developer     
AD-316  Much Ado: A Panel Discussion About "Nothing"   
AD-318  Why Normalization Matters     
AD-319  SQL Server User-Defined Functions - The Good, The Bad, The Ugly   
AD-401-M  Integrated Full-Text Search in SQL Server 2008   
AD-402-M  SQL Server 2008: Deep Dive into Spatial Data Type and Indexing     
AD-403-S  Introduction to T-SQL Enhancements in Microsoft SQL Server 2008     
AD-404  Cursors or setbased? Why not both?     
AD-405-S  Table Value Parameters Revolutionize Data Programming!     
AD-406  Test-Driven Development for Database Professionals     
AD-407  Deploying DB Pro to Multiple Environments     
AD-408-M  Building embedded, occasionally connected database applications with SQL Compact     
AD-409  Improving the performance of your enterprise data modeling processes     
AD-410-M  SQL Server 2008 .NET integration programming     
AD-500-M  Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions     
Back to Top
Business Intelligence

Building, deploying and managing a Business Intelligence (BI) solution is critical to staying competitive in today`s economy. This track focuses on the three layers of Microsoft Business Intelligence: data warehousing, reporting and analysis, and performance management. The primary audiences for this track are Business Intelligence developers and database administrators who are focused on designing, implementing and managing Business Intelligence solutions in their organizations or for their clients.

BI-201-M  Incremental data warehouse loads with MERGE and Change Data Capture     
BI-202  How to build an effective Date dimension (in SSAS)     
BI-203-S  Key to MDX formulas in the new (2005/2008) world     
BI-204  Putting the Business in Business Intelligence — Using Business Requirements to Drive DW/BI System Development     
BI-205  Configuring Reporting Services Security Correctly     
BI-206-M  BI Power Hour   
BI-207-M  The future of analysis   
BI-300  Architecting a PerformancePoint Planning Solution     
BI-302-S  High-performance Data Warehouses in SQL Server 2008     
BI-303  Troubleshooting MDX Query Performance     
BI-304  Combining Disparate Data in an SSRS Report     
BI-305-M  Reporting Services 2008 Integration with SharePoint     
BI-306  SSIS Scripting     
BI-307-S  Overcoming SSIS Deployment and Configuration Challenges     
BI-308  Populating a Kimball Method DW with SQL Server and Integration Services 2008     
BI-309-S  Super Reports: One Report for Many Requirements     
BI-311-M  Designing sophisticated and Data visualization rich Reports using Microsoft SQL Server 2008 Reporting Services     
BI-312-M  Integrating Predictive Analysis Throughout the Data Lifecycle     
BI-313-M  Integrated Business Intelligence Solutions with Microsoft SQL Server 2008, Microsoft Office SharePoint Server 2007, and Office Excel 2007   
BI-314-M  Scaling up your data warehouse with SQL Server 2008     
BI-401-A  SQLCAT - Building SSRS SS2008 Large Scale Solutions     
BI-402-A  SQLCAT - Performance Troubleshooting for AS (SS2005, SS2008)     
BI-403-A  SQLCAT - World Record ETL and ELT (SS2005/2008)     
BI-404-A  SQLCAT - Large Scale Relational Data Warehouse Learnings     
BI-406  Do It Right: Best Practices for Analysis Services 2005 and 2008     
BI-407-S  Building an SSIS Management Framework     
BI-408  Unit Testing SSIS Packages     
BI-409  Optimizing Dimension Designs in SSAS     
BI-410  Avoid Slow SSAS Queries: MDX Query Troubleshooting     
BI-411  Creating an SSIS, SSAS and SSRS monitoring solution with SSIS, SSAS and SSRS     
BI-412-S  Performance Tuning SSIS 2005 and 2008     
BI-413-A  SQLCAT - Collecting Analysis Services Performance Data by using Management Data Warehouse, SQL Profiler, and AS DMVs in SSAS 2008     
BI-419  Metadata Integration of Microsoft SSIS, SSAS, and SSRS and Popular Modeling and Design Tools     
Back to Top
Database Administration

The Enterprise Database Administration track is for IT professionals who are faced with the new challenges of the ever-changing database environment and need to be prepared to work efficiently with other professionals involved in and Enterprise Database System. This track addresses the diverse range of topics that DBA`s face when working on the production database environment, as well as when interfacing with application integration, Web integration, capacity planning, database warehousing and security.

AD-303-M  Protecting Your Data — Security from the Application to the Database     
DBA-200-M  Applying Workload Resource Governance with SQL Server 2008     
DBA-201-M  SQL Server Myths: How to Talk About SQL Server to your Oracle DBA Friends   
DBA-203  SCOM and Database Monitoring     
DBA-205  What's the Fuss? Collecting and Analyzing Performance Metrics in SQL Server 2005 and 2008     
DBA-206-C  CSS - Upgrading to SQL Server 2008 - Avoid 'Gotchas' and Known Issues     
DBA-207  So You Inherited The DBA Position; Now What?     
DBA-208  Using PowerShell to Get the Most out of SQL Server     
DBA-209  DBA 101: Best Practices for All DBAs to Follow     
DBA-300-M  Reducing Storage Cost in SQL Server 2008     
DBA-301-M  Disk Partition Alignment: Increase I/O Throughput by up to 10%, 20%, 30% or More     
DBA-302  Storage considerations when running SQL Server in a virtualized environment     
DBA-302-M  Advanced Powershell and SQL Server     
DBA-303  The Most Persistent Microsoft SQL Server Myths: Perceptions and Realities     
DBA-304-S  End-to-End Troubleshooting for SQL Server 2005     
DBA-305  Interpreting Perfmon and Profiler Results with Cloud-Based BI   
DBA-306  Capitalizing on the SQL Server 2005 System Information     
DBA-307  Effectively using the Resource Governor in SQL Server 2008     
DBA-308  Monitoring Object Changes with Event Notification     
DBA-309-S  Business Continuity with Backup and Restore     
DBA-310-S  Guiding Your Query Plans     
DBA-311  Effective usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008     
DBA-312  A SQL Server DBAs Guide to CLR Integration   
DBA-314  Benchmarking Server Hardware Platforms for SQL Server Performance     
DBA-315  XML in My Database! Implementation on a Live e-Store Using SQL Server 2005     
DBA-316-S  Upgrading to SQL Server 2008: Lessons learned and recommended practices     
DBA-317  Identifying Performance Bottlenecks     
DBA-318-S  Capturing and Analyzing File & Wait Stats     
DBA-319-M  Performance Troubleshooting using SQL Server 2008 Management Studio     
DBA-320-M  Advanced Policy-Based Management with Microsoft SQL Server 2008     
DBA-321-M  SQL Server 2008 Failover Clustering     
DBA-321-M (REPEAT)  SQL Server 2008 Failover Clustering - REPEAT SESSION   
DBA-322-M  How to Protect SQL Server with Microsoft Data Protection Manager 2007     
DBA-323-M  SQL Server 2008 on SAN; Lessons Learned and Best Practices     
DBA-323-M (Repeat)  SQL Server 2008 on SAN; Lessons Learned and Best Practices: REPEAT SESSION   
DBA-324-M  SQL Server Tips, Tricks and Techniques from inside Microsoft   
DBA-325-M  SQL Server Development team General Managers unplugged   
DBA-327-C  CSS - Implementing and Supporting SQL 2008 Failover Clustering   
DBA-328-M  ROI of SQL Server 2008: A Presentation by Forrester Research     
DBA-329-A  SQLCAT - Pan-STARRS: Building 100TB+ Scientific VLDBs with SQL Server 2008     
DBA-330-M  Query Editing Enhancements in SSMS That Will Rock Your World     
DBA-331  Automating SQL Server Administrative tasks with PowerShell     
DBA-400-A  SQLCAT - Building HA SQL Server (SS2005/2008) Deployment Solutions Using LL from Cust Deployments     
DBA-401-A  SQLCAT - Building High Performance systems for SQL Server relational (SS2005/2008)     
DBA-402-A  SQLCAT - Security (Auditing, Encryption) -- Data Security, Admin Security     
DBA-403-A  SQLCAT - Overall Lessons Learned from SS2008 Experiences     
DBA-404-A  SQLCAT - Data Compression & Backup Compression Lessons Learned from Customer Deployments     
DBA-405-M  Advanced Troubleshooting with SQL Server Extended Events     
DBA-406-A  SQLCAT - Performance Troubleshooting - MDW / Xevents / etc (2008)     
DBA-407-A  SQLCAT - Service Broker Performance & Scalability Techniques from Real-World Implementations     
DBA-408-M  Understanding and troubleshooting transactional replication performance     
DBA-409-A  SQLCAT - SS2008 developer and ISV experiences     
DBA-410-A  SQLCAT - SQL Server 2008 Virtualization with Windows Server 2008 Hyper-V     
DBA-411-M  Reaching Compliance with SQL Server 2008     
DBA-412  SQL Server 2008 Policy-based Management     
DBA-412-M  Database Unit Test Why-How-Now     
DBA-414  Implementing Partitioned Views with Table/Index Partitioning     
DBA-415-S  Avoiding Stored Procedure Recompilations     
DBA-416-S  Corruption Survival Techniques     
DBA-417  Failure is not an Option, 24x7 OLTP Database Management for VLDB     
DBA-419  Deep Dive Into SQL Server Consolidation     
DBA-420-C  CSS - How it Works: File Streams     
DBA-500-S  Database Governance to the MAX! How to get your SQL Serve ready for F1 (Formula 1) racing   
DBA-502-C  CSS - Debugging the Memory of SQL Server 2008     
Back to Top
Professional Development

Today`s business requirements have given way to a new and bolder work environment. The stresses of this new environment revolve around a constantly changing company structure. Understanding the multi-tiered environment of today`s business has become an ever-increasing challenge to the changing roles of today`s professional. Not only must they meet the demands of this new environment but also keep pace with the latest technical advances, market trends and business advancements. A professional facing this new environment must face the world with a new set of skills almost on a daily basis. This track is designed to provide important information to professional that can help them juggle the demands of this new environment without compromising their technical skills and professional decorum.

PD-200  Team Management Fundamentals     
PD-201  Are you cut out to be a consultant?     
PD-202  Using Emotional Intelligence in Information Technology     
PD-203  Telecommuting     
PD-204  How to manage a Team of Technical Professionals     
PD-205  Writing Technical Articles     
PD-206  Should You Move Into Management?     
PD-207  How to Become an Exceptional DBA     
PD-300-M  Working with Semi-structured data in SQL Server 2008     
Back to Top