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 3
8:30 AMNone None

Registration & Breakfast

Level: Beginner
None None

Registration & Breakfast

Level: Beginner
None None

Registration & Breakfast

Level: Beginner
9:10 AMEd Wilson

Windows PowerShell Best Practices for DBA's

Level: Beginner

download
Matthew Velic

Hello World (Schema) - Introduction to T-SQL

Level: Beginner

download
Paul Hiles

DMVs- What are they and why should a DBA care?

Level: Beginner

download
10:20 AMEd Wilson

Windows PowerShell Best Practices for DBA's part 2

Level: Beginner
Bronwyn Altizer

Wait-Time Based SQL Server Performance Management

Level: Intermediate
Allen White

Let Service Broker Help You Scale Your Application

Level: Beginner
11:30 AMPaul Hiles

Take Your Automation Script to the Next Level!

Level: Intermediate

download
Joey Dantoni

Building Your First SQL Cluster

Level: Intermediate
Andy Leonard

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

Level: Beginner
1:30 PMAbi Chapagai

High Availability Solutions in SQL Server

Level: Beginner
William E. Pearson III

Design and Implement BI Like Edison!

Level: Beginner
Andy Leonard

Designing an SSIS Framework

Level: Advanced
2:40 PMCraig Purnell

Database Mirroring in the Real World

Level: Beginner

download
William E. Pearson III

An Overview of PowerPivot

Level: Beginner
Allen White

Automate Policy-Based Management using PowerShell

Level: Advanced
3:50 PMCraig Purnell

NoSQL- What is it and why do I care?

Level: Beginner

download
James Gaines

Automating Database Source Control

Level: Intermediate

download
Shannon Lowder

Lessons Learned: Starting your career as a DBA.

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
“I See a Control Flow Tab. Now What?” Andy LeonardBeginner
“So You Want to be a Database Professional?”Andy LeonardBeginner
0 to SSAS under 1 hourJose ChinchillaBeginner
0 to SSIS underJose ChinchillaBeginner
0 to SSRS under 1 hourJose ChinchillaBeginner
An Overview of PowerPivot William E. Pearson IIIBeginner
An Overview of PowerPivot for ExcelWilliam E. Pearson IIIBeginner
An Overview of PowerPivot in SharePointWilliam E. Pearson IIIIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIIntermediate
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Automating Database Source ControlJames GainesIntermediate
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 SQL ClusterJoey DantoniIntermediate
Communicate for Great Good!Matt VelicBeginner
Database Mirroring in the Real WorldCraig PurnellBeginner
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Designing an SSIS Framework Andy LeonardAdvanced
Designing and Optimizing Hierarchies in SSAS 2008 Jose ChinchillaIntermediate
DMVs- What are they and why should a DBA care?Paul HilesBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Evaluate your daily checklist using CMS and PBMJohn SterrettIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started with MDXWilliam E. Pearson IIIBeginner
Hello World (Schema) - Introduction to T-SQLMatthew VelicBeginner
High Availability Solutions in SQL ServerAbi ChapagaiBeginner
Intro to PowerShell ScriptingPaul HilesBeginner
Introduction to SQL Server 2008 for DevelopersJohn SterrettBeginner
Lessons Learned: Starting your career as a DBA.Shannon LowderBeginner
Let Service Broker Help You Scale Your ApplicationAllen WhiteBeginner
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
NoSQL- What is it and why do I care? Craig PurnellBeginner
Registration & BreakfastNone NoneBeginner
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
Some Thoughts on Database Lifecycle ManagementAndy LeonardIntermediate
SQL SOS – Navigating your New DBA DutiesMatt VelicBeginner
Take Your Automation Script to the Next Level! Paul HilesIntermediate
The Career Your Career Could Smell LikeShannon LowderBeginner
Top Ten Operational Mistakes to AvoidMike HillwigBeginner
Top Ten Rules for Managing a Production EnvironmenMike HillwigBeginner
Top Ten Rules for Managing a Production EnvironmenMike HillwigBeginner
Understanding SQL Server XML Features Randy KnightIntermediate
Upgrade Roadmap: taking YOU to R2Craig PurnellBeginner
Viagra for your SSIS package: Tips for performanceJose ChinchillaIntermediate
Visual Studio 2010 Database ProjectsRandy KnightIntermediate
Wait-Time Based SQL Server Performance ManagementBronwyn AltizerIntermediate
Windows PowerShell Best Practices for DBA'sEd WilsonBeginner
Windows PowerShell Best Practices for DBA's part 2Ed WilsonBeginner
Windows PowerShell Best Practices for DBA's part 3Ed WilsonBeginner
XQuery BasicsAllen WhiteBeginner


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
Automate DB Source ControlIntermediate
Building and Executing a Disaster Recovery PlanIntermediate
Designing a Highly Available SQL environmentIntermediate
Extended EventsBeginner
Introduction to SQL AzureBeginner
Introduction to SQL ProgrammingBeginner
Introduction to SSRSBeginner
Introduction to T-SQLBeginner
Lessons Learned: Starting your career as a DBA.Beginner
Monitoring Wait StatsBeginner
Performance Tuning T-SQLIntermediate
PowerShell for DBA'sBeginner
SQL Server DMV's Intermediate
SQL Server InternalsIntermediate

SQLSaturday Home
PASS