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. 

SQLPassLabCode

Track

Lab Title

BINHOL201

Business Intelligence

Creating Excel 2010 PowerPivot Reports

BINHOL203

Business Intelligence

Developing KPI’s and Scorecards with SharePoint 2010 PerformancePoint Services

BINHOL204

Business Intelligence

Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services

BINHOL205

Business Intelligence

Loading and Preparing Data in the Excel 2010 PowerPivot Client

BINHOL206

Business Intelligence

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

BINHOL301

Business Intelligence

Defining DAX Calculations with Excel 2010 PowerPivot

BINHOL302

Business Intelligence

Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

BINHOL303

Business Intelligence

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

BINHOL304

Business Intelligence

Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services

BINHOL305

Business Intelligence

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

BINHOL306

Business Intelligence

SQL Integration Services – Introduction

BINHOL307

Business Intelligence

SQL Integration Services – Intermediate to Advanced

BINHOL308

Business Intelligence

Introduction to PowerPivot

BINHOL309

Business Intelligence

Reporting Services – Sparklines, DataBars and Indicators

DBHOL200

Database

Introduction to SQL Azure for Visual Studio 2010 Developers

DBHOL202

Database

SQL Azure: Tips and Tricks

DBHOL202

Database

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

DBHOL203

Database

Implementing Policy Based Management

DBHOL204

Database

Change Data Capture

DBHOL205

Database

Working with Date/Time datatypes

DBHOL206

Database

Multi-Server Management

DBHOL207

Database

Extracting and Upgrading a Data-Tier Application

DBHOL208

Database

SQL Azure -Migrating Databases from SQL Server to SQL Azure

DBHOL209

Database

Working with Database SnapShots

DBHOL301

Database

Create a Windows Server 2008 R2 MSDTC Cluster

DBHOL303

Database

Install a SQL Server 2008 +SP1 clustered instance

DBHOL304

Database

Creating and Deploying a Data-Tier Application

DBHOL305

Database

Managing Change in Data Tier Application Projects in Visual Studio 2010

DBHOL306

Database

Querying Events in SQL Server 2008 R2 StreamInsight using LINQ

DBHOL307

Database

Working with the SQL Server 2008 R2 StreamInsight Event Flow Debugger

DBHOL308

Database

Working with an End-to-End StreamInsight Application

DBHOL310

Database

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

DBHOL311

Database

SQL Server 2008 R2 – Table and Index Partitioning

DBHOL312

Database

Upgrading to SQL Server 2008 R2 from SQL Server 2000

DBHOL313

Database

Upgrading to SQL Server 2008 R2 from SQL Server 2005

DBHOL314

Database

Resource Governor

DBHOL315

Database

SQL Server 2008 R2- Compliance

DBHOL400

Business Intelligence

Bare Metal Part 1

DBHOL401

Business Intelligence

Bare Metal Part 2

DBHOL402

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,

SQLCAT

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


Categories

%d bloggers like this: