If 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.
- TO REGISTER: Please see my previous post about the discounted registration available for my customers at: http://kurtsh.spaces.live.com/blog/cns!DA410C7F7E038D!7821.entry
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
kurtsh
Kurt Shintaku's Blog 