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 TimeTrack 1 - Room: Room 1Track 2 - Room: Room 2Track 3 - Room: Room 3Track 4 - Room: Room 4Track 5 - Room: Room 5Track 6 - Room: Room 6Track 7 - Room: Room 7
09:00 AMBrian Knight

Introduction to SSIS

Level: Beginner
Jorge Segarra

SQL University 101:Starting the SQL Journey

Level: Beginner

download
Jack Corbett

Why Should I Use Stored Procedures?

Level: Beginner

download
Bayer White

Getting Started with AppFabric Caching (Velocity)

Level: Intermediate
Michael Mollenhour

Accurate MDX RoadTrip

Level: Intermediate
Troy Gallant

Introduction to Transactional Replication

Level: Beginner

download
Michael Antonovich

XML 101 for the SQL Developer

Level: Beginner

download
10:15 AMEric Wisdahl

SSIS - A Beginning Framework

Level: Intermediate

download
Jeffrey Garbus

Choosing Indexes for Performance

Level: Advanced
Plamen Ratchev

Refactoring SQL for Performance

Level: Intermediate

download
Andy Warren

Social and Not So Social Networking for the DBA

Level: Beginner
Aaron Nelson

PowerShell for Data Professionals

Level: Beginner

download
David Taylor

Using SSRS with Trending Reports

Level: Beginner

download
Nathan Heaivilin

Introduction to Execution Plans

Level: Beginner
11:30 AMBrian Knight

Iron Chef Competition: Loading a Data Warehouse

Level: Intermediate
Dmitri Korotkevitch

Getting familiar with SQL Server Storage Engine

Level: Beginner

download
Plamen Ratchev

Common SQL Programming Mistakes

Level: Intermediate

download
Jason Strate

Using XML to Query Execution Plans

Level: Intermediate
Chad Miller

PowerShell ETL

Level: Intermediate

download
Mark Landry

Building a Near-Realtime Operational Dashboard

Level: Advanced
Telmo Sampaio

SQL Server Beyond Relational

Level: Advanced
12:30 PMBrian Knight

Rapid BI Development with Pragmatic Works

Level: Beginner
Michael Ruland

SSIS users: Turbocharge your ETL with expressor

Level: Beginner
Janis Griffin

Real-World Performance Tuning

Level: Beginner
SQLSaturday Event

LUNCH

Level: Beginner
   
01:30 PMScott Gleason

PGP encryption using SSIS

Level: Intermediate
Geoff Hiten

Clustering for Mere Mortals

Level: Intermediate
Jeffrey Garbus

Bad, less Bad, not Bad; rewriting bad SQL Code

Level: Beginner
Kevin Boles

Care and Feeding of TempDB

Level: Intermediate

download
Ronald Dameron

Database Hardening via PowerShell

Level: Intermediate

download
Vikas Hawaldar

Data Mining and Predictive Analysis using SQL 2008

Level: Beginner
Michael Stark

SQLServer 2008 Spatial Data

Level: Intermediate

download
02:45 PMChristian Loris

SSIS and Slowly Changing Dimensions

Level: Intermediate
Jonathan Kehayias

Real Time Problem Identification with Event Notifi

Level: Intermediate

download
Jorge Segarra

Policy-Based Management 101

Level: Beginner

download
Herve Roggero

SQL Azure

Level: Beginner
Patrick LeBlanc

SQL Server Data Compression 101

Level: Beginner
Patricia (Pat) Baxter

5 Resolutions to Build Your Professional "Brand"

Level: Intermediate

download
Kathy Malone

Access SQL Back-End Gets Better Option

Level: Intermediate
04:00 PMMike Davis

Advanced Parameters in SSRS 2008

Level: Advanced
Jason Strate

ABCs of CTEs

Level: Intermediate

download
Elijah Baker

Database Table Partitioning, The Next Step

Level: Advanced
Scott Klein

Developing with SQL Azure

Level: Intermediate
Adam Jorgensen

Zero to Cube in 60 Minutes

Level: Intermediate
Janis Griffin

Tuna Helper for SQL Server DBA's

Level: Intermediate

download
Kevin Boles

