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 TimeBI-1 - Room: Room 4BI-2 - Room: Room 5DBA-1 - Room: Room 1DBA-2 - Room: Room 2Development - Room: Room 3
8:15 AMBrian Knight

Introduction to PowerPivot

Level: Intermediate
Steve Hughes

Report Lockdown: Implementing SSRS Security

Level: Intermediate

download
Kevin Kline

SQL Server Internals and Architecture

Level: Beginner

download
Eric Strom

Tuning SQL Code using Logical Equivalencies

Level: Intermediate

download
Mike Benkovich

Taking your Data to SQL Azure

Level: Intermediate

download
9:30 AMBrian Knight

Performance Tuning SQL Server Integration Services

Level: Advanced
Mark Vaillancourt

Intro To Reporting Services(2008 R2) Report Models

Level: Beginner

download
Bill Preachuk

Maintenance Plans - Lessons from the Real World

Level: Beginner

download
Jason Strate

Using XML to Query Execution Plans

Level: Intermediate

download
Ross McNeely

Dynamic Text File Creation Via Single SSIS Package

Level: Intermediate
10:45 AMBrian Larson

Using Data Mining to Improve SSIS Data Loads

Level: Intermediate

download
Gilbert Evans

Self-Service Reporting/Analytics for SQL Server

Level: Beginner
Kevin Kline

Top 10 Admin Mistakes on SQL Server

Level: Beginner

download
Dean Richards

Query Tuning - Get it Right the First Time

Level: Beginner
Eddie Wuerch

Drive SQL Server Performance: I/O For Developers

Level: Intermediate

download
12:45 PMDan English

Leverage the MS BI Toolset to Monitor Performance

Level: Beginner

download
William Pearson

Getting Started with MDX

Level: Beginner
Tim Plas

Managing and Administering SQL Azure

Level: Intermediate

download
Zach Mattson

Powershell Eye for the Monitoring Guy.

Level: Intermediate

download
Russel Loski

Stored procedure tracing using the xml datatype

Level: Beginner

download
02:00 PMDavid Baldauff

A Single Sign-On BI Story: SAML Claims in SharePoi

Level: Intermediate
Mustafa Hussain

Answers at the speed of thought with SSAS Cubes

Level: Beginner
Eddie Wuerch

Find Performance Problems by Reading the Waits

Level: Intermediate
Jason Strate

Extended Events, Work Smarter Not Harder

Level: Intermediate

download
Mike Benkovich

Programming with OData & the Microsoft Data Stack

Level: Intermediate

download
3:15 PMRussel Loski

SSIS and SSRS Better Together

Level: Advanced

download
William Pearson

Documenting Your Integrated Microsoft BI Solution

Level: Beginner
Tim Plas

High-Availability and DR Options for SQL Server

Level: Intermediate

download
Ben Thul

Introduction To Transactional Replication

Level: Beginner

download
Eric Zierdt

Table Partitions for Archiving

Level: Intermediate

download


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
A Single Sign-On BI Story: SAML Claims in SharePoiDavid BaldauffIntermediate
Answers at the speed of thought with SSAS CubesMustafa HussainBeginner
Attribute Discretization in Analysis ServicesWilliam PearsonIntermediate
Design and Implement Like Edison!William PearsonBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam PearsonBeginner
Drive SQL Server Performance: I/O For DevelopersEddie WuerchIntermediate
Dynamic Text File Creation Via Single SSIS PackageRoss McNeelyIntermediate
End-to-End Troubleshooting for SQL Server Kevin KlineIntermediate
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Find Performance Problems by Reading the WaitsEddie WuerchIntermediate
Getting Started with MDXWilliam PearsonBeginner
Getting To Know Your IndexesJason StrateIntermediate
High-Availability and DR Options for SQL ServerTim PlasIntermediate
Intro To Reporting Services(2008 R2) Report ModelsMark VaillancourtBeginner
Intro to Wait Types and Response Time AnalysisDean RichardsBeginner
Introduction to PowerPivotBrian Knight Intermediate
Introduction To Transactional ReplicationBen ThulBeginner
Leverage the MS BI Toolset to Monitor PerformanceDan EnglishBeginner
Maintenance Plans - Lessons from the Real WorldBill PreachukBeginner
Managing and Administering SQL AzureTim PlasIntermediate
Performance Tuning SQL Server Integration ServicesBrian Knight Advanced
Powershell Eye for the Monitoring Guy.Zach MattsonIntermediate
Programming with OData & the Microsoft Data StackMike BenkovichIntermediate
Query Tuning - Get it Right the First TimeDean RichardsBeginner
Report Lockdown: Implementing SSRS Security Steve HughesIntermediate
Reporting Services Tips & TricksSteve HughesIntermediate
Restores for the Drafted DBADan ArmsBeginner
Self-Service Reporting/Analytics for SQL ServerGilbert EvansBeginner
Si Se Puede! Achieving Separation of DutiesLara RubbelkeIntermediate
SQL Server Internals and ArchitectureKevin KlineBeginner
SSIS and SSRS Better TogetherRussel LoskiAdvanced
Stored procedure tracing using the xml datatypeRussel LoskiBeginner
Table Partitions for ArchivingEric ZierdtIntermediate
Taking your Data to SQL AzureMike BenkovichIntermediate
Thinking outside the Tablix: Creative Uses of SSRSBrian LarsonIntermediate
Top 10 Admin Mistakes on SQL ServerKevin KlineBeginner
Tuning SQL Code using Logical EquivalenciesEric StromIntermediate
Tuples, Sets and Members: Understanding MDX BasicsBrian LarsonIntermediate
Using Data Mining to Improve SSIS Data LoadsBrian LarsonIntermediate
Using XML to Query Execution PlansJason 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