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: AP1-MPRTrack 2 - Room: AP1-Training 1Track 3 - Room: AP1-Training 2Track 4 - Room: AP1-Training 3Track 5 - Room: AP1-Training 4Track 6 - Room: AP2-Mt. McKinleyTrack 7 - Room: AP2-Mt. KilimanjaroTrack 8 - Room: AP2-MatterhornTrack 9 - Room: AP2-VTC
08:15 AMAndy Warren, Steve Jones, Rushahb Mehta

KEYNOTE: SQLSaturday Past, Present and Future

Level: Beginner
        
09:00 AMSergey Pustovit

SQL Server 2008/R2 Overview

Level: Beginner
Aaron Bertrand

Management Studio Tips & Tricks

Level: Beginner

download
Steve Wright

Memory Management in SQL Server Analysis Services

Level: Intermediate
Mike Walsh

As a DBA, Where do I start?

Level: Beginner
Andy Kelly

Practical Performance Monitoring in SQL Server

Level: Intermediate

download
Timothy Ford

Insight Into Your Indexes With DMVs

Level: Intermediate
Aaron Nelson

Virtualize This!

Level: Beginner
Andy Leonard

Build Your First SSIS Package

Level: Beginner
Brett Tomson

What's New In SSRS 2008

Level: Beginner

download
10:15 AMRushabh Mehta

Building PowerPivot Models and Reports

Level: Beginner
Jason Hall

Things Your Mom Never Told You About SSMS

Level: Intermediate

download
Chris Skorlinski

Comparison of Replication Technologies

Level: Beginner

download
Kendal Van Dyke

Getting started in blogging and technical speaking

Level: Beginner

download
Andy Warren

Introduction to SQL Server Statistics

Level: Beginner
Sergey Pustovit

SQL Server Performance Related DMVs

Level: Intermediate
Denny Cherry

Is Virtualization is a good choice for SQL Server?

Level: Advanced
John Welch

Creating Custom Components for SSIS

Level: Intermediate
Jessica Moss

Incorporating Reporting Services into SharePoint

Level: Beginner
11:30 AMEvan Basalik

SQL Azure: Data in the Cloud is a Good Thing

Level: Beginner

download
Timothy Ford

Tips For The Lazy But Driven DBA

Level: Beginner
Chris Skorlinski

Troubleshooting Transactional Replication

Level: Intermediate

download
Steve Jones

The Modern Resume: Building Your Brand

Level: Beginner

download
Brett Tomson

Growing Pains - A Cautionary Tale

Level: Beginner

download
Andrew Kelly

Collecting and Analyzing File & Wait Statistics

Level: Intermediate

download
Geoff Hiten

Clustering for Mere Mortals.

Level: Intermediate

download
Aaron Nelson

PowerShell Awesomesauce

Level: Beginner
Jessica Moss

Adding SSRS Report Bells and Whistles

Level: Intermediate
12:30 PMSQL Sentry

Sponsor Lunch

Level: Beginner
Microsoft Cafeteria

LUNCH!

Level: Beginner
       
01:30 PMBill Walker

SQL Server Support Team Q&A

Level: Beginner
Jana Sattainathan

Partitioning in SQL Server 2005/2008

Level: Intermediate
Mark Tabladillo

Data Mining Beyond Adventure Works

Level: Intermediate

download
Patrick LeBlanc

SQL Server Data Compression 101

Level: Beginner
Amy Styers

Know Your IO: Gain Better Performance with Ease

Level: Intermediate
Andrew Kelly

Maximizing Plan Re-use in SQL 2008

Level: Advanced

download
Kendal Van Dyke

The (Solid) State Of Drive Technology

Level: Intermediate

download
Aaron Nelson

PowerShell for Data Professionals

Level: Beginner

download
John Welch

Delivering BI Solutions Rapidly using Vulcan

Level: Intermediate
02:45 PMDenny Cherry

Storage for the DBA

Level: Advanced
Mike Walsh

You Can Improve Your Own SQL Code

