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 - Room: Room 4Developer Track - Room: Room 3SQl Server Track 2 - Room: Room 2SQl Server Track 1 - Room: Room 1
08:30 AMWilliam E. Pearson III

Getting Started with MDX

Level: Beginner
Arie Jones

Getting Started With Service Broker

Level: Intermediate
Sarah Barela

SQL Server Forensics: Tracking your users

Level: Intermediate

download
Kevin Kline

SQL Server Internals and Architecture

Level: Intermediate

download
09:45 AMJohn Welch

Do More (ETL) with Less (Effort) - Automating SSIS

Level: Intermediate
Aaron King

Multi-Tenant Database Model with SQL Azure

Level: Advanced

download
John Magnabosco

Exploring Data Privacy

Level: Intermediate

download
Eddie Wuerch

Find Performance Problems by Reading the Waits

Level: Intermediate

download
11:00 AMWilliam E. Pearson III

An Overview of PowerPivot for Excel

Level: Intermediate
Janis Griffin

Looney Tuner? No, there IS a method to my madness

Level: Intermediate

download
Kevin Boles

SQL Server Memory Deep Dive

Level: Advanced

download
Kim Tessereau

Indexes and Execution Plans

Level: Beginner

download
01:00 PMIra Whiteside

Creating a Metadata Mart w/ SSIS - Data Governance

Level: Intermediate
Craig Purnell

NoSQL- What is it and why do I care?

Level: Beginner

download
Arie Jones

Take Control of Your Databases with PBM!

Level: Intermediate
Eddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate

download
02:15 PMJohn Welch

Tuning Analysis Services Processing Performance

Level: Advanced
Kevin Boles

Advanced TSQL Solutions

Level: Advanced

download
Craig Purnell

Database Mirroring in the Real World

Level: Beginner

download
Luke Jian

Back to basics - How does the Algebrizer work

Level: Advanced

download
03:30 PMArie Jones

Reporting Services Greatness!

Level: Beginner
Norman Kelm

PowerShell, the New SQL Hammer

Level: Beginner
Kevin Kline

Top 10 Admin Mistakes on SQL Server

Level: Intermediate

download
Janis Griffin

Performance Management – 2008 MDW - How & Why

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
(SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)Ira WhitesideIntermediate
A Data Center Migration StoryDale HughesBeginner
Advanced TSQL SolutionsKevin BolesAdvanced
An Overview of PowerPivot William E. Pearson IIIBeginner
An Overview of PowerPivot for Excel William E. Pearson IIIIntermediate
An Overview of PowerPivot in SharePoint William E. Pearson IIIIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIIntermediate
Back to basics - How does the Algebrizer workLuke JianAdvanced
Becoming DAX: An Introduction ...William E. Pearson IIIBeginner
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Build your own SQL Server CloudSarah BarelaBeginner
Common TSQL MistakesKevin BolesIntermediate
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Database Mirroring in the Real WorldCraig PurnellBeginner
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Do More (ETL) with Less (Effort) - Automating SSISJohn WelchIntermediate
Do You Know the Data Flow?John WelchIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Exploring Data PrivacyJohn MagnaboscoIntermediate
Find Performance Problems by Reading the WaitsEddie WuerchIntermediate
Getting Started with MDX William E. Pearson IIIBeginner
Getting Started With Service BrokerArie JonesIntermediate
Handling FILESTREAM in SQL Server 2008 R2Arie JonesIntermediate
Indexes and Execution PlansKim TessereauBeginner
Intro to SQL TraceArie JonesIntermediate
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
Managing System Resources with Resource GovernorArie JonesIntermediate
Many-to-Many: Multiple Calendars in a Single Cube William E. Pearson IIIAdvanced
Monitoring Data Changes with Change Data Capture Arie JonesIntermediate
MS Access with SQL Server Strategies and TipsJuan JuanBeginner
MS Access with SQL Server: Optimizing your codeJuan JuanIntermediate
Multi-Tenant Database Model with SQL AzureAaron KingAdvanced
NoSQL- What is it and why do I care? Craig PurnellBeginner
Oh, no! Disaster StrikesSarah BarelaBeginner
Optimizing SQL Server I/O with Solid State DrivesLuke JianIntermediate
Parallel Query Execution Deep DiveKevin BolesAdvanced
Partitioning for Perf & Management of Large TablesEddie WuerchIntermediate
Performance Management – 2008 MDW - How & WhyJanis GriffinIntermediate
PowerShell, the New SQL HammerNorman KelmBeginner
Reporting Services Greatness!Arie JonesBeginner
SANs and SQL ServerKevin BolesAdvanced
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
SQL InjectionKevin BolesIntermediate
SQL Server Forensics: Tracking your usersSarah BarelaIntermediate
SQL Server Internals and ArchitectureKevin KlineIntermediate
SQL Server Memory Deep DiveKevin BolesAdvanced
SQL Server Partitioning from A to ZKevin BolesIntermediate
SQL Server Service Broker – An OverviewJanis GriffinIntermediate
Take Control of Your Databases with PBM!Arie JonesIntermediate
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The 4-hour DBA: Automate, Audit and RelaxSarah BarelaBeginner
The Script Task, powerhouse of SSISNorman KelmBeginner
Top 10 Admin Mistakes on SQL ServerKevin KlineIntermediate
Tuning Analysis Services Processing PerformanceJohn WelchAdvanced
Upgrade Roadmap: taking YOU to R2Craig PurnellBeginner
WIT PanelCaroline BaileyBeginner


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