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 - Room: 5186DBA - Room: 5182DBA/Dev - Room: 7091Dev - Room: 5184Prof. Dev. - Room: 7063SAN/Virtualization/Denali - Room: 7087
08:30 AMIra Whiteside

(SSIS, TSQL and MDS) - Record Linkage Fuzzy Match

Level: Intermediate
Chris Skorlinski

Transactional Replication – Follow the Data

Level: Beginner

download
Ashton Hobbs

Understanding (B)locking

Level: Intermediate

download
Mark Hudson

Making Predictions with Microsoft Data Mining Tool

Level: Intermediate

download
Jeremy Kadlec

Build Your SQL Server Career

Level: Intermediate
Aaron Nelson

PowerShell for SQL and New Denali Features

Level: Intermediate

download
09:45 AMAndy Leonard

Designing an SSIS Framework

Level: Advanced
Luke Jian

Optimizing SQL Server I/O with Solid State Drives

Level: Intermediate

download
Ashton Hobbs

Understanding Indexes

Level: Beginner

download
Geoff Johnson

Intro to Common Table Expressions

Level: Beginner

download
Chris Skorlinski

How to get Hired in the first 10 minutes

Level: Beginner

download
Joey D'Antoni

SAN Basics for DBAs

Level: Beginner
12:00 PMMark Hudson

Introduction to Analysis Services

Level: Beginner

download
Allan Hirt

Windows Failover Clustering Basics for the DBA

Level: Intermediate
James Gaines

Automating Database Source Control

Level: Beginner

download
Geoff Johnson

Intro to Ranking and Aggregate Window Functions

Level: Beginner

download
Dennis Lloyd Jr and Sebastian Meine

Thwarting Database Defects

Level: Intermediate
Joey Dantoni

Virtualization for SQL DBAs

Level: Intermediate
01:15 PMSandra Mueller

Developing Date and Role-Playing Dimensions

Level: Intermediate

download
Alex Grinberg

SQL Server XML 101

Level: Advanced

download
Wayne Sheffield

Table Vars & Temp Tables - What you NEED to Know!

Level: Intermediate

download
Karen Lopez

Model-Driven Database Design

Level: Beginner

download
William E. Pearson III

Entity Strategies: Structuring Your Consultancy

Level: Beginner
Thomas LaRock

Monitoring Databases in a Virtual Environment

Level: Beginner

download
02:30 PMJessica Moss

How to Increase Development Productivity in SSRS

Level: Beginner

download
Sebastian Meine

Mining XML Query Plans

Level: Advanced
Dan Clark

Getting Spatial with SQL Server 2008

Level: Beginner
Luke Jian

Join operations - Explaining Merge,Hash and Loop

Level: Intermediate

download
James Gaines

An intro to Oracle Databases for SQL Server DBAs

Level: Beginner

download
Kevin Goff

What's new in Denali - a whirlwind tour

Level: Intermediate
03:45 PMWilliam E. Pearson III

An Overview of PowerPivot

Level: Beginner
Sandra Mueller

Data Files and Transaction Logs – Beyond the GUIs

Level: Beginner

download
Kevin Goff

Change Data Capture in SQL Server 2008

Level: Intermediate
Wayne Sheffield

Banish RBAR!

Level: Intermediate

download
Brian Moran

Leadership Coaching: A repeatable methodology...

Level: Beginner
Brian Garraty

