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 Track #1 (105) - Room: Room 105BI Track #2 (106) - Room: Room 106DBA Track #1 (108) - Room: Room 108DBA Track #2 (109) - Room: Room 109Dev Track #1 (110) - Room: Room 110Dev Track #2 (111) - Room: Room 111Misc / Vendor (121) - Room: Room 121Prof Devel / Dev (113) - Room: Room 113
8:30 AMMatt Van Horn

Intro to SQL Reporting Services

Level: Beginner
Michael Coles

High-Speed Dimensional Data Loads With SSIS

Level: Intermediate

download
Muthu Ramanathan

Troubleshooting SQL performance

Level: Intermediate
Sebastian Meine

Concurrency Control

Level: Advanced
Mihail Mateev

Spatial Data and Windows Azure

Level: Advanced

download
Janis Griffin

SQL Server Service Broker – An Overview

Level: Intermediate

download
Vince Napoli

Intro to SSIS

Level: Beginner

download
William E. Pearson III

Entity Strategies: Structuring Your Consultancy

Level: Beginner
10:00 AMMatt Van Horn

SSRS Interactive Reports

Level: Intermediate
William E. Pearson III

Beyond Plateaux: Optimize SSAS via Best Practices

Level: Intermediate
Hilary Cotter

Slinging data with SQL Server Replication

Level: Intermediate
Raj More

Database design tips and tricks

Level: Intermediate
Joe Toscano

Table Partitioning: Implementing a sliding window

Level: Beginner

download
Janis Griffin

Query Tuning - Getting it Right the First Time!

Level: Beginner

download
Joe Dantoni

Building your first SQL Cluster

Level: Beginner
Michael Coles

Sell Yourself!

Level: Intermediate

download
12:30 PMMuthu Ramanathan

Parallel Data Warehousing

Level: Intermediate
William E. Pearson III

Many-to-Many: Multiple Calendars in a Single Cube

Level: Advanced
Said Salomon

Data Encryption and Key Management in SQL

Level: Intermediate

download
Robert Pearl

I/O, I/O It's Why my Server's Slow - Waits & Queue

Level: Intermediate
Mark Kromer

Migrate SQL Server Apps to SQL Azure Cloud DB

Level: Intermediate

download
Alex Grinberg

Advance T-SQL technique to optimize a code.

Level: Intermediate

download
 Sharon Dooley

Women In Technology Panel Discussion

Level: Beginner
2:15 PMKevin Goff

SSRS 2008R2 Reporting Gallery

Level: Intermediate
Mark Kromer

Light-up BI Dashboards with Cool Visualizations

Level: Intermediate

download
Randy Knight

Become Bilingual! Oracle for the SQL Server DBA

Level: Intermediate

download
Bharat Kenjale

Knowing Tempdb

Level: Intermediate

download
Bill Wolff

Accessing SQL Server Data with .NET

Level: Intermediate

download
Wayne Sheffield

Table Vars and Temp Tables-What you NEED to know!

Level: Intermediate

download
 Patty Pickup

Modeling Hierarchies in SQL

Level: Intermediate
3:45 PMKevin Goff

Business Intelligence with SharePoint 2010

Level: Intermediate
Mark Kromer

Building your first cube in SQL Server

Level: Beginner

download
Greg Seidel

Rolling upgrade 2008 R2 Cluster /SQL 2008 R2

Level: Intermediate

download
Dale Cunningham

Using Confio Ignite 8 for Production Failures

Level: Intermediate

download
Joe Dantoni

Deploying Data Tier Applications with SQL 2008 R2

Level: Intermediate
Randy Knight

Visual Studio 2010 Database Projects

Level: Intermediate

download
 Dennis Lloyd and Sebastian Meine .

TDD – Thwarting Database Defects

Level: Intermediate


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
Accessing SQL Server Data with .NETBill WolffIntermediate
Advance T-SQL technique to optimize a code.Alex GrinbergIntermediate
asdfasdf asdfBeginner
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIIntermediate
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
Building your first cube in SQL ServerMark KromerBeginner
Building your first SQL ClusterJoe DantoniBeginner
Business Intelligence with SharePoint 2010Kevin GoffIntermediate
Complex Event ProcessingMuthu RamanathanIntermediate
Concurrency ControlSebastian MeineAdvanced
Creating OLAP cubes in SSAS 2008Kevin GoffIntermediate
Data Encryption and Key Management in SQLSaid SalomonIntermediate
Database design tips and tricksRaj MoreIntermediate
Deploying Data Tier Applications with SQL 2008 R2Joe DantoniIntermediate
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Getting the most out of PerformancePoint Services Kevin GoffIntermediate
High-Speed Dimensional Data Loads With SSISMichael ColesIntermediate
How SQL Server Indexes Work: Part 1Sharon DooleyAdvanced
How SQL Server Indexes Work: Part 2Sharon DooleyAdvanced
I/O, I/O It's Why my Server's Slow - Waits & QueueRobert PearlIntermediate
Integrating SSRS 2008R2 with SharePoint 2010Kevin GoffIntermediate
Intro to SQL Reporting ServicesMatt Van HornBeginner
Intro to SSISVince NapoliBeginner
Intro to T-SQL ProgrammingMatt Van HornBeginner
Introduction To ReplicationSebastian MeineAdvanced
Knowing TempdbBharat KenjaleIntermediate
Light-up BI Dashboards with Cool VisualizationsMark KromerIntermediate
Many-to-Many: Multiple Calendars in a Single Cube William E. Pearson IIIAdvanced
Migrate SQL Server Apps to SQL Azure Cloud DBMark KromerIntermediate
Modeling Hierarchies in SQLPatty PickupIntermediate
Parallel Data WarehousingMuthu RamanathanIntermediate
PowerPivot - DAX and SharePoint IntegrationKevin GoffIntermediate
Practical uses of MDXKevin GoffIntermediate
Query Tuning - Getting it Right the First Time!Janis GriffinBeginner
Rolling upgrade 2008 R2 Cluster /SQL 2008 R2Greg SeidelIntermediate
Sell Yourself!Michael ColesIntermediate
Slinging data with SQL Server ReplicationHilary Cotter Intermediate
Spatial Data and Windows Azure Mihail MateevAdvanced
SQL Server Performance Tuning Hilary Cotter Intermediate
SQL Server Service Broker – An OverviewJanis GriffinIntermediate
SSRS 2008R2 Reporting GalleryKevin GoffIntermediate
SSRS Interactive ReportsMatt Van HornIntermediate
Table Partitioning: Implementing a sliding windowJoe ToscanoBeginner
Table Vars and Temp Tables-What you NEED to know!Wayne SheffieldIntermediate
TDD – Thwarting Database DefectsDennis Lloyd and Sebastian Meine .Intermediate
testVince NapoliBeginner
Transact-SQL 2008 for Application DevelopersKevin GoffIntermediate
Troubleshooting SQL performanceMuthu RamanathanIntermediate
Using Confio Ignite 8 for Production FailuresDale CunninghamIntermediate
Visual Studio 2010 Database ProjectsRandy KnightIntermediate
Women In Technology Panel DiscussionSharon DooleyBeginner


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