Level: Beginner
Wayne Snyder

SSRS In the Enterprise - Surviving With a Smile!

Level: Intermediate

download
Ashton Hobbs

Compression in SQL 2008

Level: Intermediate
Janis Griffin

Tuna Helper for SQL Server DBA's

Level: Intermediate

download
Kevin Kline

SQL Server Internals & Architecture

Level: Advanced

download
Rushabh Mehta

Harnessing PowerPivot

Level: Intermediate
Allen White

Automate SQL Server Administration with PowerShell

Level: Intermediate

download
Rafael Salas

SSIS, You, and ETL Architecture

Level: Intermediate

download
04:00 PMKevin Kline

Top 10 Mistakes on SQL Server

Level: Intermediate

download
Geoff Hiten

Bad SQL.

Level: Advanced

download
Evan Basalik

Diagnosing Connectivity Issues with SQL Server

Level: Intermediate

download
Dave Turpin

De-mystifying Query Plan Analysis

Level: Intermediate

download
Alejandro Mesa

Parameter Sniffing

Level: Intermediate
Jeffry Schwartz

SQL Server Performance Outside the Box

Level: Advanced

download
Denny Cherry

SQL Server Service Broker in the Real World

Level: Beginner
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Advanced
Andy Leonard

Applied SSIS Design Patterns

