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 TimeSSIS/ETL - Room: St. LawrenceBI - Room: HudsonData Development - Room: YukonFuture Directions - Room: ThamesInfrastructure - Room: ColoradoPerformance/Monitoring - Room: Columbia
08:00 AM

Registration and Breakfast

Level: Beginner
     
08:30 AM

Welcome Session and Keynote

Level: Beginner
     
09:00 AMAndy Leonard

SSIS - The New Stuff

Level: Intermediate
Barry Ralston

PowerPivot, Idea to Solution in 60 Minutes

Level: Beginner
Andrew Kelly

Understanding Indexes in SQL Server 2008

Level: Beginner

download
Jack Corbett

Inroduction to Triggers

Level: Beginner

download
Allan Hirt

So Many High Availability Options, So Little Time

Level: Beginner

download
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Intermediate
10:15 AMMichael Coles

High Performance SSIS Dimensional Datamart ETL

Level: Intermediate

download
Sunil Kadimdiwan

Interactive Dashboards with PerformancePoint 2010

Level: Intermediate

download
Steve Simon

Database Design for mere developers

Level: Intermediate

download
Jeff Mlakar

Introduction to Developing with SQL Azure

Level: Beginner

download
Joseph Dantoni

Building your first SQL Cluster

Level: Beginner

download
Aaron Bertrand

T-SQL : Bad Habits to Kick

Level: Beginner

download
11:30 AM

WhereScape: Data Integration and Transformation

Level: Beginner

download
 

Axis Technology: Data Masking

Level: Beginner

download
  

Vendor Session - Red Gate

Level: Beginner
12:15 PM

Lunch

Level: Beginner
     
01:15 PMAndy Leonard

“I See a Control Flow Tab. Now What?”

Level: Beginner
Slava Kokaev

Introduction to MDX

Level: Beginner
Andrew Kelly

Maximizing Plan Re-use in SQL 2008

Level: Intermediate

download
Allen White

Let Service Broker Help You Scale Your Application

Level: Intermediate
Craig Purnell

Database Mirroring in the Real World

Level: Intermediate

download
Paul White

SQL Query Optimization - It's Not Rocket Science!

Level: Advanced

download
02:30 PMMatt Masson

SSIS Performance Design Patterns

Level: Advanced

download
Mike Walsh

As A DBA, Where Do I Start?!

Level: Beginner
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Bill Wilder

Storing Data in the Cloud: Beyond SQL Azure

Level: Beginner

download
Mike Hillwig

Consolidation and Virtualization: A Success Story

Level: Intermediate

download
Chris Skorlinski

"Extra Eyes" for Monitoring SQL Server

Level: Beginner
03:45 PMIra Whitreside

Creating a Metadata Mart wi/SSIS - Data Governance

Level: Intermediate
Rob MacNaughton

Self Service BI on a Budget

Level: Intermediate
John Flannery

Encryption in SQL 2008 R2 - Column and TDE

Level: Intermediate

download
Jason Alexander

Career Development for Local SQL Professionals

Level: Beginner
Ayad Shammout

SQL Server 2008 Auditing

Level: Beginner
Adam Machanic

15 Powerful SQL Server Dynamic Management Objects

Level: Intermediate

download
05:00 PMKaren Lopez

Women in Technology

Level: Beginner
     
05:30 PM

Raffle - Win Great Prizes

Level: Beginner
     
06:00 PM

