Posted by: kurtsh | September 25, 2010

INFO: Microsoft content at the PASS Summit 2010 (SQL Server Conference)

imageIf you’re someone that depends on SQL Server, you really shouldn’t miss the SQL Server PASS Summit, coming up this November.  It’s the premier event for SQL Server architects, solutions builders, and DBAs.

Think of this as the TechEd for people that leverage SQL Server.  As you can see below, despite PASS being an independent organization, our involvement is quite heavy for obvious reasons:

  • Microsoft Keynotes
  • Microsoft Session Topics
  • Microsoft Hands-On-Labs
  • Microsoft Product Pavilion
  • Ask the Experts Tables
  • Chalk-Talk Theater

Details follow.


Microsoft Keynotes

  • Ted Kummert, senior vice president of the Business Platform Division, will begin PASS 2010 by highlighting continued innovation across Microsoft’s business and information platform. In the opening keynote on Nov. 9, Kummert will explore Microsoft’s key technical investments that help solve the toughest issues for various roles across an organization, from IT Professionals to developers. Kummert will explore Mission Critical applications, getting the most out of your datacenter, and the accessibility of Business Intelligence in an effort to deliver on Microsoft’s vision of enabling data platform customers to be more efficient through integrated tools.
  • Tom Casey, General Manager for SQL Server Business Intelligence, will highlight SQL Server 2008 R2 self-service BI customer success stories and also discuss the latest BI advances within the data platform, including the transition of BI to the Cloud.
  • David DeWitt, Technical Fellow leading the Jim Gray Systems Lab, returns as a crowd favorite to speak on SQL Query Optimization 101 (this topic was voted on by last year’s PASS Summit attendees).  Query optimization is the process of compiling a SQL query into an executable plan that is as efficient as possible. While the basic fundamentals for cost-based query optimization were first described in a seminal paper by Pat Selinger of IBM Research in 1979, optimizing complex queries continues to be very challenging 30 years later. In this talk, David DeWitt will describe the fundamentals of query optimization, why it remains a very hard problem today, and present several recent research results that promise to improve the quality of plans produced in the years to come.

Microsoft Session Topics
For the most up to date list of sessions titles, abstracts and speakers, please click here to view the information on the PASS Summit website.

Topic Area

Key Focus Areas

Cloud Computing Platform

Presence: 12 sessions

• Microsoft SQL Azure: fully relational cloud database solution

• Microsoft SQL Azure Data Sync service: connects cloud services with on-premise data

• Codename “Dallas”: authoritative public data sources platform for data and web services

Business Intelligence Platform

Presence: 13 sessions, 1 full-day seminar

• Self-service access to information – Ad-hoc reporting & analytics, visualization & dashboards

• Core BI – Operational Reporting, Enterprise Information Management, OLAP

• Scorecards & Dashboards

• Collaboration, Search, and Business Intelligence

Mission Critical Platform

Presence: 21 sessions, 5 full-day seminars

• Scale your Data Warehouse from 10s to 100s of TB

• Fully integrated software/hardware appliances (OLTP and PDW) for plug-n-play predictability

• Maximizing Availability, Security and Scalability for Mission-Critical systems

• Gain Rapid Insight from High-Speed Data using StreamInsight

Next Generation Application Platform

Presence: 9 sessions

• Data-centric application programming

• Making data access straightforward

• Making data more accessible from the enterprise to lower-tier applications

• Navigating the pitfalls of database programming

Optimized Datacenter

Presence: 8 sessions

• Server consolidation

• Discovery and monitoring of instances and applications

• Easier management of servers and applications

Microsoft Hands-On-Labs
As part of the PASS Summit 2010 experience, we are bringing a large amount of SQL Server based Hands-on-Labs to the Hands-on-Labs area for the upcoming PASS 2010 Summit.  Below is a list of labs that are currently planned for PASS. 



Lab Title


Business Intelligence

Creating Excel 2010 PowerPivot Reports


Business Intelligence

Developing KPI’s and Scorecards with SharePoint 2010 PerformancePoint Services


Business Intelligence

Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services


Business Intelligence

Loading and Preparing Data in the Excel 2010 PowerPivot Client


Business Intelligence

Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services


Business Intelligence

Defining DAX Calculations with Excel 2010 PowerPivot


Business Intelligence

Managing Excel 2010 PowerPivot Solutions in SharePoint 2010


Business Intelligence

Developing and Consuming Report Libraries in SQL Server 2008 R2 Reporting Services


Business Intelligence

Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services


Business Intelligence

SQL Server 2008 R2 – Authoring Reports using Bing Maps Integration with Report Builder 3.0


