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 TimeAdvanced DBA - Room: Room 119BI - Room: Room 118DBA - Room: Room 116Developer - Room: Room 117
09:00 AMArie Jones

Monitoring Data Changes with Change Data Capture

Level: Advanced

download
William Pearson

Attribute Discretization in Analysis Services

Level: Intermediate
Michael Coles

Build Your Own Search Engine With SQL Server

Level: Intermediate

download
Tim Chapman

Writing faster queries

Level: Advanced

download
10:15 AMAllen White

Manage SQL Server System and Performance Data with

Level: Advanced

download
Arie jones

Better Data Visualizations with SSRS

Level: Intermediate

download
Thomas LaRock

Performance Tuning Made Easy

Level: Intermediate

download
Randy Knight

Visual Studio 2010 Database Projects

Level: Beginner

download
11:30 AMTim Chapman

Capturing SQL Server performance diagnostics

Level: Intermediate
Michael Coles

High Performance SSIS Dimensional Datamart Loads

Level: Intermediate

download
Louis Davidson

Database Design Fundamentals

Level: Beginner

download
Eddie Wuerch

Drive SQL Server Performance: I/O For Developers

Level: Intermediate

download
12:30 PM  Kathi Kellenberger

Women in Technology Luncheon

Level: Beginner
 
01:45 PMAllen White

Automate Policy-Based Management using PowerShell

Level: Advanced

download
Craig Utley

Do It Right: Best Practices for Analysis Services

Level: Intermediate

download
Eddie Wuerch

Find Performance Problems by Reading the Waits

Level: Intermediate

download
John Welch

Moving Data with SQL Azure and SSIS

Level: Beginner
03:00 PMMichael Coles

SQL Server Encryption - Secure Your Data @ Rest!

Level: Intermediate

download
Craig Utley

PowerPivot: Delivering Self-Serve BI

Level: Beginner

download
Randy Knight

Become a Bilingual DBA! Oracle for the SQL Server

Level: Intermediate

download
Louis Davidson

Red Gate SQL Monitor

Level: Beginner
04:15 PMKathi Kellenberger

Achieving Separation of Duties with SQL Server

Level: Advanced

download
Dave Fackler

ETL from the Trenches: SSIS in the Real World

Level: Intermediate

download
Kim Tessereau

Indexes and Execution Plans

Level: Beginner

download
Kevin Cross

Effective SQL: Understanding Order of Operations

Level: Beginner

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
Achieving Separation of Duties with SQL ServerKathi KellenbergerAdvanced
Add It Up: Analysis Services AggregationsCraig UtleyAdvanced
Analysis Services 2008 End-to-EndCraig UtleyBeginner
Attribute Discretization in Analysis ServicesWilliam PearsonIntermediate
Automate Policy-Based Management using PowerShell Allen WhiteAdvanced
Avoid Slow SSAS Queries: MDX Query TroubleshootingCraig UtleyAdvanced
Become a Bilingual DBA! Oracle for the SQL Server Randy KnightIntermediate
Better Data Visualizations with SSRSArie jonesIntermediate
Build Your Own Search Engine With SQL ServerMichael ColesIntermediate
Capturing SQL Server performance diagnosticsTim ChapmanIntermediate
Characteristics of a Great Relational Database Louis DavidsonBeginner
Data Mining in Action: a Case StudyDrew MinkinAdvanced
Database Design FundamentalsLouis DavidsonBeginner
Delivering BI DataCraig UtleyAdvanced
Delivering Rapid Business Value with Microsoft BIDerek ComingoreAdvanced
Design and Implement Like Edison!William PearsonBeginner
Do It Right: Best Practices for Analysis Services Craig UtleyIntermediate
Do You Know the Data Flow?John WelchBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam PearsonBeginner
Drive SQL Server Performance: I/O For DevelopersEddie WuerchIntermediate
Effective SQL: Understanding Order of OperationsKevin CrossBeginner
ETL from the Trenches: SSIS in the Real WorldDave FacklerIntermediate
Find Performance Problems by Reading the WaitsEddie WuerchIntermediate
Getting Started with MDXWilliam PearsonBeginner
High Performance SSIS Dimensional Datamart Loads Michael ColesIntermediate
How, where, why, and when to use Dynamic SQLTim ChapmanIntermediate
Indexes and Execution PlansKim TessereauBeginner
Introduction to SQL Server Spatial DataMichael ColesIntermediate
Manage SQL Server System and Performance Data withAllen WhiteAdvanced
Many-to-Many: Multiple Calendars in a Single Cube William Pearson, CPA, CITP, CMA, CIA, MCSE, MCDBA, MVPIntermediate
Monitoring Data Changes with Change Data CaptureArie JonesAdvanced
Moving Data with SQL Azure and SSISJohn WelchBeginner
MSFT BI Conference 2010 Session: SSIS & CDCDerek ComingoreIntermediate
Overview of Microsoft Atlanta ProjectChris SkorlinskiBeginner
Overview of Microsoft Atlanta ProjectChris SkorlinskiBeginner
Overview of Microsoft Replication TechnologiesChris SkorlinskiBeginner
Part 1 - Introduction to Change Data CaptureChris SkorlinskiIntermediate
Part 2- Integrating CDC with SSISChris SkorlinskiIntermediate
Performance Tuning Made EasyThomas LaRockIntermediate
PowerPivot: Delivering Self-Serve BICraig UtleyBeginner
Processing Flat Files with SSISJohn WelchBeginner
Red Gate SQL MonitorLouis DavidsonBeginner
Sell Yourself!Michael ColesBeginner
SQL DBA Best PracticesChris SkorlinskiBeginner
SQL Server Encryption - Secure Your Data @ Rest!Michael ColesIntermediate
SQL Server PowerPivot for Information ProducersDerek ComingoreBeginner
SQL Server PowerPivot for IT ProsDerek ComingoreIntermediate
SQL Server Service BrokerDan CrawfordIntermediate
SQL Server Spatial Data - Getting StartedDan CrawfordIntermediate
SQL Server Transactional Replication Demystified Arie jonesIntermediate
The Benefits of SQL AzureAaron KingBeginner
The Modern Resume: Building Your BrandSteve JonesBeginner
Visual Studio 2010 Database Projects Randy KnightBeginner
We ain't afraid of no errors!Kim TessereauBeginner
Why Data Warehousing Projects FailCraig UtleyBeginner
Women in Technology LuncheonKathi KellenbergerBeginner
Writing faster queriesTim ChapmanAdvanced
Zero to Dashboard 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
Effective SQL Queries Beginner
How and When to Use Indexed ViewsBeginner
How to Back Up and Protect SQL Server DatabasesBeginner
Stored Procedure Best PracticesBeginner
Using TSQL to Create Business RulesBeginner

SQLSaturday Home
PASS