Networking

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
"Extra Eyes" for Monitoring SQL ServerChris SkorlinskiBeginner
(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)Ira WhitesideIntermediate
“I See a Control Flow Tab. Now What?” Andy LeonardBeginner
15 Powerful SQL Server Dynamic Management ObjectsAdam MachanicIntermediate
A Sneak Peek at High Availability in DenaliAllan HirtIntermediate
Access ADPs in depth - optimum SQL Server comboJuan SotoIntermediate
Access with SQL Server Express - Perfect!Juan SotoIntermediate
An Overview of PowerPivotWilliam PearsonBeginner
An Overview of PowerPivot for ExcelWilliam PearsonIntermediate
An Overview of PowerPivot in SharePointWilliam PearsonIntermediate
As A DBA, Where Do I Start?!Mike WalshBeginner
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIIntermediate
Automate Policy-Based Management using PowerShellAllen WhiteIntermediate
Axis Technology: Data Masking Beginner
Become Bilingual! Oracle for the SQL Server DBARandy KnightIntermediate
Becoming DAX: An Introduction ...William E. Pearson IIIBeginner
Beyond Plateaux: Optimize SSAS via Best PracticesWilliam E. Pearson IIIIntermediate
BI: Then and Now Bob AbernethyIntermediate
Building a Cluster Aware Development EnvironmentJohn FlanneryAdvanced
Building a High Availability SQL Server 2008 R2Ayad ShammoutIntermediate
Building your first SQL ClusterJoseph DantoniBeginner
Business Intelligence Solutions with PowerPivotBarry RalstonBeginner
Career Development for Local SQL ProfessionalsJason AlexanderBeginner
Cloudy DataJim O'NeilIntermediate
Consolidation and Virtualization: A Success StoryMike HillwigIntermediate
Creating a Metadata Mart wi/SSIS - Data GovernanceIra WhitresideIntermediate
Database Design Contentious IssuesKaren LopezIntermediate
Database Design for mere developersSteve SimonIntermediate
Database Mirroring in the Real WorldCraig PurnellIntermediate
Deploy SQL 2008 R2 Using Windows Storage Server Peter TassmerAdvanced
Deploying Data Tier Applications with SQL 2008 R2Joseph DantoniIntermediate
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Designing an SSIS Framework Andy LeonardAdvanced
Developing Date and Role-Playing DimensionsSandra MuellerIntermediate
Do More (ETL) with Less (Effort) - Automating SSISJohn WelchAdvanced
Do You Know the Data Flow?John WelchBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Encryption in SQL 2008 R2 - Column and TDEJohn FlanneryIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started with MDX William E. Pearson IIIBeginner
Handling Advanced Data Warehouse Scenarios in SSISJohn WelchIntermediate
High Performance SSIS Dimensional Datamart ETLMichael ColesIntermediate
Inroduction to TriggersJack CorbettBeginner
Integrating SQL Server with Active DirectoryCraig PurnellIntermediate
Interactive Dashboards with PerformancePoint 2010Sunil KadimdiwanIntermediate
Introduction to Developing with SQL Azure Jeff MlakarBeginner
Introduction to MDXSlava KokaevBeginner
Introduction to SQL Server Parallel Data WarehouseBrian MitchellIntermediate
Is That A Failover Cluster On Your Laptop?Allan HirtBeginner
Let Service Broker Help You Scale Your ApplicationAllen WhiteIntermediate
Lunch Beginner
Making sense of SQL Server availability optionsDavid BerminghamBeginner
Management Studio Tips & TricksAaron BertrandBeginner
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Maximizing Plan Re-use in SQL 2008Andrew KellyIntermediate
MS Access with SQL Server Strategies and TipsJuan SotoBeginner
Multisite Clusters for HA and Disaster RecoveryDavid BerminghamBeginner
Networking Beginner
No more Scripting! Automated DB Source ControlRandy KnightIntermediate
Part 1 - Introduction to Change Data Capture Chris SkorlinskiBeginner
Part 2- Integrating CDC with SSIS Chris SkorlinskiIntermediate
PowerPivot for Excel and SharePoint 2010Ayad ShammoutBeginner
PowerPivot, Idea to Solution in 60 MinutesBarry RalstonBeginner
Query Optimizer Deep DivePaul WhiteAdvanced
Raffle - Win Great Prizes Beginner
Registration and Breakfast Beginner
Self Service BI on a BudgetRob MacNaughtonIntermediate
Serious solutions to complex data challengesSteve SimonIntermediate
Slipstreaming SQL ServerCraig PurnellBeginner
So Many High Availability Options, So Little TimeAllan HirtBeginner
Solving Real Life Production IssuesDale CunninghamIntermediate
SQL Query Optimization - It's Not Rocket Science!Paul WhiteAdvanced
SQL Server 2008 AuditingAyad ShammoutBeginner
SQL Server DMV OverviewWilliam AssafIntermediate
SSAS & PowerPivot with Excel's CUBE functionsPhilip TaylorBeginner
SSIS - The New StuffAndy LeonardIntermediate
SSIS Performance Design PatternsMatt MassonAdvanced
SSRS Administration - Enter a BIDS Free ZoneSandra MuellerIntermediate
Storing Data in the Cloud: Beyond SQL AzureBill WilderBeginner
Table Vars and Temp Tables-What you NEED to know!Wayne SheffieldBeginner
Troubleshooting SSRS Performance IssuesSteve SimonIntermediate
T-SQL : Bad Habits to KickAaron BertrandBeginner
TSQL for the Access GuyJuan SotoBeginner
Understanding Indexes in SQL Server 2008Andrew KellyBeginner
Vendor Session - Red Gate Beginner
Visual Studio 2010 Database ProjectsRandy KnightIntermediate
Welcome Session and Keynote Beginner
What are you Waiting for? Intro to Waits & QueuesRobert PearlBeginner
What is this cache and why is it so big?Doug BrendleIntermediate
What's new in SQL Server 2011 ("Denali")?Aaron BertrandBeginner
WhereScape: Data Integration and Transformation Beginner
Why I Use Stored Procedures?Jack CorbettBeginner
Windows Failover Clustering Basics for the DBAAllan HirtIntermediate
Women in TechnologyKaren LopezBeginner
You inherited a database Now What?Tim RadneyBeginner
Zero To Cube - Fast Track to Analysis ServicesAdam JorgensenIntermediate


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