PowerShell: A Tale of Two Checklists

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
Sebastian MeineAdvanced
(SSIS, TSQL and MDS) - Record Linkage Fuzzy MatchIra WhitesideIntermediate
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
5+ Database Design Blunders and How To Avoid ThemKaren LopezBeginner
A Peek at the SQL Server Data Warehouse EditionsMark KromerIntermediate
A Sneak Peek at High Availability in DenaliAllan HirtIntermediate
An intro to Oracle Databases for SQL Server DBAsJames GainesBeginner
An Overview of PowerPivot William E. Pearson IIIBeginner
An Overview of PowerPivot in SharePointWilliam E. Pearson IIIIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Automating Database Source Control James GainesBeginner
Back to basics - Algebrizer Deep DiveLuke JianAdvanced
Back to basics - Algebrizer Deep DiveLuke JianAdvanced
Banish RBAR!Wayne SheffieldIntermediate
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Build Your SQL Server CareerJeremy KadlecIntermediate
CAMP Geekalot for DBAsChris SkorlinskiBeginner
Change Data Capture in SQL Server 2008Kevin GoffIntermediate
Concurrency ControlSebastian MeineAdvanced
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Creating maps with Reporting Services R2Kevin GoffIntermediate
Data Files and Transaction Logs – Beyond the GUIs Sandra MuellerBeginner
Database Design for Developers Andy LeonardBeginner
Denali in PowerPivot: Self-Service BI Big Time!Kevin GoffIntermediate
Design a Dashboard in a DashJessica MossBeginner
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Designing an SSIS Framework Andy LeonardAdvanced
Developing Date and Role-Playing DimensionsSandra MuellerIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Entity Strategies: Structuring Your Consultancy William E. Pearson IIIBeginner
Evaluate your daily checklist with PBM and CMSJohn SterrettIntermediate
Getting Spatial with SQL Server 2008Dan ClarkBeginner
Getting Started with MDX William E. Pearson IIIBeginner
How to get Hired in the first 10 minutes Chris SkorlinskiBeginner
How to Increase Development Productivity in SSRSJessica MossBeginner
How to Migrate from SQL Server to SQL AzureMark KromerBeginner
Ins and Outs of SQL Server Integration ServicesJeremy KadlecBeginner
Integrating MDX code with OLAP applicationsKevin GoffIntermediate
Integrating Reporting Services with SharePointKevin GoffIntermediate
Intermediate/Advanced SSISKevin GoffIntermediate
Intro to C# for the SSIS Script ComponentJoel CochranBeginner
Intro to Common Table ExpressionsGeoff JohnsonBeginner
Intro to Ranking and Aggregate Window FunctionsGeoff JohnsonBeginner
Introduction to Analysis ServicesMark HudsonBeginner
Is That A Failover Cluster On Your Laptop?Allan HirtIntermediate
Join operations - Explaining Merge,Hash and Loop Luke JianIntermediate
Leadership Coaching: A repeatable methodology...Brian MoranBeginner
Making Predictions with Microsoft Data Mining ToolMark HudsonIntermediate
Making Predictions with Microsoft Data Mining ToolMark HudsonIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Microsoft Cloud BIMark KromerIntermediate
Mining XML Query PlansSebastian MeineAdvanced
Model-Driven Database DesignKaren LopezBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockBeginner
Optimizing SQL Server I/O with Solid State DrivesLuke JianIntermediate
Placeholder 1To Be DeterminedBeginner
Placeholder 2To Be DeterminedBeginner
PowerPivot for Excel William E. Pearson IIIBeginner
PowerShell for SQL and New Denali FeaturesAaron NelsonIntermediate
PowerShell: A Tale of Two ChecklistsBrian GarratyIntermediate
Practical use of latest features in T-SQL.Alex GrinbergIntermediate
SAN Basics for DBAsJoey D'AntoniBeginner
Serene Velocity: Reporting Services and SSAS Data William E. Pearson IIIIntermediate
SQL Server Denali HAPrakash HedaAdvanced
SQL Server Denali PreviewMark KromerBeginner
SQL Server XML 101Alex GrinbergAdvanced
SSIS Scripting 101Dan ClarkBeginner
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
The Power of NumbersSebastian MeineIntermediate
Thwarting Database DefectsDennis Lloyd Jr and Sebastian MeineIntermediate
Transactional Replication – Follow the DataChris SkorlinskiBeginner
T-SQL for Application Developers - Attendees choseKevin GoffIntermediate
Understanding (B)lockingAshton HobbsIntermediate
Understanding IndexesAshton HobbsBeginner
Virtualization for SQL DBAsJoey DantoniIntermediate
What's new in Denali - a whirlwind tourKevin GoffIntermediate
Why OLAP? Building SSAS cubes and benefits of OLAPKevin GoffIntermediate
Windows Failover Clustering Basics for the DBAAllan HirtIntermediate


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