SQL Server Service Broker

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
5 Resolutions to Build Your Professional "Brand"Patricia (Pat) BaxterIntermediate
ABCs of CTEsJason StrateIntermediate
Access SQL Back-End Gets Better OptionKathy MaloneIntermediate
Accurate MDX RoadTripMichael MollenhourIntermediate
Advanced Parameters in SSRS 2008Mike DavisAdvanced
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Building a Near-Realtime Operational DashboardMark LandryAdvanced
Care and Feeding of TempDBKevin BolesIntermediate
Choosing Indexes for PerformanceJeffrey GarbusAdvanced
Clustering for Mere MortalsGeoff HitenIntermediate
Common SQL Programming MistakesPlamen RatchevIntermediate
Data Cleansing with SSISBrian KnightAdvanced
Data Mining and Predictive Analysis using SQL 2008Vikas HawaldarBeginner
Database Hardening via PowerShellRonald DameronIntermediate
Database Table Partitioning, The BasicsElijah BakerIntermediate
Database Table Partitioning, The Next StepElijah BakerAdvanced
Develop in SetsDmitri KorotkevitchIntermediate
Developing with SQL AzureScott KleinIntermediate
Disk Partition AlignmentKevin BolesAdvanced
Dynamically Configuring PackagesMike DavisAdvanced
Getting familiar with SQL Server Storage EngineDmitri KorotkevitchBeginner
Getting Started with AppFabric Caching (Velocity)Bayer WhiteIntermediate
Getting To Know Your IndexesJason StrateIntermediate
High Availability options in SQL Server 2008Jeffrey GarbusAdvanced
How Change-Resilient Are You in the Digital Age? Patricia (Pat) BaxterIntermediate
Identifying and Removing Duplicate RecordsMichael AntonovichIntermediate
Implementing Auditing in SQL Server 2008 David DyeBeginner
Indexing for Join OptimizationJeffrey GarbusAdvanced
Intro to Powerpivot with Excel and Sharepoint 2010Patrick LeBlancBeginner
Introduction to Execution PlansNathan HeaivilinBeginner
Introduction to SSISBrian KnightBeginner
Introduction to Transactional ReplicationTroy GallantBeginner
Iron Chef Competition: Loading a Data WarehouseBrian KnightIntermediate
LUNCHSQLSaturday EventBeginner
Migrating DTS Packages to SSISMike DavisIntermediate
PGP encryption using SSISScott GleasonIntermediate
Policy-Based Management 101Jorge SegarraBeginner
PowerShell ETLChad MillerIntermediate
PowerShell for Data ProfessionalsAaron NelsonBeginner
Rapid BI Development with Pragmatic WorksBrian KnightBeginner
Real Time Problem Identification with Event NotifiJonathan KehayiasIntermediate
Real-World Performance TuningJanis GriffinBeginner
Refactoring SQL for PerformancePlamen RatchevIntermediate
Save Time with MERGEMichael AntonovichBeginner
Should You Require The Use of Stored Procedures?Andy WarrenBeginner
Social and Not So Social Networking for the DBAAndy WarrenBeginner
SQL 2008 Data Mining Implementation TechniquesVikas HawaldarAdvanced
SQL AzureHerve RoggeroBeginner
SQL Server 2008 XMLScott KleinIntermediate
SQL Server and SANsKevin BolesAdvanced
SQL Server Beyond RelationalTelmo SampaioAdvanced
SQL Server Data Compression 101Patrick LeBlancBeginner
SQL Server EncryptionHerve RoggeroIntermediate
SQL Server Service BrokerKevin BolesIntermediate
SQL SpatialTelmo SampaioIntermediate
SQL University 101:Starting the SQL JourneyJorge SegarraBeginner
SQL University 201: More DBA FunJorge SegarraIntermediate
SQLServer 2008 Spatial Data Michael StarkIntermediate
SSIS - A Beginning FrameworkEric WisdahlIntermediate
SSIS and Slowly Changing DimensionsChristian LorisIntermediate
SSIS Event Handlers for Auditing and NotificationMike DavisAdvanced
SSIS users: Turbocharge your ETL with expressorMichael RulandBeginner
Thinking in SetsJoe CelkoBeginner
Tuna Helper for SQL Server DBA'sJanis GriffinIntermediate
Unlocking a Goldmine - The Default TraceJack CorbettIntermediate
Using New Data Types and Features of SQL 2008James McAuliffeIntermediate
Using SSRS with Trending ReportsDavid TaylorBeginner
Using XML to Query Execution PlansJason StrateIntermediate
Why Should I Use Stored Procedures?Jack CorbettBeginner
XML 101 for the SQL DeveloperMichael AntonovichBeginner
Zero to Cube in 60 MinutesAdam JorgensenIntermediate
Zero to Cube in 60 MinutesAdam 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.

Suggested Session TitleSkill Level
Why IT managers should want SQLBeginner

SQLSaturday Home
PASS