Schedule

Here is our schedule for the upcoming event. We've done our best to provide a good mix of topics and skill levels, we hope you'll find something of interest throughout the day. Our thanks to the speakers listed below for volunteering their time, we couldn't do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.

Note: Some speakers alternately upload their sessions to their own blog sites, which you can locate their site when you click on their session below.

Start TimeBreakout - Room: 2520D (Seminar Room)Track 1 - Room: 2520D (Seminar Room)Track 2 - Room: 2520C (Conference Room)Track 3 - Room: 2520B (Conference Room)Track 4 - Room: 2523 (Training Room)
08:00 AMI-380 PASS

Registration/Welcome

Level: Beginner
    
08:30 AM Jason Strate

Discovering the Plan Cache

Level: Intermediate

download
Michael Steineke

What's new with SQL Server 'Denali' for HA/DR

Level: Intermediate

download
Ross McNeely

Using Spatial Data Types

Level: Beginner

download
William E. Pearson III

Getting Started with MDX

Level: Beginner
10:00 AM Bill Preachuk

Database Restores - Lessons from the Real World

Level: Beginner

download
Ted Krueger

Query Tuning for Developers and DBAs

Level: Beginner

download
Tim Plas

High-Availability and DR Options for SQL Server

Level: Intermediate

download
Ross McNeely

Minimal Processing for Large Cubes

Level: Advanced

download
11:30 AMI-380 PASS

"Birds of a Feather" Luncheon

Level: Beginner
    
12:30 PM William Pearson

An Overview of PowerPivot

Level: Beginner
Jason Strate

Getting To Know Your Indexes

Level: Intermediate

download
Aaron Lowe

Database Development using Visual Studio

Level: Intermediate
Brian Duhn

Check Out The New AAS!

Level: Beginner

download
02:00 PM Ted Krueger

SSIS: The DBA Multiplier

Level: Beginner

download
Ross McNeely

Dynamic Text File Creation Via Single SSIS Package

Level: Intermediate

download
Michael Steineke

SQL 'Denali' AlwaysOn Configuration Deep Dive

Level: Advanced
Aaron Lowe

Writing Professional Database Code

Level: Intermediate
03:30 PM Norman Kelm

The Script Task, powerhouse of SSIS

Level: Beginner
Jason Strate

XQuery Basics for the DBA

Level: Intermediate

download
William E. Pearson III

Serene Velocity: Reporting Services and SSAS Data

Level: Intermediate
Steven Murawski

Scriptable UI with PowerShell

Level: Intermediate
04:45 PMI-380 PASS

Closing Remarks/Prize Giveaway

Level: Beginner
    


Submitted Sessions

Here is the list of sessions submitted so far. Our goal is to feature as many different speakers and topics as possible, but space limitations prevent us from accepting every session. This list is also a great way for those thinking about speaking to see what might be on the agenda and enter a session that doesn't collide with an existing one.

TitleSpeakerLevel
"Birds of a Feather" LuncheonI-380 PASSBeginner
An Overview of PowerPivotWilliam PearsonBeginner
An Overview of PowerPivot in SharePointWilliam E. Pearson IIIIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Becoming DAX: An Introduction ...William E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Check Out The New AAS!Brian DuhnBeginner
Closing Remarks/Prize GiveawayI-380 PASSBeginner
Database Development using Visual StudioAaron LoweIntermediate
Database Restores - Lessons from the Real WorldBill PreachukBeginner
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Discovering the Plan CacheJason StrateIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Dynamic Text File Creation Via Single SSIS PackageRoss McNeelyIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Getting Started with MDXWilliam E. Pearson IIIBeginner
Getting to Know Index Operation Stats Jason StrateIntermediate
Getting To Know Your IndexesJason StrateIntermediate
High-Availability and DR Options for SQL ServerTim PlasIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Mastering Advanced Functions in PowerShellSteven MurawskiIntermediate
Merge Replication for Offline Data MobilityTed KruegerBeginner
Minimal Processing for Large CubesRoss McNeelyAdvanced
OWN your SQL Servers with PBM & CMSMitchell BottelBeginner
PowerPivot for ExcelWilliam E. Pearson IIIBeginner
PowerShell, the New SQL HammerNorman KelmBeginner
Practical PowerShell For DBAsSteven MurawskiBeginner
Query Tuning for Developers and DBAsTed KruegerBeginner
Registration/WelcomeI-380 PASSBeginner
Scriptable UI with PowerShellSteven MurawskiIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
SQL 'Denali' AlwaysOn Configuration Deep Dive Michael SteinekeAdvanced
SSIS: The DBA MultiplierTed KruegerBeginner
The Creepy DBA, How to Stalk Your UsersJason StrateIntermediate
The Script Task, powerhouse of SSISNorman KelmBeginner
Using Spatial Data TypesRoss McNeelyBeginner
What Are You Waiting For?Jason StrateIntermediate
What's new with SQL Server 'Denali' for HA/DRMichael SteinekeIntermediate
Writing Professional Database CodeAaron LoweIntermediate
XQuery Basics for the DBAJason StrateIntermediate


Suggested Sessions

Thinking about participating as a speaker but no ideas for the topic? Often our attendees will have an idea for you! Or, submit a suggestion of your own.

SQLSaturday Home
PASS