PASS Community Summit 2008: Program Sessions
Listings of our regular program sessions, by track, can be found below.
Additional sessions will continue to be added on an ongoing basis.
Search by track: Application Development | Business Intelligence | Database Administration | Professional Development
Database and Application Development (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.
Supporting Highly Concurrent Business Processes with SQL Server 2005 and 2008
Adam Machanic (SQLblog.com)
Deploying DB Pro to Multiple Environments
Grant Fritchey (FM Global)
SQL Server Indexes
Kimberly Tripp (SQLskills.com)
Tips & Tricks for Writing Better Queries
Joe Webb (WebbTech Solutions, LLC)
DTS 2000 migration to SSIS...makes financial sense !!
Steve Simon (State Street Corporation)
SQL Server CLR
Shawn Weisfeld (INETA)
[Anti]Patterns and [Mal]Practices: Learning to do Things Right by Evaluating How Others Have Done Them Wrong
Peter DeBetta (Microsoft)
Adam Machanic (SQLblog.com)
Hacking SQL Server
Brian Knight (Pragmatic Works)
Bayer White (Flow Focus)
XML Data Type Methods in the Real World
Steve Hughes (XATA Corporation)
Using spatial data in SQL and in clients
Bob Beauchemin (SQLskills)
Test-Driven Development for Database Professionals
Andy Leonard (Unisys Corporation)
Table Value Parameters Revolutionize Data Programming!
Don Kiely (Don Kiely)
Designing a Secure SQL Server 2008 Solution
David Baldauff (Digineer)
Cursors or setbased? Why not both?
Hugo Kornelis (perFact BV)
Introduction to T-SQL Enhancements in Microsoft SQL Server 2008
Itzik Ben-Gan (Solid Quality Mentors)
Building Data Models with SQL Server 2005 Management Studio
Jeremy Kadlec (Edgewood Solutions)
Smart Database Design with MVPs Dr. SQL and Paul
Paul Nielsen (www.SQLServerBible.com)
Louis Davidson (CBN)
Big Data: Working with Terabytes in SQL Server
Andrew Novick (Novick Software, Inc.)
Optimizing bulk operations involving data cleansing and merging with Table-Valued Parameters
Himanshu Vasishth (Microsoft Corp.)
Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions
Michael Rys (Microsoft Corp.)
SQL Server 2008: Deep Dive into Spatial Data Type and Indexing
Michael Rys (Microsoft Corp.)
Integrated Full-Text Search in SQL Server 2008
Fernando Azpeitia Lopez (Microsoft Corp.)
Take Control of the Enterprise: Effective Solutions for Governing your Environment With Policy Based Management
Lara Rubbelke (Microsoft Corp.)
Dmitri Tchikatilov (Microsoft Corp.)
WiE, a Location-Based Social Networking Application Built with SQL Server, SQL Server Data Services, Sync Framework, SQL Server Compact and Virtual Earth.
Olivier Meyer (Microsoft Corp.)
Ed Katibah (Microsoft Corp.)
Elvin Slavik (MapTel)
SQL Server 2008 .NET integration programming
Krzysztof Kozielczyk (Microsoft Corp.)
Managed user defined types, aggregates and functions demystified
Himanshu Vasishth (Microsoft Corp.)
Programming T-SQL in SQL Server 2008, and Beyond!
Jim Hogg (Microsoft Corp.)
Leonard Lobel (twentysix New York)
Building embedded, occasionally connected database applications with SQL Compact
Balaji Rathakrishnan (Microsoft Corp.)
Improving the performance of your enterprise data modeling processes
Vasile D Chiorean (CA)
The dirty dozen... 12 Ways to write badly performing T-SQL
Gail Shaw (XpertEase)
Learn more about software + services with SQL Server
Tony Petrossian (Microsoft Corp.)
Entity Framework Futures: Empowering the data developer
Daniel Simmons (Microsoft Corp.)
Much Ado: A Panel Discussion About "Nothing"
Erland Sommarskog (Erland Sommarskog SQL-Konsult AB)
Allen White (Scalability Experts)
Chuck Heinzelman (Big Hammer Data)
Hugo Kornelis (perFact BV)
James Luetkehoelter (Spyglass LLC)
Michael Coles (Moore-Stephens Business Solutions, LLC)
Why Normalization Matters
Louis Davidson (CBN)
SQL Server User-Defined Functions - The Good, The Bad, The Ugly
Maciej Pilecki (Project Botticelli Ltd.)
Data Warehousing and Business Intelligence (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.
Super Reports: One Report for Many Requirements
Paul Turley (Hitachi Consulting)
Performance Tuning SSIS 2005 and 2008
Brian Knight (Pragmatic Works)
Devin Knight (Idea Integration)
Overcoming SSIS Deployment and Configuration Challenges
Erik Veerman (Solid Quality Mentors)
Creating an SSIS, SSAS and SSRS monitoring solution with SSIS, SSAS and SSRS
Chris Webb (Crossjoin Consulting Limited)
Avoid Slow SSAS Queries: MDX Query Troubleshooting
Craig Utley (Solid Quality Mentors)
SSIS Scripting
Andy Leonard (Unisys Corporation)
Jessica Moss (Solid Quality Mentors)
Combining Disparate Data in an SSRS Report
Brian Larson (Superior Consulting Services)
Optimizing Dimension Designs in SSAS
Dave Fackler (Rolling Hills Enterprises, Inc.)
Troubleshooting MDX Query Performance
Stacia Misner (Data Inspirations)
Configuring Reporting Services Security Correctly
Stacia Misner (Data Inspirations)
High-performance Data Warehouses in SQL Server 2008
Erin Welker (ENF Consulting)
Populating a Kimball Method DW with SQL Server and Integration Services 2008
Joy Mundy (Kimball Group)
Putting the Business in Business Intelligence — Using Business Requirements to Drive DW/BI System Development
Warren Thornthwaite (Kimball Group)
Unit Testing SSIS Packages
John Welch (Mariner)
Building an SSIS Management Framework
Rushabh Mehta (Solid Quality Mentors)
Jessica Moss (Solid Quality Mentors)
Do It Right: Best Practices for Analysis Services 2005 and 2008
Craig Utley (Solid Quality Mentors)
Architecting a PerformancePoint Planning Solution
Dan Bulos (Symmetry Corp)
Key to MDX formulas in the new (2005/2008) world
Reed Jacobson (Hitachi Consulting)
How to build an effective Date dimension (in SSAS)
Reed Jacobson (Hitachi Consulting)
SQLCAT - Collecting Analysis Services Performance Data by using Management Data Warehouse, SQL Profiler, and AS DMVs in SSAS 2008
Carl Rabeler (Microsoft SQL CAT)
Brian Knight (Pragmatic Works)
Maciek Sarnowicz (Microsoft Corp.)
Incremental data warehouse loads with MERGE and Change Data Capture
Ramkumar Krishnan (Microsoft Corp.)
Matt Masson (Microsoft Corp.)
Reporting Services 2008 Integration with SharePoint
Prash Shirolkar (Microsoft Corp.)
SQLCAT - Large Scale Relational Data Warehouse Learnings
Stuart Ozer (Microsoft Corp.)
Thomas Kejser (Microsoft Corp.)
SQLCAT - World Record ETL and ELT (SS2005/2008)
Thomas Kejser (Microsoft Corp.)
Stuart Ozer (Microsoft Corp.)
SQLCAT - Performance Troubleshooting for AS (SS2005, SS2008)
Richard Tkachuk (Microsoft Corp.)
Nicholas Dritsas (Microsoft Corp.)
Thomas Kejser (Microsoft Corp.)
SQLCAT - Building SSRS SS2008 Large Scale Solutions
Denny Lee (Microsoft SQL CAT)
Lukasz Pawlowski (Microsoft Corp.)
Designing sophisticated and Data visualization rich Reports using Microsoft SQL Server 2008 Reporting Services
Carolyn Chau (Microsoft Corp.)
Sean Boon (Microsoft Corp.)
Integrating Predictive Analysis Throughout the Data Lifecycle
Donald Farmer (Microsoft Corp.)
Integrated Business Intelligence Solutions with Microsoft SQL Server 2008, Microsoft Office SharePoint Server 2007, and Office Excel 2007
Julie Strauss (Microsoft Corp.)
Scaling up your data warehouse with SQL Server 2008
Eric Hanson ( (SQL SERVER)) (Microsoft Corp.)
Metadata Integration of Microsoft SSIS, SSAS, and SSRS and Popular Modeling and Design Tools
Christian Bremeau (Meta Integration Technology, Inc.)
John Friedrich (Meta Integration Technology, Inc.)
BI Power Hour
Donald Farmer (Microsoft Corp.)
The future of analysis
Donald Farmer (Microsoft Corp.)
Enterprise Database Administration and Deployment (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.
DBA 101: Best Practices for All DBAs to Follow
Brad McGehee (Red Gate Software)
Capturing and Analyzing File & Wait Stats
Andrew Kelly (Solid Quality Mentors)
Identifying Performance Bottlenecks
Joe Webb (WebbTech Solutions, LLC)
Failure is not an Option, 24x7 OLTP Database Management for VLDB
Thomas Grohser (bwin Interactive Entertainment AG)
Upgrading to SQL Server 2008: Lessons learned and recommended practices
Joe Yong (Scalability Experts)
Corruption Survival Techniques
Paul Randal (SQLskills.com)
Kimberly Tripp (SQLskills.com)
Benchmarking Server Hardware Platforms for SQL Server Performance
Linchi Shea (Merrill Lynch & Co.)
XML in My Database! Implementation on a Live e-Store Using SQL Server 2005
Denise McInerney (Intuit)
Automating SQL Server Administrative tasks with PowerShell
Allen White (Scalability Experts)
Using PowerShell to Get the Most out of SQL Server
Allen White (Scalability Experts)
A SQL Server DBAs Guide to CLR Integration
Greg Low (Solid Q Australia)
Avoiding Stored Procedure Recompilations
Greg Low (Solid Q Australia)
Effective usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008
Satya Shyam K Jayanty (SSQA.net Limited)
So You Inherited The DBA Position; Now What?
Don Vilen (Scalability Experts)
Implementing Partitioned Views with Table/Index Partitioning
Victor Isakov (SQL Server Solutions)
What's the Fuss? Collecting and Analyzing Performance Metrics in SQL Server 2005 and 2008
James Luetkehoelter (Spyglass LLC)
Guiding Your Query Plans
Kalen Delaney (SQLearning)
Business Continuity with Backup and Restore
Peter Ward (WARDY IT Solutions)
SQL Server 2008 Policy-based Management
Sharon Dooley (Dooley Associates, Inc.)
Monitoring Object Changes with Event Notification
Charles Hawkins (Jenzabar, Inc.)
Effectively using the Resource Governor in SQL Server 2008
David Darden ()
Capitalizing on the SQL Server 2005 System Information
Jeremy Kadlec (Edgewood Solutions)
Deep Dive Into SQL Server Consolidation
Allan Hirt (Megahirtz LLC)
Ben DeBow (CounterLogic)
End-to-End Troubleshooting for SQL Server 2005
Kevin Kline (Quest Software)
The Most Persistent Microsoft SQL Server Myths: Perceptions and Realities
Maciej Pilecki (Project Botticelli Ltd.)
Storage considerations when running SQL Server in a virtualized environment
Daren Bieniek (EMC)
Allan Hirt (Megahirtz LLC)
Database Governance to the MAX! How to get your SQL Serve ready for F1 (Formula 1) racing
Rajinder Gill (Scalability Experts, Inc.)
SCOM and Database Monitoring
Thomas LaRock (ING Investment Management)
Database Unit Test Why-How-Now
Jamie Laflen (Microsoft Corp.)
Reaching Compliance with SQL Server 2008
JC Cannon (Microsoft Corp.)
SQLCAT - SQL Server 2008 Virtualization with Windows Server 2008 Hyper-V
Michael Ruthruff (Microsoft Corp.)
Lindsey Allen (Microsoft Corp.)
Mark Pohto (Microsoft Corp.)
Prem Mehra (Microsoft SQL CAT)
SQLCAT - SS2008 developer and ISV experiences
Burzin Patel (Microsoft SQL CAT)
Kun Cheng (Microsoft Corp.)
Understanding and troubleshooting transactional replication performance
Gopal Ashok (Microsoft Corp.)
SQLCAT - Service Broker Performance & Scalability Techniques from Real-World Implementations
Michael Thomassy (Microsoft Corp.)
Ketan Duvedi (Microsoft Corp.)
Raghu Hosahalli (Microsoft Corp.)
SQLCAT - Performance Troubleshooting - MDW / Xevents / etc (2008)
Kevin Cox (Microsoft Corp.)
Bob Ward (Microsoft Corp.)
Disk Partition Alignment: Increase I/O Throughput by up to 10%, 20%, 30% or More
Jimmy May (Microsoft Corp.)
Advanced Troubleshooting with SQL Server Extended Events
Jerome Halmans (Microsoft Corp.)
SQLCAT - Data Compression & Backup Compression Lessons Learned from Customer Deployments
Sanjay Mishra (Microsoft Corp.)
David P. Smith (ServiceU Corporation)
Marcel van der Holst (Microsoft Corp.)
Michael Ruthruff (Microsoft Corp.)
Sunil Agarwal (Microsoft Corp.)
SQLCAT - Overall Lessons Learned from SS2008 Experiences
Mark Souza (Microsoft Corp.)
SQLCAT - Security (Auditing, Encryption) -- Data Security, Admin Security
Il-Sung Lee (Microsoft Corp.)
Ayad Shammout (Caregroup Healthcare System)
Denny Lee (Microsoft SQL CAT)
SQLCAT - Building High Performance systems for SQL Server relational (SS2005/2008)
Juergen Thomas (Microsoft Corp.)
Performance Troubleshooting using SQL Server 2008 Management Studio
Bill Ramos (Microsoft Corp.)
SQLCAT - Building HA SQL Server (SS2005/2008) Deployment Solutions Using LL from Cust Deployments
Prem Mehra (Microsoft SQL CAT)
Ayad Shammout (Caregroup Healthcare System)
David P. Smith (ServiceU Corporation)
Justin Erickson (Microsoft Corp.)
Kaloian Manassiev (Microsoft Corp.)
Sanjay Mishra (Microsoft Corp.)
SQL Server Myths: How to Talk About SQL Server to your Oracle DBA Friends
Darmadi Komo (Microsoft Corp.)
Reducing Storage Cost in SQL Server 2008
Sunil Agarwal (Microsoft Corp.)
Query Editing Enhancements in SSMS That Will Rock Your World
Eric Kang (Microsoft Corp.)
Applying Workload Resource Governance with SQL Server 2008
Ross LoForte (Microsoft Corp.)
Boris Baryshnikov (Microsoft Corp.)
Lindsey Allen (Microsoft Corp.)
SQLCAT - Pan-STARRS: Building 100TB+ Scientific VLDBs with SQL Server 2008
Michael Thomassy (Microsoft Corp.)
Maria A. Nieto-Santisteban (Johns Hopkins University)
Advanced Policy-Based Management with Microsoft SQL Server 2008
Hongfei Guo (Microsoft Corp.)
SQL Server 2008 Failover Clustering
Max Verun (Microsoft Corp.)
Farzan Ratistari (Microsoft Corp.)
Protecting Your Data — Security from the Application to the Database
Il-Sung Lee (Microsoft Corp.)
Raul Garcia (Microsoft Corp.)
How to Protect SQL Server with Microsoft Data Protection Manager 2007
Karandeep Anand (Microsoft Corp.)
Gaurav Gupta (Microsoft Corp.)
SQL Server 2008 on SAN; Lessons Learned and Best Practices
Michael Ruthruff (Microsoft Corp.)
Michael Weiner (Microsoft Corp.)
Prem Mehra (Microsoft SQL CAT)
Advanced Powershell and SQL Server
Buck Woody (Microsoft Corp.)
Mingwu Zhang (Microsoft Corp.)
Muki Murthy (Microsoft Corp.)
SQL Server Tips, Tricks and Techniques from inside Microsoft
Saleem Hakani (Microsoft Corporation)
Cindy Gross (Microsoft)
Devendra Tiwari (Microsoft Corp.)
Sanjay Mishra (Microsoft Corp.)
CSS - Debugging the Memory of SQL Server 2008
Bob Ward (Microsoft Corp.)
CSS - Upgrading to SQL Server 2008 - Avoid 'Gotchas' and Known Issues
Sarah Henwood (Microsoft Corp.)
CSS - How it Works: File Streams
Robert Dorr (Microsoft Corp.)
SQL Server Development team General Managers unplugged
Mark Souza (Microsoft Corp.)
Quentin Clark (Microsoft Corp.)
Samuel Druker (Microsoft Corp.)
Thomas Casey (Microsoft Corp.)
CSS - Implementing and Supporting SQL 2008 Failover Clustering
Shon Hauck (Microsoft CSS)
ROI of SQL Server 2008: A Presentation by Forrester Research
Noel Yuhanna (Forrester Research)
Interpreting Perfmon and Profiler Results with Cloud-Based BI
Brent Ozar (Quest Software)
SQL Server 2008 on SAN; Lessons Learned and Best Practices: REPEAT SESSION
Michael Ruthruff (Microsoft Corp.)
Michael Weiner (Microsoft Corp.)
Prem Mehra (Microsoft SQL CAT)
SQL Server 2008 Failover Clustering - REPEAT SESSION
Max Verun (Microsoft Corp.)
Farzan Ratistari (Microsoft Corp.)
Professional Development Track
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.
How to Become an Exceptional DBA
Brad McGehee (Red Gate Software)
Should You Move Into Management?
Andy Warren (End to End Training)
Steve Jones (SQLServerCentral.com)
Writing Technical Articles
Kathi Kellenberger (Bryan Cave LLP)
How to manage a Team of Technical Professionals
Kat Meadows (El Paso County)
Telecommuting
Michael Lato (DataTamer Inc.)
Using Emotional Intelligence in Information Technology
Edwin Sarmiento (The Pythian Group)
Are you cut out to be a consultant?
Rick Heiges (Scalability Experts)
Team Management Fundamentals
Kevin Kline (Quest Software)
Working with Semi-structured data in SQL Server 2008
Srini Acharya (Microsoft Corp.)
|
|
||
 |
||
|
||