Level: Advanced


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
Adding SSRS Report Bells and WhistlesJessica MossIntermediate
Advanced SQL Service Broker Tips and TricksDenny CherryIntermediate
Applied SSIS Design PatternsAndy LeonardAdvanced
As a DBA, Where do I start?Mike WalshBeginner
Automate SQL Server Administration with PowerShellAllen WhiteIntermediate
Automating & Analyzing with SQL Trace & RML UtilitAndrew KellyIntermediate
Bad SQL.Geoff HitenAdvanced
Basic Monitoring with PerfmonRick HeigesBeginner
Build Your First SSIS PackageAndy LeonardBeginner
Build Your First SSIS PackageAndy LeonardBeginner
Building PowerPivot Models and ReportsRushabh MehtaBeginner
Clustering for Mere Mortals.Geoff HitenIntermediate
Collecting and Analyzing File & Wait StatisticsAndrew KellyIntermediate
Comparison of Replication TechnologiesChris SkorlinskiBeginner
Comparison of Replication TechnologiesChris SkorlinskiBeginner
Compression in SQL 2008 Ashton HobbsIntermediate
Creating Custom Components for SSISJohn WelchIntermediate
Customizing SSAS DimensionsRushabh MehtaIntermediate
Data Mining Beyond Adventure WorksMark TabladilloIntermediate
Database Design for DevelopersAndy LeonardIntermediate
Delivering BI Solutions Rapidly using VulcanJohn WelchIntermediate
De-mystifying Query Plan AnalysisDave TurpinIntermediate
Diagnosing Connectivity Issues with SQL ServerEvan BasalikIntermediate
Diagnosing connectivity issues with SQL ServerEvan BasalikIntermediate
Diagnosing connectivity issues with SQL ServerEvan BasalikAdvanced
Disk Partitioning and AlignmentKevin BolesIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteAdvanced
Getting started in blogging and technical speakingKendal Van DykeBeginner
Growing Pains - A Cautionary TaleBrett TomsonBeginner
Harnessing PowerPivotRushabh MehtaIntermediate
Incorporating Reporting Services into SharePointJessica MossBeginner
Insight Into Your Indexes With DMVsTimothy FordIntermediate
Introduction to SQL Server StatisticsAndy WarrenBeginner
Introduction to SSISJohn WelchBeginner
Is Virtualization is a good choice for SQL Server?Denny CherryAdvanced
KEYNOTE: SQLSaturday Past, Present and FutureAndy Warren, Steve Jones, Rushahb MehtaBeginner
Know Your IO: Gain Better Performance with EaseAmy StyersIntermediate
LUNCH!Microsoft CafeteriaBeginner
Management Studio Tips & TricksAaron BertrandBeginner
Managing SQL Server database projects using VisualRafael SalasBeginner
Maximizing Plan Re-use in SQL 2008Andrew KellyAdvanced
Memory Management in SQL Server Analysis ServicesSteve WrightIntermediate
Monitor Your SQL Server with SQL ProfilerDave TurpinIntermediate
Parameter SniffingAlejandro MesaIntermediate
Partitioning in SQL Server 2005/2008Jana SattainathanIntermediate
PowerShell AwesomesauceAaron NelsonBeginner
PowerShell for Data ProfessionalsAaron NelsonBeginner
Practical Performance Monitoring in SQL ServerAndy KellyIntermediate
Say NO to Maintenance PlansAndrew KellyIntermediate
Scale-Out the DBAGeoff HitenAdvanced
Social and Not So Social Networking for the DBA Andy WarrenBeginner
Sponsor LunchSQL SentryBeginner
Sponsor Lunch - MicrosoftBill WalkerBeginner
SQL Azure - Data in the Cloud is a Good ThingEvan BasalikBeginner
SQL Azure: Data in the Cloud is a Good ThingEvan BasalikBeginner
SQL Azure: Your Data in the Cloud is a Good ThingEvan BasalikIntermediate
SQL InjectionKevin BolesIntermediate
SQL Server 2008/R2 OverviewSergey PustovitBeginner
SQL Server and SANSKevin BolesAdvanced
SQL Server Clustering UnleashedSergey PustovitAdvanced
SQL Server Data Compression 101Patrick LeBlancBeginner
SQL Server Diagnostics Tools UnleashedSergey PustovitIntermediate
SQL Server in Auto RacingAndrew KorczynskiBeginner
SQL Server Internals & ArchitectureKevin KlineAdvanced
SQL Server Memory Management UnleashedSergey PustovitAdvanced
SQL Server Performance Outside the BoxJeffry SchwartzAdvanced
SQL Server Performance Related DMVsSergey PustovitIntermediate
SQL Server Service Broker in the Real WorldDenny CherryBeginner
SQL Server Support Team Q&ABill WalkerBeginner
SQL Service BrokerKevin BolesIntermediate
SSIS and SSAS Programmability Made Easy w/ VulcanJohn WelchAdvanced
SSIS, You, and ETL ArchitectureRafael SalasIntermediate
SSRS In the Enterprise - Surviving With a Smile!Wayne SnyderIntermediate
Storage for the DBADenny CherryAdvanced
Table Partitioning: Implementing a Sliding WindowDave TurpinIntermediate
TempDB to Best EffectKevin BolesAdvanced
The (Solid) State Of Drive TechnologyKendal Van DykeIntermediate
The Modern Resume: Building Your BrandSteve JonesBeginner
The Shade Tree Mechanic's Guide to SSASSteve WrightBeginner
The Social DBA: Resources for Career BuildingStuart AinsworthBeginner
The Social DBA: Resources for Career BuildingStuart AinsworthBeginner
Things Your Mom Never Told You About SSMSJason HallIntermediate
Tips For The Lazy But Driven DBATimothy FordBeginner
Top 10 Mistakes on SQL ServerKevin KlineIntermediate
Troubleshooting SSRS PerformanceEvan BasalikIntermediate
Troubleshooting SSRS PerformanceEvan BasalikIntermediate
Troubleshooting Transactional ReplicationChris SkorlinskiIntermediate
Tuna Helper for SQL Server DBA'sJanis GriffinIntermediate
Use PowerShell to Get the Most out of SQL ServerAllen WhiteBeginner
Virtualize This!Aaron NelsonBeginner
What's New In SSRS 2008Brett TomsonBeginner
Working With XML in SQL ServerKendal Van DykeBeginner
XQuery BasicsAllen WhiteBeginner
You Can Improve Your Own SQL CodeMike WalshBeginner


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
Using Subversion for T-SQL Source ControlBeginner
Using Subversion for T-SQL Source ControlBeginner

SQLSaturday Home
PASS