Business Intelligence

SQL Integration Services – Introduction


Business Intelligence

SQL Integration Services – Intermediate to Advanced


Business Intelligence

Introduction to PowerPivot


Business Intelligence

Reporting Services – Sparklines, DataBars and Indicators



Introduction to SQL Azure for Visual Studio 2010 Developers



SQL Azure: Tips and Tricks



SQL Server 2008 R2 – Implementing Transparent Data Encryption (TDE)



Implementing Policy Based Management



Change Data Capture



Working with Date/Time datatypes



Multi-Server Management



Extracting and Upgrading a Data-Tier Application



SQL Azure -Migrating Databases from SQL Server to SQL Azure



Working with Database SnapShots



Create a Windows Server 2008 R2 MSDTC Cluster



Install a SQL Server 2008 +SP1 clustered instance



Creating and Deploying a Data-Tier Application



Managing Change in Data Tier Application Projects in Visual Studio 2010



Querying Events in SQL Server 2008 R2 StreamInsight using LINQ



Working with the SQL Server 2008 R2 StreamInsight Event Flow Debugger



Working with an End-to-End StreamInsight Application



Install a clustered instance of SQL Server 2008 R2 on Windows Server 2008 R2 Failover Cluster



SQL Server 2008 R2 – Table and Index Partitioning



Upgrading to SQL Server 2008 R2 from SQL Server 2000



Upgrading to SQL Server 2008 R2 from SQL Server 2005



Resource Governor



SQL Server 2008 R2- Compliance


Business Intelligence

Bare Metal Part 1


Business Intelligence

Bare Metal Part 2


Business Intelligence

Bare Metal Part 3

Microsoft Product Pavilion
The Microsoft Product Pavilion will host a number of product demonstration kiosks, the Product Pavilion Showcase Theater, and an information desk staffed by Microsoft product managers and developers as well as industry experts and speakers.

The Product Pavilion Showcase Theater Schedule will feature 30-60 minute sessions/demos from the kiosk/topics below as well as our Product Pavilion Hardware Sponsor, Hewlett Packard.

Kiosk Name

Microsoft® SQL Server® Data Warehousing

Microsoft® SQL Server® Mission Critical

Microsoft® SQL Server® OLTP Database

Microsoft® SQL Server® Data Integration

Managed Self Service Business Intelligence

Microsoft SQL Server Reporting Services

Microsoft SQL Server Analysis Services

Microsoft SharePoint Insights

Microsoft SQL Azure

Windows Azure AppFabric

Microsoft codename “Dallas”

OData & Entity Framework

Microsoft Learning – Training & Certification


Ask the Experts Tables
Building on the momentum of last year’s successful PASS Summit, the PASS will have 10 Ask the Experts tables available to answer attendee questions and provide demos.

Table Description

Focus Areas

SQL Server Business Intelligence

Self-Service BI, Excel Services, PerformancePoint Services, SSAS,

OLAP and Data Mining

Data Warehousing

SQL Server 2008 DW,  Fast Track Data Warehouse, Project Madison,

Compression, Partitioning, Performance

SQL Server Reporting Services

Report Design, Reporting Services Management, Reporting Services

& SharePoint Integration

SQL Server Integration Services

High-Speed Connectivity, DTS to SSIS Migration

Data Development

Sync Framework, Entity Framework, LINQ, ADO.NET, ADO.NET Data

Services, ODBC, OLE DB,TSQL, PHP Driver, JDBC Driver, Oslo, M,

Quadrant and Repository, SQL Azure

SQL Server Programmability

T-SQL, Spatial, XML, Filestream, Full-Text Search, Service Broker,

Sparse Columns, Filtered Indexes, Hierarchy ID

High Availability, Virtualization, Consolidation

Clustering, Mirroring, Log Shipping, Data Recovery, Replication,

Hyper-V™, What to consider while setting up SQL for virtualization,

best practices and guidelines, Use of virtualization for HA

(Host clustering–Windows team), Live migration and other

provisioning–Windows team

Manageability, Security, Compliance

Setup, Policy-Based Management, Data Collector, PowerShell™,

Management Studio, Encryption, Auditing, Compliance

Performance & Scalability

Optimizer, Shared Databases, Resource Governor,


Architecture, Design, Project Discussion, Customer Learnings

Chalk-Talk Theater
PASS will be hosting this year’s chalk-talk theater inside the Technical Learning Center in the Expo Hall at the Summit.  There will be 8 Microsoft chalk-talks this year, with topics ranging from Cloud BI to the revamped SQL Server Master certification


%d bloggers like this: