General Sessions

 
The PASS SQLRally Dallas lineup features 60 real-world technical sessions - 20 chosen by community vote - from some of the best-known SQL Server and Business Intelligence experts in the industry.

Find your favorite sessions and speakers:

Haven't signed up yet? Don't miss it - register for PASS SQLRally Dallas now!

Session Code Key

Each session code identifies the session track, experience level, and the type of session.  If the session code doesn't have a third element, the presentation is a standard community session.  For example, if a session is identified as
DBA-201-P:

The "DBA" part refers to the track
The "201" refers to the session number within the experience level (200)
And the "P" refers to the session category, in this case a Pre-conference session

(P=Pre-conference; no third element = Standard session)

Experience Level Definitions

100 - Novice
200 - Intermediate
300 - Advanced
400 - Expert

Search sessions by track:
Business Intelligence (BI)
Database Administration (DBA)
Development (DEV)
Professional Development (PD)
SQL Server 2012 and Beyond (SS12)


Business Intelligence (BI)

Building a Write-Back Application with Analysis Services (BI-201)
Bryan Smith (Microsoft)

Business Intelligence in Azure: SSIS & SSRS Focus (BI-100)
Jen Stirrup (Copper Blue Business Intelligence)

Dashboards: How to Choose Which MSBI Tool (Community Pick) (BI-202)
Melissa Coates (Intellinet)

Data Mining (It's not the size of your data - it's what you do with it) (BI-300)
Adam Jorgensen (Pragmatic Works)
Devin Knight (Pragmatic Works)

Data Warehouse Mistakes You Can’t Afford to Make (BI-203)
David Stein (WaveTwo )

DirectQuery vs VertiPaq (Cached) Mode in Tabular Model (Community Pick) (BI-301)
Julie Koesmarno (Independent Consultant)

Fitting Hadoop into Your Enterprise BI Strategy (BI-204)
Cindy Gross (Microsoft)

Got a Data Mess the Size of Texas? Data Cleansing Using the "Scrubbing Bubbles" of SSIS (BI-205)
Amy Lewis (Statera)

Introduction to Data Quality Services (Community Pick) (BI-101)
Tim Mitchell (Artis Consulting)

Making Heads or Tails of Analysis Services Storage (BI-302)
Greg Galloway (Artis Consulting)

Managed Self-Service BI & Data as a Service (Community Pick) (BI-200)
Melissa Coates (Intellinet)

Overcoming Barriers and Avoiding Mistakes with BI (BI-303)
William E Pearson III (Island Technologies Inc.)

SSIS Performance Tuning (Community Pick) (BI-304)
John Welch (Pragmatic Works)

The Report Part Library: Increasing Development Productivity in Reporting Services (BI-206)
Jessica Moss (CapTech Consulting)

Tuning Analysis Services Performance (BI-305)
John Welch (Pragmatic Works)

Zero to Cube - Fast Track to Analytics (Community Pick) (BI-306)
Adam Jorgensen (Pragmatic Works)
Dustin Ryan (Pragmatic Works)

Database Administration (DBA)

Compression - Define your Strategy (DBA-300)
Neil Hambly (MDSL)

Data Governance 101 - Environment, Space and Security (Community Pick) (DBA-301)
Sri Sridharan (NTSSUG)

Deadlock Detection, Troubleshooting & Prevention (DBA-201)
Trevor Barkhouse (Microsoft Corporation)

Eating the Elephant: SQL Server Table Partitioning (Community Pick) (DBA-302)
Michael Fal (Global Healthcare Exchange)

Fixing Bad Parameter Sniffing for Better Query Performance (DBA-202)
Grant Fritchey (Red Gate Software)

Fundamentals of SAN, NAS and IP Storage (DBA-203)
Wesley Brown (Dell)

Gather SQL Server Performance Data with PowerShell (DBA-306)
Allen White (UpSearch Technology Services)

How to Monitor Your SQL Server for Performance & High Availability (DBA-100)
Brad McGehee (Red Gate Software)

Manage Your Shop with CMS & Policy Based Management (DBA-206)
Ryan Adams (Verizon)

Mirroring Start to Finish (Community Pick) (DBA-204)
Ryan Adams (Verizon)

PowerShell: Are You Checking Out My Profile? (DBA-101)
Nicholas Cain (Coinstar)

SQL Internals, Recovery Models, and Backups! OH MY! (Community Pick) (DBA-205)
Bradley Ball (Pragmatic Works)

STOP! Consolidate and Listen! (DBA-102)
Jorge Segarra (Pragmatic Works)

TempDB: Performance and Manageability (DBA-303)
Robert Davis (Idera)

The Backup Tune-up (Community Pick) (DBA-304)
Sean McCown (Baylor Healthcare)

The Periodic Table of Dynamic Management Objects (DBA-305)
Tim Ford (Spectrum Health)

Understanding Backups (Community Pick) (DBA-103)
Sean McCown (Baylor Healthcare)

Development (DEV)

Advanced DDL Constraints (Community Pick) (DEV-300)
Joe Celko (self)

Database Design Contentious Issues (DEV-200)
Karen Lopez (InfoAdvisors)

Death by UDF (DEV-301)
Kevin Boles (Indicium Resources, Inc.)

Edge Case Testing for the Database Professional (Community Pick) (DEV-100)
Vicky Harp (Idera)

Everything You Always Wanted to Know About Indexes but were Afraid to Ask (DEV-201)
Dmitri Korotkevitch (Actsoft)

SQL Server Internals and Architecture (DEV-102)
Kevin Kline (Quest Software)

T-SQL Deployment and Continuous Integration Best Practices (Community Pick) (DEV-202)
Grant Fritchey (Red Gate Software)

Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos (DEV-203)
Jennifer McCown (TCUL)

What Sequence Objects Are (and Are Not) (DEV-302)
Louis Davidson (drsql.org)

Professional Development (PD)

"Turbo Charge" Your DBA Career (Community Pick) (PD-100)
Sri Sridharan (NTSSUG)

Building Your Professional Development Plan (PD-101)
Andy Warren (Fourdeuce Inc)

So, You Want to Start a Career in BI (Community Pick) (PD-200)
Erin Welker (Slalom Consulting)

Social Marketing 2012 for Microsoft Professionals (PD-102)
Mark Tabladillo (MarkTab Consulting)

SQL Server 2012 and Beyond (SS12)

Adapting Your ETL Solutions to Use SSIS 2012 (SS12-200)
Devin Knight (Pragmatic Works)

Developing and Managing a BI Semantic Tabular Model in SQL Server 2012 Analysis Services (SS12-201)
Patrick LeBlanc (Microsoft)

Digging into Reporting Services 2012 with SharePoint 2010 (SS12-400)
Adam Saxton (Microsoft CSS)

Enter the Dragon: SQL 2012 on Server Core (SS12-401)
Mark Broadbent (SQLCloud)

Manage SQL Server 2012 on Windows Server Core with PowerShell (SS12-300)
Allen White (UpSearch Technology Services)

SQL Server 2012 T-SQL (SS12-301)
Kathi Kellenberger (Pragmatic Works)

SQL Server 2012: Memory Manager Rebooted (SS12-402)
Suresh Kandoth (Microsoft Corporation)

SSIS 2012 - Instrumentation and Logging (SS12-202)
Andy Leonard (Linchpin People, LLC)

Transparent Data Encryption Inside and Out in SQL 2012 (Community Pick) (SS12-302)
Bradley Ball (Pragmatic Works)

Troubleshooting Performance on SQL Server 2012 with Extended Events (SS12-403)
Rohit Nayak (Microsoft)

Upgrade Roadmap: Let’s Delve into SQL Server 2012 (SS12-203)
Craig Purnell (Baker Hostetler LLP)

Using Columnstore Indexes in SQL Server 2012 (Community Pick) (SS12-204)
Carlos Bossy (Quanta Intelligence)

Using SQL Server 2012's Always On (SS12-303)
Denny Cherry (mrdenny.com)

What's New for SQL Server 2012 Supportability (SS12-404)
Bob Ward (Microsoft CSS)

Join us on Twitter

SQLSoldier (Robert L Davis) - @bretlowery Actualy it was sunny every day last week. Oh wait, I was in Dallas for #SQLRally. Never mind.
5/20/2012 7:18:50 PM
JamieR_Venturi (Jamie Rogers) - RT @SQLCindy: My #SQLRally slides for "Fitting Microsoft Hadoop Into Your Enterprise BI Strategy" - http://t.co/7HG2UhZG #BigData
5/19/2012 2:49:54 AM
vickyharp (Vicky Harp) - RT @SQLAJ: [Blog post] A Few Laps Around The SQLRally Track http://t.co/cLL5ZVO5 #CACTUSS #sqlpass #sqlrally
5/18/2012 11:17:00 AM
SQLAJ (AJ Mendo) - [Blog post] A Few Laps Around The SQLRally Track http://t.co/cLL5ZVO5 #CACTUSS #sqlpass #sqlrally
5/18/2012 10:12:01 AM