sqlpasshistory

ID: 5

PASS Summit 2011

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
10-10-2011 08:30	Tim Mitchell, Andy Leonard	Pre-conference Session (7 hours)	BI Architecture, Development and Administration Topics	A Day of SSIS in the Enterprise
10-10-2011 08:30	Adam Saxton	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	Winning with Kerberos
10-10-2011 08:30	Simon Sabin	Pre-conference Session (7 hours)	BI Client Reporting and Delivery Topics	Advanced Reporting Services
10-10-2011 08:30	Maciej Pilecki	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	Secrets of the SQLOS – Leveraging Microsoft SQL Server Internal Operating System for Improved Scalability and Performance
10-10-2011 08:30	Brent Ozar	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	Virtualization and SAN Basics for DBAs
10-10-2011 08:30	Rob Farley	Pre-conference Session (7 hours)	Application and Database Development	Fixing Queries With Advanced T-SQL Constructs
10-10-2011 08:30	Grant Fritchey, Gail Shaw	Pre-conference Session (7 hours)	Application and Database Development	All about Execution Plans
11-10-2011 08:30	Allan Hirt	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	A Deep Dive into AlwaysOn: Failover Clustering and Availability Groups
11-10-2011 08:30	Stacia Varga	Pre-conference Session (7 hours)	BI Architecture, Development and Administration Topics	MDX, DAX, and DMX: An Introduction to the Languages of BI
11-10-2011 08:30	Jonathan Kehayias	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	Extended Events Deep Dive
11-10-2011 08:30	Devin Knight, Brian Knight	Pre-conference Session (7 hours)	BI Architecture, Development and Administration Topics	Building a Microsoft Business Intelligence Platform
11-10-2011 08:30	Adam Machanic	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	No More Guessing! An Enlightened Approach to Performance Troubleshooting
11-10-2011 08:30	Aaron Nelson	Pre-conference Session (7 hours)	Enterprise Database Administration and Deployment	After 7 Hours You Won't Be Able To Shut Up About PowerShell Either
11-10-2011 08:30	Itzik Ben-Gan	Pre-conference Session (7 hours)	Application and Database Development	Advanced T-SQL for SQL Server 2008 and Denali
11-10-2011 12:00	Don Gabor	Pre-conference Session (7 hours)	Professional Development	Networking to Build Business Contacts (Special 2-hr Workshop)
11-10-2011 18:30	To be Announced	PASS Events (90 minutes)	General	Welcome Reception & Quizbowl
12-10-2011 08:15	David Y, To be Announced	PASS Keynotes (105 minutes)	General	PASS Summit Day One Keynote - Ted Kummert and Rushabh Mehta
12-10-2011 10:15	Glenn Berry	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	Hardware 301: Diving Deeper into Database Hardware
12-10-2011 10:15	Thomas Grohser	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQL Server Storage Engine under the hood: How SQL Server performs I/O
12-10-2011 10:15	Benjamin Nevarez	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Inside the SQL Server Query Optimizer
12-10-2011 10:15	Gail Shaw	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	Bad plan! Sit!
12-10-2011 10:15	Craig Utley	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Add It Up: Analysis Services Aggregations
12-10-2011 10:15	Aaron Nelson, Julie Smith	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	ETL Smackdown: PowerShell vs SSIS -- with Aaron Nelson
12-10-2011 10:15	Mike Morrison	Regular Session (75 minutes)	Application and Database Development	Migrating non-SQL Server Databases to SQL Server and the Cloud
12-10-2011 10:15	Justin Erickson, Santosh Balasubramanian	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQL Server Code Name “Denali” AlwaysOn: Solution Overview
12-10-2011 10:15	Kendal Van Dyke	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Paging DR Availability, You're Wanted In The Recovery Room
12-10-2011 10:15	Luiz Santos, Quetzal Bradley	Regular Session (75 minutes)	Application and Database Development	What's New in ADO.NET4.5
12-10-2011 10:15	Kevin Kline, Buck Woody	Regular Session (75 minutes)	SQL Azure	This Ain't Your Father's Cloud
12-10-2011 10:15	Karen Lopez	Spotlight Session (90 minutes)	Application and Database Development	Five Physical Database Design Blunders and How to Avoid Them
12-10-2011 10:15	Naveen Garg, Srini Acharya	Regular Session (90 minutes)	Enterprise Database Administration and Deployment	Managing and Gaining Insight in Unstructured Data
12-10-2011 10:15	Thierry D'Hers, Pej Javaheri	Regular Session (90 minutes)	BI Client Reporting and Delivery Topics	What's New in SQL Server Code Name "Denali" Reporting Services
12-10-2011 10:15	Paul Turley	Spotlight Session (90 minutes)	BI Client Reporting and Delivery Topics	Visual Report Design: Bringing Sexy Back
12-10-2011 11:30	To be Announced	PASS Events (2 hours)	General	Chapter Lunch
12-10-2011 13:00	To be Announced	PASS Events (90 minutes)	General	SQL Server MVP Deep Dives Book Signing - Wednesday
12-10-2011 13:30	Jes Schultz	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Reporting Services 201: From Basic To WOW!
12-10-2011 13:30	Denise McInerney	Regular Session (75 minutes)	Application and Database Development	“BEGIN…COMMIT” is Not Enough: Understanding Transactions
12-10-2011 13:30	Tobias Ternstrom	Regular Session (75 minutes)	Application and Database Development	What is New for T-SQL in SQL Server Code Name "Denali" & SQL Azure
12-10-2011 13:30		Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	HIPAA, ICD10, HL7, and... Data Warehousing?
12-10-2011 13:30	Ashvini Sharma, John Hancock	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	What's New in SQL Server Code Name "Denali" Analysis Services
12-10-2011 13:30	Andrew Kelly	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQL2008 Query Statistics
12-10-2011 13:30	Wesley Brown	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Understanding Storage Systems and SQL Server
12-10-2011 13:30	Simon Sabin	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Tips for handling large data volumes
12-10-2011 13:30	Mike Walsh, Erin Stellato	Regular Session (75 minutes)	Professional Development	Who's Responsible? The Vendor or the DBA?
12-10-2011 13:30	Chris Shaw	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Utility Databases
12-10-2011 13:30	Don Kiely	Regular Session (75 minutes)	Application and Database Development	Evolution of Security: What's New in Denali
12-10-2011 13:30	Devin Knight	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Common Analysis Services Design Mistakes and How to Avoid Them
12-10-2011 13:30	Gregory Leake, Lynn Langit	Regular Session (75 minutes)	SQL Azure	SQL Azure - Where We Are Today, and Microsoft's Cloud Data Strategy
12-10-2011 13:30	Bob Ward	1/2 Day Sessions (3 hours)	Enterprise Database Administration and Deployment	Inside Tempdb
12-10-2011 13:30	Victor Isakov	1/2 Day Sessions (3 hours)	Application and Database Development	The Ultimate Session on Indexing
12-10-2011 15:00	Robert Davis, Bradley Ball, Andy Leonard, Dev Nambi, Mark S. Rasmussen, Audrey Hammonds, Rob Farley, Sharon Dooley	Regular Session (75 minutes)	Professional Development	Lightning Talks - Wednesday
12-10-2011 15:00		Regular Session (75 minutes)	Application and Database Development	Performance Tuning of Spatial Queries in SQL Server: Deep Dive into Spatial Indexing
12-10-2011 15:00	Joe Webb	Regular Session (75 minutes)	Application and Database Development	Tips and Tricks for Writing Better Queries
12-10-2011 15:00	Tim Mitchell	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Advanced Components in SSIS
12-10-2011 15:00	Lukasz Pawlowski	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	End-user Alerting with SQL Server Code Name “Denali” Reporting Services
12-10-2011 15:00	Yair Helman, Tyler Graham	Regular Session (75 minutes)	Application and Database Development	What does it take to add MDS to your Data Warehouse / Data Mart?
12-10-2011 15:00	Dan Jones	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Improving Your PowerShell Productivity
12-10-2011 15:00	Grant Fritchey	Spotlight Session (90 minutes)	Application and Database Development	DMOs as a Shortcut for Performance Tuning
12-10-2011 15:00	Greg Larsen	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Dynamic Management Views From the Eyes of Alice
12-10-2011 15:00	Jen Stirrup	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Intelligent Laziness with the Management Data Warehouse – why work harder, when you can work smarter?
12-10-2011 15:00	Andy Warren	Regular Session (75 minutes)	Professional Development	Building a Professional Development Plan
12-10-2011 15:00	Adam Jorgensen	Spotlight Session (90 minutes)	BI Architecture, Development and Administration Topics	Zero to Cube - Fast Track to SSAS Development
12-10-2011 15:00	Santosh Balasubramanian	Regular Session (90 minutes)	Enterprise Database Administration and Deployment	SQL Server Code Name “Denali” AlwaysOn: Solution Drilldown
12-10-2011 16:45	Brian Knight	Spotlight Session (90 minutes)	BI Architecture, Development and Administration Topics	Introduction to Data Mining in SQL Server Analysis Services
12-10-2011 16:45	Arie Jones, Andi Comisioneru	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	MDS in Microsoft SQL Server Code Named “Denali”
12-10-2011 16:45	Wesley Brown	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Solid State Storage Deep Dive
12-10-2011 16:45	Wayne Snyder	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Information: Are you blinded by the Light?
12-10-2011 16:45	Olivier Matrat, Cindy Song, Carolyn Chau	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Reporting with Crescent: [Your organization]’s Got Talent
12-10-2011 16:45	Aaron Bertrand	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	What's New in SQL Server "Denali" - Engine and Tools
12-10-2011 16:45	Brent Ozar	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	BLITZ! The SQL - More One Hour SQL Server Takeovers
12-10-2011 16:45	Adam Saxton	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Getting Started with RS
12-10-2011 16:45	Allen White	Regular Session (75 minutes)	Application and Database Development	Let Service Broker Help You Scale Your Application
12-10-2011 16:45	Alberto Ferrari	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Many-to-Many Relationships in DAX
12-10-2011 16:45	Robert Davis, Lara Rubbelke, Cindy Gross, Pam Lahoud, J May	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Are You Smarter Than An MCM?
12-10-2011 16:45	Neil Hambly	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Why are we Waiting..
12-10-2011 16:45	Louis Davidson	Regular Session (75 minutes)	Application and Database Development	Characteristics of a Great Relational Database
12-10-2011 16:45	Vinay Balasubramaniam, Sanjay Nagamangalam	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	What's New in Manageability for SQL Server Code Name "Denali"
12-10-2011 16:45	Andrew Karcher	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Building a Reporting Infrastructure in SharePoint with SSRS 2008 R2
12-10-2011 18:15	To be Announced	PASS Events (2 hours)	General	Exhibitor Reception - Sponsored by DELL
13-10-2011 08:15	To be Announced	PASS Keynotes (105 minutes)	General	PASS Keynote - Quentin Clark
13-10-2011 10:15	Bernardo Zamora, Mark Mortimore, D. Britton Johnston	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Learn about SQL Server Database Consolidation Solutions
13-10-2011 10:15	Julie Strauss	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Deep Dive into the New Features of PowerPivot in SQL Server Code Name “Denali”
13-10-2011 10:15	Sunil Agarwal, Kevin Farlee	Regular Session (90 minutes)	Enterprise Database Administration and Deployment	SQL Server Code Name “Denali” AlwaysOn: Active Secondaries
13-10-2011 10:15	Matt Masson	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Top 10 Things You Didn’t Know About SSIS in SQL Server Code Name "Denali"
13-10-2011 10:15	Michael Kiselman, Yi Liao	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Cloud BI - SQL Azure Reporting
13-10-2011 10:15	Itzik Ben-Gan	Spotlight Session (90 minutes)	Application and Database Development	Bug or Feature?
13-10-2011 10:15	Bob Meyers	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Tips and Tricks for Building Rich Reporting Services Reports
13-10-2011 10:15	Erik Veerman	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Anger Management: Overcoming SSIS Deployment and Configuration Challenges
13-10-2011 10:15	Carl Rabeler, Prash Shirolkar	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Configuring SQL Server “Denali” Reporting Services with SharePoint 2010
13-10-2011 10:15	Steve Jones	Regular Session (75 minutes)	Professional Development	Branding Yourself for a Dream Job -The Modern Resume
13-10-2011 10:15	Allen White	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Automate Policy-Based Management using PowerShell
13-10-2011 10:15	Kendra Little	Regular Session (75 minutes)	Application and Database Development	No More Bad Dates: Best Practices for Working With Dates and Times
13-10-2011 10:15	Klaus Aschenbrenner	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Advanced SQL Server 2008 Troubleshooting
13-10-2011 10:15	Buck Woody	Regular Session (75 minutes)	SQL Azure	Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications
13-10-2011 10:15	Saptak Sen	Regular Session (75 minutes)	Application and Database Development	Overview of Big Data on Windows and Windows Azure
13-10-2011 11:30	Allen Kinsel, To be Announced	PASS Events (2 hours)	General	Women In Technology Luncheon - Make Yourself Heard: How to Ask for What You Want at Work
13-10-2011 13:30	Thomas Grohser	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	100% Availability without 100% Uptime
13-10-2011 13:30	Elad Ziklik	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Data Quality Services in SQL Server Code Name "Denali” – A Closer Look
13-10-2011 13:30	Aaron Bertrand	Regular Session (75 minutes)	Application and Database Development	T-SQL : Bad Habits to Kick
13-10-2011 13:30	Thomas LaRock	1/2 Day Sessions (3 hours)	Enterprise Database Administration and Deployment	Performance Tuning Made Easy
13-10-2011 13:30	Victor Isakov	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Important Trace Flags That Every DBA Should Know
13-10-2011 13:30	John Sterrett, Grant Fritchey, Nicholas Cain, Neil Hambly, Amy Lewis, Niko Neugebauer, Chris Webb, Gail Shaw	Regular Session (75 minutes)	Professional Development	Lightning Talks - Thursday
13-10-2011 13:30	Arie Jones	Regular Session (75 minutes)	SQL Azure	Everything Your Developer Won’t Tell You About SQL Azure
13-10-2011 13:30	Doug Lane	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Developers are from Mars, Report Servers are from Venus
13-10-2011 13:30	Denny Lee, Thomas Kejser	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	SQLCAT: Tier-1 BI in world of Big Data
13-10-2011 13:30	Dave Wickert, Kay Unkroth	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Deploying and Managing SQL Server Code Name “Denali” PowerPivot v2 for SharePoint
13-10-2011 13:30	Don Kiely	Regular Session (75 minutes)	Application and Database Development	Code-First Development with the Entity Framework
13-10-2011 13:30	Joe Webb	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQL Server Locking & Blocking Made Simple
13-10-2011 13:30	Ami Levin	Regular Session (75 minutes)	Application and Database Development	Physical join operators
13-10-2011 13:30	Denny Cherry, Stacia Varga	1/2 Day Sessions (3 hours)	BI Architecture, Development and Administration Topics	So How Does the BI Workload Impact the Database Engine?
13-10-2011 13:30	Andy Leonard	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	SSIS in the Enterprise
13-10-2011 15:00	Isaac Kunen	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	What's New in Microsoft StreamInsight?
13-10-2011 15:00	Gert Drapers, Patrick Sirr	Regular Session (75 minutes)	Application and Database Development	Database Development with SQL Server Data Tools Code-Named “Project Juneau”
13-10-2011 15:00	Kalen Delaney	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	What Happened? Exploring the Plan Cache
13-10-2011 15:00	Rob Farley	Spotlight Session (90 minutes)	Application and Database Development	Joins, SARGability and the Evils of Residualiciousness
13-10-2011 15:00	Adam Jorgensen, Mike Davis	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	SSIS vs T-SQL: Loading a Data Warehouse
13-10-2011 15:00	Carlos Bossy	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	See the Future with Visual Predictive Analytics
13-10-2011 15:00	Louis Davidson	Regular Session (75 minutes)	Application and Database Development	Database Design Fundamentals
13-10-2011 15:00	Tim Ford	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	The Periodic Table of Dynamic Management Objects
13-10-2011 15:00	Cindy Gross	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	All the Magic Knobs
13-10-2011 15:00	Cathy Dumas	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Developing and Managing a Business Intelligence Semantic Model (BISM) in SQL Server Code Name “Denali” Analysis Services
13-10-2011 15:00	Darmadi Komo, Guy Bowerman	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Optimize SQL Server for Private Cloud, Part 1
13-10-2011 15:00	Plamen Ratchev	Regular Session (75 minutes)	Professional Development	Meet the Presenter: How to Make a Killer Presentation
13-10-2011 15:00	Aaron Nelson	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	New Year, New Dirty Dozen PowerShell Scripts
13-10-2011 17:00	Dave Wickert, Bob Meyers	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Project Crescent Solution Configuration
13-10-2011 17:00	Carl Rabeler, Kasper de Jonge	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Building the Perfect BI Semantic Model for Crescent
13-10-2011 17:00	Jonathan Guerin, Amina Saify	Regular Session (75 minutes)	Application and Database Development	Developing Multi-Platform Applications for Microsoft SQL Server and Azure
13-10-2011 17:00	Adrian Bethune	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Data Tier Applications in SQL Server Code Name "Denali"
13-10-2011 17:00	Sanjay Mishra, Justin Erickson, Mike Weiner	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQLCAT: SQL Server HA and DR Design Patterns, Architectures and Best Practices using SQL Server Code Name "Denali" AlwaysOn
13-10-2011 17:00	Lindsey Allen, Xin Jin, Alan Cranfield	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQLCAT: Optimize SQL Server for Private Cloud, Part 2: Best Practices and Lessons Learned
13-10-2011 17:00	Wendy Pastrick	Regular Session (75 minutes)	Application and Database Development	Visualizing Your Indexes - the Science behind the Art
13-10-2011 17:00	Peter Myers	Spotlight Session (90 minutes)	BI Client Reporting and Delivery Topics	End-to-End SQL Server PowerPivot
13-10-2011 17:00	Robert Davis	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	A DBAs Guide to Administering BI Systems
13-10-2011 17:00	Rod Colledge	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Creating Business Intelligence Dashboards with PerformancePoint Services 2010
13-10-2011 17:00	Paul Randal	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	More DBA Mythbusters
13-10-2011 17:00	Jason Strate	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Discovering the Plan Cache
13-10-2011 17:00	Maciej Pilecki	Spotlight Session (90 minutes)	Application and Database Development	SQL Server Execution Plans – From Compilation To Caching To Reuse
13-10-2011 17:00	Herve Roggero	Regular Session (75 minutes)	SQL Azure	SQL Azure Sharding with the Open Source Enzo Library
13-10-2011 17:00	Joy Mundy	Spotlight Session (90 minutes)	BI Architecture, Development and Administration Topics	One Hard Problem: Multivalued Dimension Relationships
13-10-2011 19:00	To be Announced	PASS Events (3 hours)	General	Community Appreciation Party – sponsored by Microsoft and PASS
14-10-2011 07:15	To be Announced	PASS Events (45 minutes)	General	SQL Server MVP Deep Dives Book Signing - Friday
14-10-2011 08:15	To be Announced	PASS Keynotes (105 minutes)	General	PASS Keynote - David J. DeWitt
14-10-2011 10:15	Scott Schommer	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	PowerPivot - A cool reporting tool!
14-10-2011 10:15	Nabeel Derhem	Regular Session (75 minutes)	SQL Azure	How to migrate your databases to SQL Azure (and what's new)
14-10-2011 10:15	Allan Hirt	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	Implementing SQL Server Denali Using Windows Server Core
14-10-2011 10:15	Kasper de Jonge, Howie Dickerman	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Enriching your BI Semantic Models with Data Analysis Expressions (DAX)
14-10-2011 10:15	Jen Stirrup	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Data Visualization: Chaos, or Patterns you haven't recognized yet?
14-10-2011 10:15	Argenis Fernandez	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Troubleshooting SQL Server with SysInternals Tools
14-10-2011 10:15	Jerome Halmans, Rong Wu	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Using Correlated Tracing to Diagnose Query Level Performance
14-10-2011 10:15	Marco Russo	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Vertipaq vs OLAP: Change Your Data Modeling Approach
14-10-2011 10:15	Prem Mehra, Bob Crowley	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQLCAT: SQL Server Consolidation at Travelers – How we did it and Lessons Learned
14-10-2011 10:15	Kevin Cox, Nicholas Dritsas	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQLCAT: What are the Largest SQL Server Projects in the World and how do they Scale
14-10-2011 10:15	Brent Ozar, n/a n/a, Christian Bolton, Pete Harris	Regular Session (75 minutes)	Professional Development	Understanding Microsoft Certification in SQL Server with Chris Testa-O'Neill, Brent Ozar and Christian Bolton
14-10-2011 10:15	Brad McGehee	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Inside the SQL Server Transaction Log
14-10-2011 10:15	Adam Machanic	Spotlight Session (90 minutes)	Application and Database Development	Query Tuning Mastery: Zen and the Art of Workspace Memory
14-10-2011 10:15	Cihan Biyikoglu, Sunil Agarwal, Susan Price, Gus Apostol, Alex Verbitski, Justin Erickson, Ashit Gosalia, Dana Kaufman, Eric Kang, Ciprian Clinciu	Regular Session (75 minutes)	Application and Database Development	SQL Server Engine Team - Unplugged
14-10-2011 10:15	Boris Baryshnikov, Keith Elmore	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Introducing the Microsoft SQL Server Code Name “Denali” Performance Dashboard Reports
14-10-2011 11:30	To be Announced	PASS Events (90 minutes)	General	Lunch - Birds of a Feather - Sponsored by Dell
14-10-2011 12:15	PASS BOD	PASS Events (75 minutes)	General	PASS Board Meet And Greet / Q&A
14-10-2011 13:00	Richard Waymire, Brian Walker	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	PDW Architecture and Internals
14-10-2011 13:00		Regular Session (90 minutes)	Application and Database Development	Best Practices and Performance Tuning of XML Queries in SQL Server
14-10-2011 13:00	Steve Jones	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	The Top Ten SQL Server Skills You Need
14-10-2011 13:00	Jeremiah Peschka	Regular Session (75 minutes)	Application and Database Development	Rewrite Your T-SQL for Great Good!
14-10-2011 13:00	Kevin Kline	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Crash! Boom! Bang! 10 Ways to Blow Up Castle SQL Server and the Techniques that Catch Them
14-10-2011 13:00	Glenn Berry	1/2 Day Sessions (3 hours)	Enterprise Database Administration and Deployment	Scaling SQL Server
14-10-2011 13:00	Cihan Biyikoglu	Regular Session (75 minutes)	SQL Azure	Migrating Large Scale Application to the Cloud with SQL Azure Federations
14-10-2011 13:00	Murshed Zaman, Susan Price	Regular Session (75 minutes)	Application and Database Development	Project Apollo: How to use Columnstore Indexes to Revolutionize Query Performance on your Data Warehouse
14-10-2011 13:00	Chuck Heinzelman, Carl Rabeler	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	SQLCAT: Configuring and Securing Complex BI Applications in a SharePoint 2010 Environment with SQL Server Code Name "Denali"
14-10-2011 13:00	Peter Myers	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Delivering KPIs with Analysis Services
14-10-2011 13:00		Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Preventing the Oh, Poop! Reporting Situation
14-10-2011 13:00	James Luetkehoelter	Regular Session (75 minutes)	Professional Development	Data Ownership, Data Stewardship and Data Governance
14-10-2011 13:00	Prem Mehra, Brian Durkin, David Wilson	Regular Session (75 minutes)	Application and Database Development	SQLCAT: SQL Server Tier-1 Mission Critical Application at Progressive – Architecture Deployed and Lessons Learned
14-10-2011 13:00	Dandy Weyn	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Upgrading to SQL Server 2008R2 and SQL Server Code Name "Denali"
14-10-2011 13:00	Il-Sung Lee	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	What’s New in Security for SQL Server Code Name "Denali"
14-10-2011 14:30	Allen White, Mark Broadbent, David Stein, Doug Lane, Chris Shaw, Craig Purnell, Argenis Fernandez	Regular Session (75 minutes)	Professional Development	Lightning Talks - Friday
14-10-2011 14:30	Raghu Ram, Tracy Daugherty, Chad Mumford, Robin Smith	Regular Session (75 minutes)	Application and Database Development	SQL Connectivity Leadership Unplugged
14-10-2011 14:30	Wayne Snyder	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Using ColumnStore/Vertipaq Indexes in Denali
14-10-2011 14:30	J May, Mike Ruthruff, Thomas Kejser	Regular Session (90 minutes)	Enterprise Database Administration and Deployment	SQLCAT: Enterprise SQL I/O Optimization Best Practices
14-10-2011 14:30	Mark Simms	Regular Session (75 minutes)	Application and Database Development	SQLCAT: Building Highly Scalable Cloud Analytics Solutions with SQL Azure and StreamInsight (Project Austin)
14-10-2011 14:30	Ayad Shammout, Thomas Grohser, Michael Steineke, Sanjay Mishra, David Smith	Regular Session (90 minutes)	Enterprise Database Administration and Deployment	SQLCAT: HA/DR Customer Panel -- SQL Server Code Name "Denali" AlwaysOn Deployment Consideration
14-10-2011 14:30	Bradley Ball	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Page and Row Compression: Deep Dive
14-10-2011 14:30	Davide Mauri	Spotlight Session (90 minutes)	BI Architecture, Development and Administration Topics	Temporal Snapshot Fact Table
14-10-2011 14:30	Thomas LeBlanc	Regular Session (75 minutes)	Application and Database Development	3rd Normal Form: That's crazy talk!!!
14-10-2011 14:30	Kimberly Tripp	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	Isolated Disasters in VLDBs
14-10-2011 14:30	Jeremiah Peschka, Louis Davidson, Stacia Varga, Kevin Kline, Andy Leonard, Brent Ozar, Thomas LaRock, Andy Warren	Regular Session (75 minutes)	Professional Development	Are you a Linchpin? Career management lessons to help you become indispensible.
14-10-2011 14:30	Brian Mitchell, Dandy Weyn	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Data Warehousing: from SMP to MPP using SQL Server Parallel Data Warehouse
14-10-2011 14:30	Erin Stellato	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Baseline Basics: Where to Start, What You Need
14-10-2011 14:30	John Sterrett	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Evaluate your Daily Checklist Against 100+ instances of SQL Server while you get a cup of coffee
14-10-2011 16:15	Jonathan Kehayias	Spotlight Session (90 minutes)	Enterprise Database Administration and Deployment	Using Event Notifications in SQL Server 2005/2008
14-10-2011 16:15	Benjamin Nevarez	Regular Session (75 minutes)	Application and Database Development	Parameter Sniffing: the Query Optimizer vs. the Plan Cache
14-10-2011 16:15	Jason Strate	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Extended Events, Work Smarter Not Harder
14-10-2011 16:15	Paul Turley	Regular Session (75 minutes)	BI Client Reporting and Delivery Topics	Multidimensional Reporting: MDX Essentials for Report Design
14-10-2011 16:15	Sean McCown	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	The Backup Tune-up
14-10-2011 16:15	Kendal Van Dyke	Regular Session (75 minutes)	Application and Database Development	Working With XML In SQL Server
14-10-2011 16:15	Kevin Cox, Michael Thomassy	Regular Session (75 minutes)	SQL Azure	SQLCAT: What are the Largest Azure Projects in the World and how do they Scale
14-10-2011 16:15	Thomas LaRock	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	SQL Server Memory Management
14-10-2011 16:15	Denny Cherry	Regular Session (75 minutes)	Application and Database Development	Where should I be Encrypting my Data
14-10-2011 16:15	Rushabh Mehta	Spotlight Session (90 minutes)	BI Architecture, Development and Administration Topics	Upgrading SSIS to Denali –Management Considerations and Best Practices
14-10-2011 16:15	Jorge Segarra	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Policy-Based Management in a Nutshell
14-10-2011 16:15	Marilice Vidal da Silva	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Creating a Successful Data Architecture with MS SQL Server and CA ERwin Data Modeler
14-10-2011 16:15	David Darden	Regular Session (75 minutes)	BI Architecture, Development and Administration Topics	Building a Reporting Services Framework
14-10-2011 16:15	Wanda He	Regular Session (75 minutes)	Enterprise Database Administration and Deployment	Best Practices for Deploying SQL Server on VMware - "What every DBA needs to know to be successful for virtual deployments"
14-10-2011 16:15	Audrey Hammonds	Spotlight Session (90 minutes)	Application and Database Development	T-SQL Awesomeness - 3 Ways to Write Cool SQL

SessionID: 1508

A Day of SSIS in the Enterprise

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: BI Architecture, Development and Administration Topics

Speaker(s): Tim Mitchell, Andy Leonard

Title: A Day of SSIS in the Enterprise

Description:

Pre-con Registration is Required.

In this day-long seminar, SQL Server MVPs Andy Leonard and Tim Mitchell - along with Microsoft SSIS Developer Matt Masson - demonstrate an SSIS development methodology for teams building enterprise-class solutions. Topics include:

SSIS Design Patterns
ETL Best Practices
Metadata-Driven SSIS Execution
Centralized Logging
SSIS Frameworks
Package Execution Monitoring
Predictive Analytics
Source Control
ETL Auditing
Deployment
Security

The presentation team provides examples of SSIS Design Patterns from their upcoming book: SSIS Design Patterns; actionable demonstrations for building and maintaining SSIS packages in the enterprise; practical patterns that support ETL performance, instrumentation, and deployment; and pragmatic guidance for enterprise ETL Lifecycle Management. They share from their experiences as consultants, developers in the enterprise, and experience managing teams of SSIS developers for years. The information and advice of this team is applicable in organizations of any size.

Read Q&A blog on this session.

SessionID: 1997

Winning with Kerberos

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Enterprise Database Administration and Deployment

Speaker(s): Adam Saxton

Title: Winning with Kerberos

Description:

Pre-con Registration is Required.

We will dive into how Kerberos works and what types of scenarios you will see in your environment when working with the SQL Stack. This will include the SQL Engine, Reporting Services and Analysis Services along with PowerPivot/Excel Calc Services. We will look at how different deployment topologies can affect your configuration and how to plan properly for those. This includes Web Farms and SQL Clusters. I will be using tools such as Network Monitor, SetSPN along with some Active Directory tools to demonstrate how to configure and diagnose issue that may occur in your environment.

You will walk away with a checklist for what you need to do to configure Kerberos correctly as well as an understanding of what tools are available to you to help diagnose issues when you get into trouble.

This session will include (but not limited to) the following areas:

• Breaking down the Service Principal Name (SPN) • Constrained Delegation vs. Full Delegation • SQL Kerberos Configuration • Analysis Services Kerberos Configuration • Reporting Services Kerberos Configuration • Web Farm and Cluster Considerations • How PowerPivot using Excel Calc Services within SharePoint can affect you • A look at Claims Auth and how that affects Kerberos

So, bring your questions and your tiger blood, and we will delve into the complex topic that is Kerberos.

SessionID: 1659

Advanced Reporting Services

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: BI Client Reporting and Delivery Topics

Speaker(s): Simon Sabin

Title: Advanced Reporting Services

Description:

Pre-con Registration is Required.

The Advanced Reporting Services Seminar will enable you to develop visually rich reports that will meet the needs of your business. Almost anything is possible with Reporting Services and in this seminar you will learn how to achieve those difficult tasks. The seminar is based on SQL 2008 but will, where possible, show you how to achieve the same in SQL 2005. We will also highlight what’s coming up in Denali. The scenarios that we will cover are:

Building an enterprise reporting suite
Re use of report components
Dashboard interaction
Report layout and Exporting reports
Document production Topics that will be covered are,
Handling Parameters, Multi select, defaulting, passing to queries, displaying on a report
How to produce formatted documents How to have rich formatted text (fonts, colors, text sizes) on the report, how to combine with data (mail merge), how to generate formatted data from SQL Server
Nesting of chart items to provide a rich experience. This will include the reference
The chart control in depth Handling multiple aligned charts, combining chart types, adding trend lines, handling common axes types.
Exporting data to PDF and excel Common pitfalls and ways to get round them. How to get the correct layout.
How to template your report How to control formatting from outside of the report, customising logos etc After this seminar you will be able to achieve almost anything your users demand of you and your reports in an efficient manner.

Read Q&A blog on this session.

SessionID: 1618

Secrets of the SQLOS – Leveraging Microsoft SQL Server Internal Operating System for Improved Scalability and Performance

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Enterprise Database Administration and Deployment

Speaker(s): Maciej Pilecki

Title: Secrets of the SQLOS – Leveraging Microsoft SQL Server Internal Operating System for Improved Scalability and Performance

Description:

Pre-con Registration is Required.

Delivered by an expert on the subject, this seminar will make you familiar with one of the most mysterious component of Microsoft SQL Server – its own internal built-in operating system, or SQLOS. SQLOS is little known and even less documented. It provides operating-system-like services to other components running within the engine and forms a foundation of SQL Server scalability, reliability and performance. As the scalability requirements increase and hardware becomes more and more powerful, SQLOS’ role grows more and more important – and so does our need to understand its internals. During the course of the day, we will cover all aspects of SQLOS – from the basics of its architecture, through thread scheduling, memory management and Resource Governor, to troubleshooting, Extended Events and advanced SQL Server configuration. Through a series of lectures and demonstrations, you will become familiar with all aspects of its operations and how it enables SQL Server to take advantage of modern, powerful hardware architectures with many CPUs and vast amounts of memory available. You will also learn how to diagnose and troubleshoot advanced performance issues on such servers, including tips and tricks that can make a big difference in performance of high-end servers under heavy load.

SessionID: 1122

Virtualization and SAN Basics for DBAs

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Enterprise Database Administration and Deployment

Speaker(s): Brent Ozar

Title: Virtualization and SAN Basics for DBAs

Description:

Pre-con Registration is Required.

These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.

If you've seen (and liked) Brent's one-hour session on this topic, you'll like the pre-con. He goes into more depth and detail, showing examples and live demos to prove points about memory, storage, and CPU. You'll leave ready to challenge your SAN and VMware admins.

Read Q&A blog on this session.

SessionID: 1204

Fixing Queries With Advanced T-SQL Constructs

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Application and Database Development

Speaker(s): Rob Farley

Title: Fixing Queries With Advanced T-SQL Constructs

Description:

Pre-con Registration is Required.

Have you inherited queries that are not your own, and are finding that performance isn’t so great? Removing cursors in favor of set-based queries is useful, but even set-based queries can perform poorly. Understanding the impact that various constructs can have on a query plan could be key to resolving many of these issues.

In this seminar, irrepressible SQL MVP Rob Farley will take a look at some real-life queries and take the audience through examples of constructs that can have significant effects on tuning. This will include complex nested joins, join simplification, procedural functions, SARGability v residuality with predicates, better execution plan reading, start-up parameters, force hints, complex sorting, ORs, effective Dynamic SQL, GROUP BY v DISTINCT, unique indexes, temporary tables, APPLY considerations, and more. You'll discover profoundness in things you thought you knew, and you'll even see when a covering index that returns a single row can be a bad thing.

This will be a day spent in Management Studio, not PowerPoint. If you want to know how to persuade the Query Optimizer to do a better job of running your query, this day is for you. The examples will apply to a variety of versions, with most of it being useful even in a SQL 2005 environment.

Read Q&A blog on this session.

SessionID: 1245

All about Execution Plans

Back to calendar

Event Date: 10-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Application and Database Development

Speaker(s): Grant Fritchey, Gail Shaw

Title: All about Execution Plans

Description:

Pre-con Registration is Required

The key to understanding how SQL Server is processing your queries is the execution plan.

This full day session focuses on the execution plan. We will start right at the beginning and talk about the compile process. We’ll also go over how, and more importantly, why, plans are stored in cache and how they are removed.

We’ll spend time exploring the key differences between actual and estimated plans, and why those descriptions are more than a little misleading. We’ll also show you assorted methods to obtain a query's execution plan and what the differences and tradeoffs of each are.

A full day class on execution plans would not be complete without spending time learning to reading them. You’ll learn where to find useful information in execution plans, what the common operators are and how to decipher the sometimes cryptic messages the plans are sending to you. We'll also debunk some myths surrounding query operators and execution plans.

Pre-con Registration is Required.

At PASS 2010 after the public release of CTP1 of SQL Server Denali, the product team demonstrated a replacement for SQL Profiler built on top of Extended Events. The writing is on the wall for SQL Trace and the future of diagnostic profiling in SQL Server is Extended Events. In this workshop you will learn Extended Events from the ground up; from the original implementation in SQL Server 2008 to the enhancements that have been made in SQL Server Denali that redefine data collection for troubleshooting in SQL Server.

Extended Events provide more information about the operations of SQL Server than have ever before been available in the product. Unfortunately, there is a significant learning gap between Extended Events and SQL Trace; and the lack of a UI has only made the learning curve that much steeper. This full-day deep dive workshop will explain the basic concepts of extended events, spin that information into some basic patterns, and build on those patterns to create complex custom functionality that will prepare you for the future. Learn firsthand from the developer of the SSMS Addin for Extended Events in SQL Server 2008 how to leverage Extended Events in your own environment.

SessionID: 1468

Building a Microsoft Business Intelligence Platform

Back to calendar

Event Date: 11-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: BI Architecture, Development and Administration Topics

Speaker(s): Devin Knight, Brian Knight

Title: Building a Microsoft Business Intelligence Platform

Description:

Pre-con Registration is Required.

In this session, you'll learn from author and SQL Server MVP Brian Knight how to build a data warehouse for your company and support it with the Microsoft platform. We'll start with how to design and data model a data warehouse including the system preparation. Then, we'll quickly jump into loading the data warehouse with SSIS. After SSIS, you're ready to roll the data up and provide slice and dice reporting with SSAS. Brian walks through cube development and enrichment with things like key performance indicators, which are essential for your future dashboards. Lastly, Brian covers how to report against the data warehouse with SSRS, including a primer in how to write MDX queries against the SSAS cube. Make sure you bring your own optional laptop as you'll be able to follow Brian in the session as he designs, loads and reports against the data warehouse with you. Update session description: Read Q&A blog on this session.

SessionID: 1627

No More Guessing! An Enlightened Approach to Performance Troubleshooting

Back to calendar

Event Date: 11-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Enterprise Database Administration and Deployment

Speaker(s): Adam Machanic

Title: No More Guessing! An Enlightened Approach to Performance Troubleshooting

Description:

Pre-con Registration is Required.

Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution?or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when. In this full day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues. All of this will be illustrated through complete demonstrations that will teach you how to drill from high-level problem detection all the way to specific spot in a query plan or deeper?pinpointing the exact problem and helping you to quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.

Read Q&A blog on this session.

SessionID: 1737

After 7 Hours You Won't Be Able To Shut Up About PowerShell Either

Back to calendar

Event Date: 11-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Enterprise Database Administration and Deployment

Speaker(s): Aaron Nelson

Title: After 7 Hours You Won't Be Able To Shut Up About PowerShell Either

Description:

Pre-con Registration is Required.

Think you’re too busy to learn PowerShell? Even a little PowerShell will free up time to tackle many of your DBA, developer and BI tasks. This session covers the “How” and “Why” Data Professionals world-wide are turning to PowerShell to manage their SQL Server environments. You’ll learn to complete common tasks like: checking database space, last backup date, table sizes and server/database configuration settings. We will explore deploying new users, groups, tables and columns. We’ll build on these fundamentals to tackle multi-server tasks we can automate with SQL Agent. We’ll include reports to monitor your environment. We’ll dive into advanced topics like gathering Performance Counters, detecting worst performing queries, scripting out and comparing databases, importing data from websites, atom feeds, and spreadsheets; all with a very small amount of code. We’ll also cover parameter binding, splatting, remote jobs, remote installs, and SQLPSX in depth to maximize functionality and keep you productive. We’ll wrap things up with some language nuances that will help you avoid getting bogged down. This is a hands-on workshop; bring a laptop if you can. No previous PowerShell experience is required for this session. The afternoon will be spent touring the many capabilities and scripts available throughout the community. The intent of this session is to take you from PowerShell Zero to PowerShell Hero, joining the other champions of PowerShell in the SQL Server community!

SessionID: 1017

Advanced T-SQL for SQL Server 2008 and Denali

Back to calendar

Event Date: 11-10-2011 08:30 - Category: Pre-conference Session (7 hours) - Track: Application and Database Development

Speaker(s): Itzik Ben-Gan

Title: Advanced T-SQL for SQL Server 2008 and Denali

Description:

Pre-con Registration is Required.

You’re a T-SQL developer or DBA and you learned most of what you know about T-SQL by the seat of your pants. You can handle day-to-day T-SQL querying and programming tasks in a reasonable manner, but you’re looking for better and more efficient solutions. This seminar is for you. It covers common T-SQL querying and programming tasks and shows polished, optimal techniques to handle those. Some of the techniques that you will learn in this seminar are very recent developments. You will learn how to utilize T-SQL constructs available in SQL Server 2008 in creative and efficient ways. You will also get introduced to new T-SQL features planned in the next major release of SQL Server—code-named Denali, and see how you will be able to improve your solutions in the near future. There are lots of exciting new T-SQL features planned in SQL Server Denali—some quite profound—and knowing about them ahead can make you better prepared, affecting how you right code today.

Read Q&A blog on this session.

# #### SessionID: 1380 # Networking to Build Business Contacts (Special 2-hr Workshop) #### [Back to calendar](#id-5) Event Date: 11-10-2011 12:00 - Category: Pre-conference Session (7 hours) - Track: Professional Development ## Speaker(s): Don Gabor ## Title: Networking to Build Business Contacts (Special 2-hr Workshop) ## Description: ### Pre-con Registration is Required.

Are you attending the PASS SUMMIT for the first time, consider yourself a shy networker or want to take better advantage of these conference benefits?

• Meet and connect with the “movers and shakers” in the SQL community • Discuss industry trends and technical innovations with MVPs and other experts • Turn informal contacts into mutually beneficial professional relationships • Uncover career-boosting opportunities • Plus, make new friends and reconnect with old colleagues

Revised with new networking exercises, tips, techniques and strategies, Don Gabor will guide you step-by-step through the networking process. You’ll learn how to confidently connect with other conference attendees, have more fun mingling and build profitable professional relationships that will pay off for years to come. Take-aways include how to:

• Break the ice and remember names • Meet people in small and large groups • Keep the conversation going and change topics • End conversations and leave a positive and professional impression • Work the room and join other conversations • Use social media to follow up and build business relationships

Each workshop attendee will receive an autographed copy of Don’s best-seller book, How to Start a Conversation and Make Friends.

This is a special 2-hour networking workshop from 3:00PM - 5:00PM on Tuesday, October 11th, 2011.

Please note that the registration cost for this session is $70.00.

SessionID: 2136

Welcome Reception & Quizbowl

Back to calendar

Event Date: 11-10-2011 18:30 - Category: PASS Events (90 minutes) - Track: General

Speaker(s): To be Announced

Title: Welcome Reception & Quizbowl

Description:

PASS Summit 2011 will kick off with the always-fun Welcome Reception, including the popular annual Quizbowl game and two speed networking sessions hosted by networking expert Don Gabor.

Quizbowl, sponsored by SQLSENTRY Organized by the PASS Virtual Chapters and hosted by Louis Davidson and Tim Ford, this year's Quizbowl will feature four teams of SQL Server pros. Each team will have 1 person from the crowd to be part of their team. Join us at the Welcome Reception and watch these experts prove their SQL Server knowledge.

Team 1: Jes Borland, Lara Rubbelke Team 2: Erin Stellato, Argenis Fernandez Team 3: Rob Farley, Jason Strate, Jonathan Kehayais Team 4: Andy Leonard, Chuck Heinzelman

Great prizes to be won, courtesy of SQL Sentry, Inc:

Grand Prize 32GB iPad 2 with Smart cover 2nd prize $100 American Express gift card 3rd prize $75 American Express gift card 4th prize $50 American Express gift card 5th prize $50 American Express gift card

Speed Networking with Don Gabor: “Connecting in a New York Minute” Make new professional contacts at the PASS Summit Welcome Reception faster than you ever thought possible. Listen for the announcement to attend one of networking expert Don Gabor’s 20-minute speed networking sessions. Be ready to deliver your elevator speech, exchange business cards, and rocket your career to new heights.

SessionID: 2131

PASS Summit Day One Keynote - Ted Kummert and Rushabh Mehta

Back to calendar

Event Date: 12-10-2011 08:15 - Category: PASS Keynotes (105 minutes) - Track: General

Speaker(s): David Y, To be Announced

Title: PASS Summit Day One Keynote - Ted Kummert and Rushabh Mehta

Description:

Ted Kummert

Senior Vice President, Business Platform Division Microsoft Corp.

Join Ted Kummert as he shares his unique insight and perspective on the technology changes facing SQL Server professionals today and how SQL Server is continuing to meet those challenges. With increasing data types, massive data volumes, new user requirements and cloud computing, we are embarking on a new journey with even greater challenges. Taking a look at what is possible today, and what is coming tomorrow, Kummert will show how Microsoft is answering the challenges of managing data and turning information into business insights. Through exciting demonstrations, you’ll see the continued innovation in Microsoft’s information platform and learn more about the upcoming launch of SQL Server Code Named “Denali.”

About Ted Kummert:

Ted Kummert is responsible for leading the product strategy and development of an integrated application platform - including database and application servers, cloud services, and data programmability and modeling technologies.

Products delivered by BPD include Microsoft SQL Server, Microsoft SQL Azure, Microsoft BizTalk Server, Windows Server AppFabric and Windows Azure platform AppFabric, Windows Communication Foundation, and Windows Workflow Foundation.

Since joining Microsoft in 1989, Kummert has led several product development organizations. He served as corporate vice president for the Security, Access and Solutions Division, responsible for Windows Server Terminal Services, Microsoft Internet Security & Acceleration Server, Microsoft Forefront Server Security for Exchange and Microsoft Small Business Server. He held the role of corporate vice president of the Business Process and Integration Division, where he was responsible for products including BizTalk Server, Microsoft Commerce Server and Microsoft Host Integration Server.

Description:

In this presentation, you’ll learn about the five blunders, how to find them as well as many tips on how to avoid them. You learn how to talk about and defend your design recommendations and how to ensure that you have the information to demonstrate they are the right designs for your project.

Do your users have the same old, mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns, best practices and visuals that pack more usable information into fewer, more usable reports. Use Reporting Services and other Microsoft BI tools to create dynamic, browse-able reports that answer important business questions at a glance and then let them explore the details to gain business insight and take action.

Sure, Business Intelligence is all the rage but you don’t have to invest in an entire BI platform to have fresh, usable reports. These design techniques apply to enterprise analytic solutions and smaller-scale operational reporting.

SessionID: 2137

Chapter Lunch

Back to calendar

Event Date: 12-10-2011 11:30 - Category: PASS Events (2 hours) - Track: General

Speaker(s): To be Announced

Title: Chapter Lunch

Description:

Connect with community leaders in your geographical area, and find SQL Server events and learning opportunities happening right in your back yard! Meet and eat with PASS Chapter Leaders and peers who can help you become more involved in your local SQL Server community. Join us on Wednesday for some great networking opportunities.

What is New for T-SQL in SQL Server Code Name "Denali" & SQL Azure

Back to calendar

Event Date: 12-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: Application and Database Development

Speaker(s): Tobias Ternstrom

Title: What is New for T-SQL in SQL Server Code Name "Denali" & SQL Azure

Description:

Come and learn about what is new and cool in T-SQL in SQL Server code name "Denali" and SQL Azure. There are several interesting additions to T-SQL, this session will focus on what they are, why they were added to the product and how you can benefit from using them.

SessionID: 1752

HIPAA, ICD10, HL7, and... Data Warehousing?

Back to calendar

Event Date: 12-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: BI Architecture, Development and Administration Topics

Speaker(s):

Title: HIPAA, ICD10, HL7, and... Data Warehousing?

Description:

If you are in the healthcare industry, using these acronyms is second nature; however, adding a data warehouse to the mix may take you out of your comfort zone. Not to worry, this session will take that healthcare knowledge and turn it into a lean, mean, fact-finding machine. Learn how to create a payer data warehouse model, created from experience with numerous insurer organizations. If you are not in the healthcare industry, learn about data warehouse modeling best practices, and maybe you will even understand your insurance company better!

SessionID: 1962

What's New in SQL Server Code Name "Denali" Analysis Services

Back to calendar

Speaker(s): Simon Sabin

Title: Tips for handling large data volumes

Description:

Ever tried deleting 100 million records. If you have you will know your transaction log will likely blow up, you will block all access to the table and it will generally be painful. In this session we will look at some of the techniques you can use to make this easier. We will look at how •deletes and updates work and how indexes affect them

•how to break the job into smaller chunks •how to run those chunks in parallel

After this session you will understand more about why these operations are painful, what you can do to make them easier to do and reduc the impact on your end users.

SessionID: 1010

Who's Responsible? The Vendor or the DBA?

Back to calendar

Event Date: 12-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Mike Walsh, Erin Stellato

Title: Who's Responsible? The Vendor or the DBA?

Description:

Database administrators - you don't really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don't you? Well guess what, you're both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing DBAs) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face when working with each other. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start. Attend our session to see if a Vendor and DBA really can get along, and listen in on some real life horror story examples of how not to do it.

SessionID: 1177

Utility Databases

Back to calendar

Event Date: 12-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Chris Shaw

Speaker(s): Gregory Leake, Lynn Langit

Title: SQL Azure - Where We Are Today, and Microsoft's Cloud Data Strategy

Description:

SessionID: 1869

Inside Tempdb

Back to calendar

Event Date: 12-10-2011 13:30 - Category: 1/2 Day Sessions (3 hours) - Track: Enterprise Database Administration and Deployment

Speaker(s): Bob Ward

Title: Inside Tempdb

Description:

Perhaps one of the most frustrating, least understood, and contentious areas (no pun intended) of the SQL Server Engine is tempdb. In this half-day session, we will drive into the internals of the tempdb database. I will warn you up front. This is a 500 level session and will be a very deep internal discussion. It will be very fast-paced with much information to consume. As with past presentations I’ve done I will be using tools like the Windows Debugger, DMVs, DBCC commands, and possibly even hex editors. I will use as aid in presentation details of memory structures, classes, and bitmaps, Even with the depth of this presentation, I believe anyone will walk away with many practical pieces of knowledge and advice that can help you avoid problems and maximize your usage of tempdb.

This presentation will cover (but not limited to) the following topics:

• Differences between tempdb and other databases • Internals of tempdb allocation • Internals of temporary objects (temp tables, table variables, worktables, ….) • Caching of temporary objects • Internals of tempdb logging • Tempdb latch and lock contention • Pushing the limits of tempdb • Monitoring usage and behavior of tempdb • Troubleshooting the common and advanced tempdb problems

While this presentation include slides and information about tempdb it will also be mixed with a rich set of demonstrations to see the behavior (or misbehavior) of tempdb with SQL Server applications.

SessionID: 1546

The Ultimate Session on Indexing

Back to calendar

Event Date: 12-10-2011 13:30 - Category: 1/2 Day Sessions (3 hours) - Track: Application and Database Development

Speaker(s): Victor Isakov

Title: The Ultimate Session on Indexing

Description:

You can have the best hardware possible: SSDs, TBs of RAM and 100s of processors. (Don't we all wish we had such budgets.) But if you don't have the correct indexing strategy in place your database can still perform poorly. With the next version of SQL Server there are even more options available. Confused about what indexing strategy to use? Then this is the session for you!

In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover all of the indexing options that are available in SQL Server and when best to use them. Victor will cover "practical" internals that will help you understand how indexes work and why you need to maintain them. Finally he will cover what indexing strategies to use given the most important considerations: your users, their query patterns and your data. This should prove to be a most informative and practical session that will enable you to optimize your database performance.

SessionID: 2123

Lightning Talks - Wednesday

Back to calendar

Event Date: 12-10-2011 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Robert Davis, Bradley Ball, Andy Leonard, Dev Nambi, Mark S. Rasmussen, Audrey Hammonds, Rob Farley, Sharon Dooley

Title: Lightning Talks - Wednesday

Description:

Andy Leonard - Some thoughts on Community

Bradley Ball - 24 A 5 Minute Horror Story

Sharon Dooley - An Awesome Permissions Query

Robert Davis - Do as I say, Not as I Do

Mark Rasmussen - Revealing the Magic

Dev Nambi - Top 10 Ways to Break Your Deployments

Audry Hammonds - How to Make Your Data Model Suck Less

In this session, we are going to look at ways to help DBAs work smarter rather than harder when troubleshooting SQL Server performance problems! We will look at the Management Data Warehouse (MDW), which is a SQL Server database which holds data about the performance of SQL Server databases. Specifically, the MDW stores the standard performance counters which help performance monitoring and troubleshooting, thereby helping DBAs to commence a detailed analysis of the performance more quickly – leading to quicker performance troubleshooting and resolution. This session will cover:

The extraction of data from the MDW
The standard reports available
How to create customized reports using SSRS 2008 R2 using the MDW using best principles of data visualization (Stephen Few, Edward Tufte, to name a few).

Join this session to help you to proactively manage your performance monitoring using the MDW whilst using intelligent laziness to get quicker answers to your performance monitoring issues.

SessionID: 1511

Building a Professional Development Plan

Back to calendar

Event Date: 12-10-2011 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Andy Warren

Title: Building a Professional Development Plan

Description:

Ready to take the next step in your career? Ready to build a plan that will get you there? This session will show you a process for building a comprehensive professional development plan - a road map to get to where you want to go!

This session is designed to help you build a professional development plan using the same techniques that are used for building business plans. We'll talk about obtaining and managing resources, setting realistic goals, tracking progress, and what to do when you get off plan.

We're going to look at more than pure technical learning. We'll discuss how and when to modify your plan to include networking, writing, social engagement, and managing and leadership skills - and talk about the most effective ways to do it. We'll touch lightly on the value of a mentor and ways to find a good mentor.

We will also discuss changing how you look at your career, adopting the mindset of the consultant even if you prefer to retain your status as an employee. It's not an easy change, but it's a powerful one, and that is an important component of a professional development plan.

The session will cover the main scenarios for using MDS and will focus on the major improvements and new functionality in Denali release, both for IW through improved user experience (Web UI and Excel) as well as data stewards through improved staging, increased scalability and simplified security.

Objectives:

o Identify the scenarios and usage for MDS. o Introduce the main functionality of MDS in Denali o Identify the scenarios and usage where MDS Excel Add-In provides the best data management experience.

SessionID: 1441

Solid State Storage Deep Dive

Back to calendar

Event Date: 12-10-2011 16:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Wesley Brown

Title: Solid State Storage Deep Dive

Description:

If you have ever wanted to know how SSD's and Flash memory works this talk is for you. We will cover the fundamentals of Flash in detail. Starting with the basic structure of NAND Flash, we will then get into the different types available. We will then get into the details of how NAND Flash overcomes its short comings discussing wear leveling, garbage collection and TRIM. Finally, we will talk about reliability, different form factors. I will also highlight some of the specific vendor implementations and what makes a particular SSD "Enterprise ready" vs. "Consumer grade". We will also cover SQL Server usage patterns what is a good fit for SSD's and when it may be better to go with hard disks. Solid State Storage isn't a cure-all for every situation; this presentation will give you the tools you need to make the right choice for your SQL Server environment.

SessionID: 1568

Information: Are you blinded by the Light?

Back to calendar

Speaker(s): Neil Hambly

Speaker(s): To be Announced

Title: PASS Keynote - Quentin Clark

Description:

Quentin Clark

Corporate Vice President, SQL Server Database Systems Group Microsoft Corp.

Back by popular demand, the rubber hits the road in this Day 2 keynote led by Quentin Clark. Quentin will take the PASS audience on a demo-packed adventure across SQL Server solutions that span traditional boxed software, appliances and cloud. Quentin will address some of the tough issues facing IT and dev organizations today; mission critical SLAs that are simply expected, the explosion of data volumes, faster time to solution, and the evolution into the virtualized world. Both IT and dev attendees will see real-world customer solutions from the SQL Server business that help solve today’s growing challenges. Don’t miss this product-intensive showcase!

About Quentin Clark:

Quentin Clark is the corporate vice president of the Database Systems Group in the Microsoft SQL Server organization, reporting to Ted Kummert, senior vice president of the Business Platforms Division. In his current role Clark is responsible for the engineering and business leadership of the database systems of SQL Server - serving Microsoft's OLTP and Data Warehousing capabilities. This responsibility includes the core relational database engine and data access, SQL Server Manageability, Parallel Data Warehouse, and advanced development work in databases, including the Gray Systems Lab in Madison.

A 17-year Microsoft veteran, Clark held a variety of roles mostly in systems technology prior to joining SQL Server, including the Internet Information Server team, Application Center and System Center. In 2002, he joined SQL Server to lead work to bring unstructured data capabilities into the data platform, a vision realized over the recent SQL Server product releases. In 2006 he took the position of general manager overseeing the core relational database engine, which led to his current role.

Despite all the hype, it’s rare for a business to actually “move” an application directly to the cloud. The cost, risk and effort aren’t usually worth the benefit of what you gain. Security considerations, performance, and control are just a few of the reasons that many applications need to stay in your datacenter. But there are times when including a function from the cloud makes a ton of business sense, either to extend part of your internal applications to remote workers, customers or partners, or to act as a HA/DR solution.

In this session, Buck Woody (Microsoft Senior Technology Specialist on Distributed Computing) will talk about how you can embrace Cloud on Your Terms through SQL Server Code Name "Denali" and Windows and SQL Azure architectures, and the considerations for creating a hybrid architecture across on-premise databases and cloud technologies. You’ll learn: • How to create a decision matrix for which elements can be extended to the cloud • A Windows and SQL Azure technology overview, code name Juneau, and DAC Fx • Component options for hybrid solutions, including: • SharePoint, • Biztalk • .NET applications • Non-Microsoft languages and technologies • Other RDBMS’s

SessionID: 2024

Overview of Big Data on Windows and Windows Azure

Back to calendar

Event Date: 13-10-2011 10:15 - Category: Regular Session (75 minutes) - Track: Application and Database Development

Speaker(s): Saptak Sen

Title: Overview of Big Data on Windows and Windows Azure

Description:

N/A

SessionID: 2130

Women In Technology Luncheon - Make Yourself Heard: How to Ask for What You Want at Work

Back to calendar

Event Date: 13-10-2011 11:30 - Category: PASS Events (2 hours) - Track: General

Speaker(s): Allen Kinsel, To be Announced

Title: Women In Technology Luncheon - Make Yourself Heard: How to Ask for What You Want at Work

Description:

(WIT Luncheon)

It can be intimidating to ask for promotions, raises, or benefits. However, asking is often the first step to receiving. How should you ask? What should you ask? What information should you bring to the discussion? These topics and more will be answered by panelists who have successful track records at negotiating. Learn how to make your voice more powerful!

WIT Panelists:

Karen Lopez Yanni Robel Rick Bolesta Sharon Dooley

Gail Shaw - Common mistakes in query performance comparisons

Chris Webb - Calculating the 'Last Never NonEmpty' value in MDX

Amy Lewis - Fuzzy Lookup in 5!

Neil Hambly - Alerting with WMI in under 10 minutes

Grant Fritchey - Backup Testing, The Rant

Nic Cain - Powershell: It's your new BFF

John Sterrett - Thinking of hosting a SQL Saturday?

Niko Neugebauer - Build Up

SessionID: 1530

Everything Your Developer Won’t Tell You About SQL Azure

Back to calendar

Event Date: 13-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: SQL Azure

Speaker(s): Arie Jones

Title: Everything Your Developer Won’t Tell You About SQL Azure

Description:

Cloud computing is being hailed by some as the future silver bullet to everyone’s data availability woes and as such SQL Azure is Microsoft’s cloud based data platform. However, the platform is much different from simply a SQL Server that sits in the cloud and needs to be approached in an intelligent manner. In this fast paced session, we will be going well beyond the simple “hello world” scenario to show you how to leverage the cloud architecture for data storage as well as educate you in how the cloud works differently than your local database instance. We’ll give you all of the powers and perils that exist in the architecture to ensure that your first flight into the cloud is a successful one. This session is going to be an eye opener for sure and will have many of you dreaming of your data sitting in the cloud.

SessionID: 1339

Developers are from Mars, Report Servers are from Venus

Back to calendar

Event Date: 13-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: BI Client Reporting and Delivery Topics

Speaker(s): Doug Lane

Title: Developers are from Mars, Report Servers are from Venus

Description:

Do you remember what it was like to fall in love? Wasn't it wonderful?

Lately it just hasn't been the same. There's just no spark anymore. You've been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services won't tell you what's wrong. Maybe you're even thinking about seeing other reporting products.

SessionID: 1134

So How Does the BI Workload Impact the Database Engine?

Back to calendar

Event Date: 13-10-2011 13:30 - Category: 1/2 Day Sessions (3 hours) - Track: BI Architecture, Development and Administration Topics

Speaker(s): Denny Cherry, Stacia Varga

Title: So How Does the BI Workload Impact the Database Engine?

Description:

In this session, two SQL Server MVPs, one specializing in business intelligence and one specializing in core engine, will explain how normal day to day BI workloads impact the database engine, from ETL and cube processing to queries and report server management. During this session, we'll discuss what happens to the OLTP database during ETL as well as what happens to the data warehouse as data is being loaded. We'll talk about what you can do to speed up data warehouse loads and, most importantly, why these changes speed up the data warehouse loads. Then we'll review how cube processing affects the data warehouse database and describe how you can tune the data warehouse database for optimal cube processing. Also during this session, we'll compare performance differences between queries running against the OLTP application, the data warehouse, and the OLAP cube. We'll also assess the impact on the database engine when the reporting services databases are housed on servers which are hosting other databases.

SessionID: 1504

SSIS in the Enterprise

Back to calendar

Event Date: 13-10-2011 13:30 - Category: Regular Session (75 minutes) - Track: BI Architecture, Development and Administration Topics

Speaker(s): Andy Leonard

Title: SSIS in the Enterprise

Description:

Elegant solutions deliver function and form. SSIS - in Denali and previous versions - supports elegant design. In this presentation, SQL Server MVP and author Andy Leonard demonstrates key components of an SSIS Framework to facilitate SSIS development that performs and is manageable in the modern enterprise. You can have it all - fast ETL processes, execution lineage, real-time reporting, and historical auditing - and Andy will show you how!

to keep track of what is going on in your SQL Server and what might be causing performance

problems. But does that mean if you haven't set up any tracing, there is nothing you can do to

find out what problematic queries might be running? The answer is no.

In this session, we'll explore SQL Server's plan cache, from the way it is managed in memory, to

the tools and techniques for discovering what plans are in cache, how long they've been there, how

often they've been run, and whether they contain any suspected sub-optimal operators, such as

table scans and hash joins. Knowing what's happened is the first step in knowing what needs to be fixed.

SessionID: 1206

Joins, SARGability and the Evils of Residualiciousness

Back to calendar

Event Date: 13-10-2011 15:00 - Category: Spotlight Session (90 minutes) - Track: Application and Database Development

Speaker(s): Rob Farley

Title: Joins, SARGability and the Evils of Residualiciousness

Description:

You wouldn't believe how often people just aren't using their indexes effectively, whether it be searching for data, or joining tables. Quite often, this comes down to predicates becoming residual. Yes, residuality is a problem, and once a predicate has become residualicious, you may as well be scanning instead of seeking.

There’s so much more to SARGability than people think, and people can often miss out on significant performance benefits by not appreciating this – particularly with new and improved query hints becoming available in SQL 2008 R2 SP1 and Denali.

SARGable means Search ARGument Able and relates to the ability to search through an index for a value. Unfortunately many database professionals don’t really understand it – especially in regard to joins – leading to queries which don’t run as well as they should.

It's time to have fun... WITH SCIENCE!

Since 1869, the periodic table of elements has been the standard for organizing and presenting many metrics for the substances from which life is based on. I embrace the table as a prime example on how to present information - a great deal of it - in a concise and deeply informative fashion. Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances.

SessionID: 1949

SQLCAT: Optimize SQL Server for Private Cloud, Part 2: Best Practices and Lessons Learned

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Lindsey Allen, Xin Jin, Alan Cranfield

Title: SQLCAT: Optimize SQL Server for Private Cloud, Part 2: Best Practices and Lessons Learned

Description:

This is part2 of the optimization SQL Server for Private Cloud. We will talk about best practices and lessons learned around performance, dynamic memory, AlwaysOn and manageability of SQL Server in a Windows private cloud environment. We will touch on relevant features, running SQL Server on VMWare and the early lessons learned of database consolidation appliance.

SessionID: 1554

Visualizing Your Indexes - the Science behind the Art

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Regular Session (75 minutes) - Track: Application and Database Development

Speaker(s): Wendy Pastrick

Title: Visualizing Your Indexes - the Science behind the Art

Description:

Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.

SessionID: 1751

End-to-End SQL Server PowerPivot

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Spotlight Session (90 minutes) - Track: BI Client Reporting and Delivery Topics

Speaker(s): Peter Myers

Title: End-to-End SQL Server PowerPivot

Description:

One of the pillars of SQL Server 2008 R2 is Managed Self-Service BI. The SQL Server PowerPivot for Excel add-in is a key offering in this pillar, and delivers an entirely new analytic experience to Excel 2010. The add-in allows analysts to load and prepare large volumes of data from various sources to create a multidimensional model. The model can be enriched with sophisticated calculations. Then the model can then be used as the source for PivotTable and PivotChart reports. And yet that’s not the end of the story. With the SQL Server PowerPivot for SharePoint add-in, the Excel workbooks that host the PowerPivot model can be catalogued in SharePoint and exposed as a data source for other Excel and Reporting Services reports. These SharePoint hosted models can then be managed by IT with scheduled data refreshes from the originating data stores.

In this session, you will be introduced to the two add-ins. An end-to-end series of theory, demonstrations and discussion will describe how you can effectively leverage the add-ins with your own data and analysis requirements.

SessionID: 1853

A DBAs Guide to Administering BI Systems

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Robert Davis

Title: A DBAs Guide to Administering BI Systems

Description:

It seems like everyone wants to talk about how to administer OLTP SQL Servers, and all BI discussions are limited to development and architecture topics. As a result, BI Administration experts are hard to find or almost nonexistent.

Did you know that SSAS has DMVs? They do!! Did you know that you can run a SQL Trace on SSAS using an XMLA script? You can!! Did you know that you can backup, detach, restore, and attach SSAS databases and cubes? You can!!!

This session will be an introduction to administrative practices for BI systems. Topics covered include:

Diagnosing SSAS problems with dynamic management views
Investigating SSAS issues using SQL Trace
Maintaining SSAS cubes and databases
Best practices for configuring SSAS and SSIS for maximum performance
Providing High Availability for SSAS and SSIS

SessionID: 1351

Creating Business Intelligence Dashboards with PerformancePoint Services 2010

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Regular Session (75 minutes) - Track: BI Client Reporting and Delivery Topics

Speaker(s): Rod Colledge

Title: Creating Business Intelligence Dashboards with PerformancePoint Services 2010

Description:

In this demo-rich presentation, we'll walk through the creation of BI Dashboards using PerformancePoint Services and Analysis Services cubes. We’ll cover the process from end-to-end including creating a Business Intelligence site within SharePoint 2010, creating dashboards and dashboard components such as graphs, charts and KPI scorecards with Dashboard Designer, configuring data source security, creating drill-through actions and the power of decomposition trees. We’ll also cover various deployment scenarios including the security challenges of a per-user identity extranet deployment.

SessionID: 1531

More DBA Mythbusters

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Paul Randal

Title: More DBA Mythbusters

Description:

It's amazing how many myths and misconceptions have sprung up and persisted over the years about SQL Server - after 12 years helping people out on forums, newsgroups, and customer engagements, Paul's heard it all. Building on the success of the original DBA Mythbusters session from last year, Paul brings another 90 minutes of myth debunking of a whole new set of myths and misconceptions in this fast-paced session on how SQL Server operates and should be managed and maintained. Come and see how many YOU get right!

SessionID: 1551

Discovering the Plan Cache

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Jason Strate

Title: Discovering the Plan Cache

Description:

SessionID: 1642

SQL Server Execution Plans – From Compilation To Caching To Reuse

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Spotlight Session (90 minutes) - Track: Application and Database Development

Speaker(s): Maciej Pilecki

Title: SQL Server Execution Plans – From Compilation To Caching To Reuse

Description:

Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it's also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we will discuss in details the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse and aging. You will leave this session with full understanding of how to improve your server's performance by increasing execution plan reuse (and how to avoid reuse in case this is necessary).

SessionID: 1113

SQL Azure Sharding with the Open Source Enzo Library

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Regular Session (75 minutes) - Track: SQL Azure

Speaker(s): Herve Roggero

Title: SQL Azure Sharding with the Open Source Enzo Library

Description:

SessionID: 1640

One Hard Problem: Multivalued Dimension Relationships

Back to calendar

Event Date: 13-10-2011 17:00 - Category: Spotlight Session (90 minutes) - Track: BI Architecture, Development and Administration Topics

Speaker(s): Joy Mundy

Title: One Hard Problem: Multivalued Dimension Relationships

Description:

Many attendees know the basics of dimensional modeling: facts, dimensions, and dimension attribute change management. But we never seem to find time to talk about the hard problems. This session addresses a thorny dimensional design challenge in a holistic manner: How do we handle multivalued dimension relationships, where a fact row corresponds to potentially many rows in the dimension table?

The solution – as with most solutions in the DW/BI space – begins with the data model. But there are issues to be concerned about during ETL, SSAS, usability, and query performance as well. In this session we describe how to identify various types of multivalued dimension relationship problems; you'll learn about the standard design solutions, and the pluses and minuses of each approach. We'll show you some tricks (none perfect) for avoiding multivalued dimensions. You'll learn how to build the ETL to populate said dimensions, as well as the Analysis Services cube and associated calculations. Finally, learn what you'll to teach your users about the ad hoc use of the multivalued dimension.

SessionID: 2141

Community Appreciation Party – sponsored by Microsoft and PASS

Back to calendar

Event Date: 13-10-2011 19:00 - Category: PASS Events (3 hours) - Track: General

Speaker(s): To be Announced

Title: Community Appreciation Party – sponsored by Microsoft and PASS

Description:

PASS and Microsoft are sponsoring the PASS Summit evening party at Gameworks Thursday evening. Make sure to join 3,000 of your SQL Server BFFs for great food and an open bar at this fun community event, open to all PASS Summit attendees.

SessionID: 2139

SQL Server MVP Deep Dives Book Signing - Friday

Back to calendar

Event Date: 14-10-2011 07:15 - Category: PASS Events (45 minutes) - Track: General

Speaker(s): To be Announced

Title: SQL Server MVP Deep Dives Book Signing - Friday

Description:

Be sure to purchase your copy of the new SQL Server MVP Deep Dives, Volume 2 (Manning 2011) during the PASS Summit Welcome Reception Tuesday evening, and then get it signed by many of the authors at two book-signing sessions during the week:

Wednesday, October 12: 1:00pm-1:30pm between the Expo Hall and the Dining Hall Friday, October 14: 7:15am-8:00am in Room 211

SessionID: 2133

PASS Keynote - David J. DeWitt

Back to calendar

Event Date: 14-10-2011 08:15 - Category: PASS Keynotes (105 minutes) - Track: General

Speaker(s): To be Announced

Title: PASS Keynote - David J. DeWitt

Description:

David J. DeWitt

Technical Fellow, Data and Storage Platform Division Microsoft Corp.

Big Data – What is the Big Deal?

Are you ready for the exploding world of big data? Do you know the difference between Hive and Pig? Do you know why MapReduce is being taught in many universities rather than SQL? If not, pay attention because this talk will help get you started in understanding this new world. While sometimes the Hadoop toolkit (which includes HDFS, MapReduce, Hive, Pig, and Sqoop) is used as an alternative to relational database systems such as SQL Server, more frequently customers are using it as a complementary tool. Sometimes it may be used as an ETL tool or to perform an initial analysis of a freshly acquired data set to determine whether or not it is worth loading into the data warehouse, and sometimes to process massive data sets that are too big to even contemplate loading into all but the very largest data warehouses. In addition to covering the basics of the various parts of the Hadoop stack, this talk will discuss the strengths and weakness of the Hadoop approach compared to that provided by relational database systems and explores how the two technologies can be used productively in conjunction with one another.

About David DeWitt:

David J. DeWitt is a Technical Fellow in the Microsoft Data and Storage Platform Division. DeWitt’s role is creating and leading the Microsoft Jim Gray Systems Lab, a new advanced development center in Madison, WI, for Microsoft, in association with the University of Wisconsin-Madison Computer Sciences Department. DeWitt came to Microsoft from the Computer Sciences Department at the University of Wisconsin, which he joined in September 1976 after receiving his Ph.D. from the University of Michigan. He served as department chair from July 1999 to July 2004 and held the title of John P. Morgridge Professor of Computer Sciences when he retired from the University of Wisconsin.

This Event has Live Streaming: http://www.sqlpass.org/summit/2011/Live/LiveStreaming.aspx

SessionID: 1666

PowerPivot - A cool reporting tool!

Back to calendar

Event Date: 14-10-2011 10:15 - Category: Regular Session (75 minutes) - Track: BI Client Reporting and Delivery Topics

Speaker(s): Scott Schommer

Title: PowerPivot - A cool reporting tool!

Description:

The future of BI is self-service reporting and PowerPivot is the conduit to that goal. We will explore how to use the PowerPivot add-in for Excel 2010 to tie different data sources together and deliver analytics.

In this session you will learn how to use PowerPivot (within the familiar interface of Excel) to combine different data sources such as Analysis Services cubes, TSQL queries, Stored Procedures, Excel spreadsheets, flat files, Microsoft Access databases and data from the web to create basic PivotTables and PivotCharts in Excel. The data these new spreadsheets overcomes the 1,048,576 row limitation in Excel 2007/2010, contains refreshable data sources and has excellent data compression and lighting fast speed thanks to the utilization of the VertiPaq engine.

Together we will walk thorough how to use PowerPivot to import data from different sources into an Excel spreadsheet, create pivot tables, pivot charts, "slicers" and drill down in to relationships between the data sources.

Please come learn how you and end users at your organization can use PowerPivot to do data exploration and create first class self services business intelligence!

SessionID: 1386

How to migrate your databases to SQL Azure (and what's new)

Back to calendar

Event Date: 14-10-2011 10:15 - Category: Regular Session (75 minutes) - Track: SQL Azure

Speaker(s): Nabeel Derhem

Speaker(s): Jen Stirrup

Title: Data Visualization: Chaos, or Patterns you haven't recognized yet?

Description:

Data Visualisation is an essential tool for Business Intelligence specialists. It reveals patterns in the data, which businesses can use as intelligence to perform better. Edward de Bono once commented that “Creativity involves breaking out of established patterns in order to look at things in a different way” – but business users need to see the patterns in order to be creative problem solvers!

I will discuss the perceptual and cognitive processes involved in finding patterns in the data. I will use SQL Server Reporting Services 2008 R2 to demonstrate some of the less well-known data visualisations, such heatmaps, bullet charts, and other visualisations based on Tufte's "small multiples" such as Sparklines and Sploms.

SessionID: 1633

Troubleshooting SQL Server with SysInternals Tools

Back to calendar

Event Date: 14-10-2011 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Argenis Fernandez

Title: Troubleshooting SQL Server with SysInternals Tools

Description:

Learn how some of the tools from the SysInternals suite can help you troubleshoot issues on SQL Server. See Process Monitor, Process Explorer and other extremely useful (and free) tools in action on real-life scenarios. Dive into diagnostic tools that can let you dig deep into OS internals. Take your DBA skills to the next level with this demo-packed session.

SessionID: 1840

Using Correlated Tracing to Diagnose Query Level Performance

Back to calendar

Event Date: 14-10-2011 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Jerome Halmans, Rong Wu

Speaker(s): Brent Ozar, n/a n/a, Christian Bolton, Pete Harris

Title: Understanding Microsoft Certification in SQL Server with Chris Testa-O'Neill, Brent Ozar and Christian Bolton

Description:

This session will provide a thorough overview of the certification and training offered by Microsoft in the area of SQL Server 2008 technologies. It is not a technical session but will provide the information that you require from those who have experienced the range of Microsoft certifications available in order to inform and help you with your forthcoming exams in

•Microsoft Certified Technical Specialist •Microsoft Certified IT Professional •Microsoft Certified Master •Microsoft Certified Architect

An exploration of the available learning channels to support you meeting your cetification requirements will also be explored including

•Microsoft Official Courses – (Instructor Led Training) •Microsoft Elearning •Microsoft Press Books

SessionID: 1171

Inside the SQL Server Transaction Log

Back to calendar

Event Date: 14-10-2011 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Brad McGehee

Speaker(s): To be Announced

Title: Lunch - Birds of a Feather - Sponsored by Dell

Description:

Birds-of-a-Feather (BOF) Lunch - Sponsored by DELL

Unite with MVPs, SQLCAT architects, and your peers at this informal and interactive lunch. Share your knowledge, stimulate new ideas, and gain insights. There will be at least 50 different topics and tables for the best lunch 'n learn going!

SessionID: 2126

PASS Board Meet And Greet / Q&A

Back to calendar

Speaker(s): Glenn Berry

Title: Scaling SQL Server

Description:

cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.

SessionID: 1837

Migrating Large Scale Application to the Cloud with SQL Azure Federations

Back to calendar

Event Date: 14-10-2011 13:00 - Category: Regular Session (75 minutes) - Track: SQL Azure

Speaker(s): Cihan Biyikoglu

Speaker(s): Peter Myers

Title: Delivering KPIs with Analysis Services

Description:

Key Performance Indicators (KPIs) are important measurements that influence behavior and allow an organization to evaluate whether they are meeting their target for specific objectives. This session will commence by introducing how KPIs are defined in Analysis Services, in both the Unified Dimensional Model (UDM) and the upcoming release of PowerPivot, and then made available for consistent reporting using Excel, Excel Services, Reporting Services and PerformancePoint Services.

Next, consideration will be given to where the KPI sources its target data from. The session will explore additional capabilities of the UDM to collect planning data, specifically by using cube write-back, and Data Mining to seed planning values.

Since the beginning in 1937, the Progressive Group of Insurance Companies has been an innovator and we are now one of the largest U.S. private passenger auto insurance groups, with annual premiums over $14 billion.

We have successfully migrated a mission critical Tier-1 Auto Policy Management system from mainframe to the SQL Server platform. The application requirements included: optimum performance, high HA DR expectations, and interface with more than 100 external systems; this application being the hub for auto business.

In this session we cover the motivation for migration, technologies evaluation, anticipated and actual challenges encountered during migration to SQL Server, critical success factors, and lessons learned. Aside from interfacing with more than 100 external applications (both Windows and mainframe-based) it is designed to serve customers across the US where each state has its unique insurance regulations. Please attend this session to better understand the real world challenges encountered when we deployed this Tier-1 application and the strategies we used to minimize risks.

SessionID: 1975

Upgrading to SQL Server 2008R2 and SQL Server Code Name "Denali"

Back to calendar

Event Date: 14-10-2011 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Dandy Weyn

Title: Upgrading to SQL Server 2008R2 and SQL Server Code Name "Denali"

Description:

Your database environment is still running on SQL Server 2000 or SQL Server 2005 and you are considering upgrading?

This session will show you all the caveats, tricks and tips and guidance on how to perform successful database upgrades to SQL Server 2008 R2, and SQL Server code name “Denali”. By the end of this session you’ll understand the key steps involved in the upgrade process. You will learn how to assess upgrade issues, and find resolutions to accomplish a successful upgrade.

SessionID: 1926

What’s New in Security for SQL Server Code Name "Denali"

Back to calendar

Event Date: 14-10-2011 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Il-Sung Lee

Title: What’s New in Security for SQL Server Code Name "Denali"

Description:

Security continues to be a top concern for database administrators as they face the ever-present threat of data breaches and the increasing pressures from compliance regulations such as PCI and HIPAA. Fortunately, SQL Server 2008 delivered some key features, such as TDE and SQL Server Audit, to help administrators achieve their security goals and Denali makes further progress with enhancements to Audit and security manageability. This session takes an experienced users approach to the advanced topic of recent security enhancements to SQL Server and explains the new changes coming to Denali and how they can help you satisfy your security objectives.

SessionID: 2125

Lightning Talks - Friday

Back to calendar

Event Date: 14-10-2011 14:30 - Category: Regular Session (75 minutes) - Track: Professional Development

Speaker(s): Allen White, Mark Broadbent, David Stein, Doug Lane, Chris Shaw, Craig Purnell, Argenis Fernandez

Title: Lightning Talks - Friday

Description:

Craig Purnell - Making Active Directory and SQL Server Hold Hands

David Stein - DBA Lessons Learned from The Godfather

Doug Lane - The Two Most Powerful Properties for Dashboards

Chris Shaw - 10 Things I Wish I Knew Then

Argenis Fernandez - Quick Tips to Enhance TempDB Performance

Mark Broadbent - SQL Server Clustering for Dummies

SessionID: 1871

SQLCAT: Building Highly Scalable Cloud Analytics Solutions with SQL Azure and StreamInsight (Project Austin)

Back to calendar

Event Date: 14-10-2011 14:30 - Category: Regular Session (75 minutes) - Track: Application and Database Development

Speaker(s): Mark Simms

Title: SQLCAT: Building Highly Scalable Cloud Analytics Solutions with SQL Azure and StreamInsight (Project Austin)

Description:

A new class of workload is rapidly emerging on the cloud - massively scalable analytics engines providing real-time insight into data streams produced by hundreds of thousands of connected devices and applications:

· Media. Delivering streaming video to hundreds of thousands of concurrent users is challenging. Understanding the quality of the end user experience, their activity and behavior is critical in delivering a compelling, targeted service.

· Mobile. Beyond the challenges of delivering a mobile experience to a broad user base, how do you instrument, acquire and analyze information about user activity and behavior?

· Automotive. How do we tie the flood of vehicle telemetry into our cloud and provide actionable, targeted and personalized analytics? How can both vehicle manufacturers and owners derive value from having deeper insight into vehicle behavior, performance and maintenance?

· Utilities. Advances in infrastructure such as Smart Grids are driving an explosion in widely dispersed telemetry. How can our ISVs develop next generation systems to provide real-time analytics into millions of electrical meters and sensors?

This session will cover architectural patterns and lessons learned through developing real-world solutions on Azure for the web telemetry and utilities verticals.

You are designing a BI Solution and your customer ask you to keep a snapshot of the status of all their documents (orders, insurances, contracts, bills...whatever the word "document" may mean) for all the days of the year. They have millions of documents and they want to have in their Data Warehouse all the data they have gathered right from the very first operating day.

If you have 1 million of documents (on average) and you have to keep a snapshot of them for each one of the 365 days in a year, and you have 10 year of history, you're going to have a 3 billions table just to start with. That's a very big and challenging number, and you may have not the option to buy a Parallel Data Warehouse. In this session, we'll see how we can turn the usual snapshot tables into temporal table so that we can store time intervals in order to avoid data duplication, while keeping the Data Warehouse design usable by Analysis Services (that doesn't know what an interval is) and optimizing it to have very good performance even on standard hardware. The explained technique is a result of several month of research and has been applied to the Data Warehouse of an insurance company where we had to deal with two times the number said before.

SessionID: 1299

3rd Normal Form: That's crazy talk!!!

Back to calendar

Event Date: 14-10-2011 14:30 - Category: Regular Session (75 minutes) - Track: Application and Database Development

Speaker(s): Thomas LeBlanc

Speaker(s): Brian Mitchell, Dandy Weyn

Speaker(s): Kendal Van Dyke

Title: Working With XML In SQL Server

Description:

SessionID: 1886

SQLCAT: What are the Largest Azure Projects in the World and how do they Scale

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: SQL Azure

Speaker(s): Kevin Cox, Michael Thomassy

Title: SQLCAT: What are the Largest Azure Projects in the World and how do they Scale

Description:

Presenting the architecture behind the largest Azure (both Windows and SQL Azure) projects in the world.

SessionID: 1125

SQL Server Memory Management

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Thomas LaRock

Title: SQL Server Memory Management

Description:

Are you suffering from memory issues? Is your SQL Server configured for proper memory management? Attend this session and learn how to best determine if you are suffering from memory pressure, how to resolve issues that result from memory pressure, and how to properly configure your SQL Server to minimize the chance of having memory issues.

SessionID: 990

Where should I be Encrypting my Data

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: Application and Database Development

Speaker(s): Denny Cherry

Title: Where should I be Encrypting my Data

Description:

In this session we'll be looking at all the various places within the application stack that data can be encrypted or hashed, so that as an application/database administrator/developer/architect you can make the best decision as to where in the application stack to do this work. These layers include the application layer, the middle tier, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.

SessionID: 1762

Upgrading SSIS to Denali –Management Considerations and Best Practices

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Spotlight Session (90 minutes) - Track: BI Architecture, Development and Administration Topics

Speaker(s): Rushabh Mehta

Title: Upgrading SSIS to Denali –Management Considerations and Best Practices

Description:

SQL Server Denali introduces a number of exciting new features that will change the way we deploy and manage SSIS packages. In this session, we will explore these new features, understand how to take advantage of them and formulate some best practices. Finally, we will explore an existing SSIS package that embodies current management best practices and framework and see how to upgrade it to SSIS in Denali to take advantage of the new features.

SessionID: 1452

Policy-Based Management in a Nutshell

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Jorge Segarra

Title: Policy-Based Management in a Nutshell

Description:

Does your organization have data policies that can't or aren't being enforced consistently? Well guess what? You can do all that and more with Policy-Based Management, a powerful and easy to configure feature added in SQL Server 2008! With a few simple clicks, you can check a setting on every server or database in your enterprise. Set up a policy that automatically enforces object-naming conventions. Create a policy to ensure your databases have been backed up within a specified period of time. In this demo-packed session you'll learn how to set these up in your own shops, setup an elegant (and free) reporting solution, and much, much more!

SessionID: 2134

Creating a Successful Data Architecture with MS SQL Server and CA ERwin Data Modeler

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Marilice Vidal da Silva

Title: Creating a Successful Data Architecture with MS SQL Server and CA ERwin Data Modeler

Description:

This session will discuss the Enterprise Data Management process at Bovespa, a lead Brazilian institution for intermediation of capital market operations. Using a model-driven architecture, Bovespa was able to achieve a centralized view of their SQL Server data architecture, resulting in increased efficiency and improved data quality. Details of both the technical architecture and the workflow and process will be discussed, with best practices (and things to avoid) in creating a successful data architecture.

SessionID: 1439

Building a Reporting Services Framework

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: BI Architecture, Development and Administration Topics

Speaker(s): David Darden

Title: Building a Reporting Services Framework

Description:

Alright… So you've got your data warehouse in tip top condition. Now it's time to deliver a few hundred reports to your customers. Oh, and not just build them… you also need to maintain and improve them over the course of their lifetime. This session will walk you through building robust report templates, managing and maintaining report metadata, and creating a full featured deployment system to make deployments a breeze.

SessionID: 1096

Best Practices for Deploying SQL Server on VMware - "What every DBA needs to know to be successful for virtual deployments"

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration and Deployment

Speaker(s): Wanda He

Title: Best Practices for Deploying SQL Server on VMware - "What every DBA needs to know to be successful for virtual deployments"

Description:

Many virtualization customers have begun looking at virtualizing their tier-1 applications, such as their ERP systems, SAP and SharePoint environments. At the heart of many of these business critical systems is Microsoft SQL. As virtualization has evolved applications once considered too heavy to move out of the physical world are now being reevaluated for virtualization. Microsoft SQL can now take advantage of many of the features that vSphere provides out of the box such as support for 64-bit technologies, NUMA support and hot-add CPU and memory. This session will cover design considerations for virtualizing SQL workloads, performance and scalability information, high-availability options, support considerations, as well as what’s new in ESX 5.

SessionID: 1450

T-SQL Awesomeness - 3 Ways to Write Cool SQL

Back to calendar

Event Date: 14-10-2011 16:15 - Category: Spotlight Session (90 minutes) - Track: Application and Database Development

Speaker(s): Audrey Hammonds

Title: T-SQL Awesomeness - 3 Ways to Write Cool SQL

Description:

There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, all while improving performance and/or readability. Come learn three new-school ways to expand your T-SQL repertoire with:

• Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY We will look at data models and development scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare alternate, new-school ways to get the same result set. Evaluating different approaches based on performance, readability, and maintainability, we’ll ask the important questions: Is it faster? Is it prettier? Can I hand it off to the new guy to maintain?
The goal of this session is simple: Be able to impress your friends and confound your frenemies with your mad T-SQL skills.