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: Room 3BI - Room: Room 2DBA - Room: Room 5DBA / DEV - Room: Room 1DBA / DEV - Room: Room 4
8:30 AMMarc Beacom

Introduction to Data Warehousing

Level: Beginner

download
Bill Fellows

Kama Sutra of SSIS: A guide to loving ETL

Level: Beginner

download
Tim Ford

The Periodic Table of Dynamic Management Objects

Level: Intermediate

download
Jason Horner

PowerShell for the Reluctant DBA / Developer

Level: Beginner
Ted Malone

To the Cloud and Back Again!

Level: Intermediate
9:30 AMThomas LeBlanc

Dimenional Modeling 101

Level: Intermediate

download
Josh Fennessy

*GASP* Real-time user defined sets in SSAS

Level: Advanced

download
Grant Fritchey

7 Ways to Fix Bad Parameter Sniffing

Level: Intermediate

download
Keith Tate

Development Mise en Place

Level: Beginner
Chris Randall

SQL Azure: Future-Proofing Your SQL Career

Level: Intermediate

download
11:00 AMDoug Lane

Devs are from Mars, Report Servers are from Venus

Level: Beginner

download
Carlos Bossy

Using Columnstore Indexes in SQL Server 2012

Level: Beginner

download
Jim Murphy

AlwaysOn - Finally, A usable 'mirror'!

Level: Beginner
Vicky Harp

Edge Case Testing for the Database Professional

Level: Beginner

download
Ben DeBow

Your own Private Cloud for SQL

Level: Intermediate

download
1:30 PMDavid Eichner

SQL Report Builder for Business Intelligence

Level: Beginner

download
Troy Ketsdever

Predictive Analytics - You Can, Too!

Level: Intermediate

download
Jason Strate

Discovering the Plan Cache

Level: Intermediate

download
Meredith Ryan-Smith

Backup Basics - Know your options

Level: Beginner

download
Tom Norman

PBM and you!

Level: Beginner
2:30 PMMichael Sexton

ETL as MDM

Level: Intermediate

download
John Halunen & Aubra Moore

Reporting DBs behind Virtual IP's

Level: Intermediate

download
Joe Sack

Performance Issue Archetypes

Level: Intermediate

download
John Morehouse

10 Things That Every DBA Should Know!

Level: Beginner

download
Thomas LaRock

Choose Your Own Adventure: Performance Tuning

Level: Advanced
4:00 PMWilliam E Pearson III

PowerPivot for Excel

Level: Beginner
Michael Fal

Eating the Elephant: SQL Server Table Partitioning

Level: Intermediate

download
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Mark Halstead

PowerShell and VBScript for the DBA

Level: Beginner

download
Randy Knight

But it worked great in Dev! Perfomance for Devs

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
"SOA What??": Service Broker BasicsJason HornerBeginner
*GASP* Real-time user defined sets in SSASJosh FennessyAdvanced
10 Things That Every DBA Should Know!John MorehouseBeginner
5+ Database Design Blunders and How To Avoid ThemKaren LopezBeginner
7 Ways to Fix Bad Parameter SniffingGrant FritcheyIntermediate
Administering the BI StackJosh FennessyIntermediate
AlwaysOn - Finally, A usable 'mirror'!Jim MurphyBeginner
An Overview of PowerPivotWilliam E Pearson IIIBeginner
Attribute Discretization in Analysis Services (BI)William E Pearson IIIBeginner
Backup Basics - Know your optionsMeredith Ryan-SmithBeginner
Become Bilingual! Oracle for the SQL Server DBARandy KnightIntermediate
Becoming DAX: An Introduction ... William E Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E Pearson IIIIntermediate
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Choose Your Own Adventure: Performance TuningThomas LaRockAdvanced
Consolidated SQL Server ArchitecturesBen DeBowIntermediate
Data File Sizes – How much is enough, if you don’tTjay BeltBeginner
Database Design Contentious IssuesKaren LopezIntermediate
Data-Driven Report Subscriptions with SSISDoug LaneIntermediate
Design and Implement BI Like Edison! William E Pearson IIIBeginner
Develop a Star Schema for High Performance ReportsCarlos BossyBeginner
Development Mise en PlaceKeith TateBeginner
Devs are from Mars, Report Servers are from VenusDoug LaneBeginner
Dimenional Modeling 101Thomas LeBlancIntermediate
Discovering the Plan CacheJason StrateIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E Pearson IIIIntermediate
Drive Your Way to the DMVJason StrateIntermediate
Eating the Elephant: SQL Server Table PartitioningMichael FalIntermediate
Edge Case Testing for the Database ProfessionalVicky HarpBeginner
Entity Strategies: Structuring Your ConsultancyWilliam E Pearson IIIBeginner
Error Handling in ETLMichael SextonBeginner
ETL as MDMMichael SextonIntermediate
Execution Plan Basics - BeginnersThomas LeBlancBeginner
Execution Plan IntermiediateThomas LeBlancAdvanced
Execution Plans and tuning queriesMark HalsteadIntermediate
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Find Performance Problems by Reading the WaitsEddie WuerchIntermediate
Form And Substance: The “T” of ETLMichael SextonIntermediate
Getting Started with MDXWilliam E Pearson IIIBeginner
Getting to Know Index Operation StatsJason StrateIntermediate
Getting To Know Your IndexesJason StrateIntermediate
Hardware 301: Diving Deeper into Database HardwareGlenn BerryIntermediate
Introduction to Analysis ServicesMarc BeacomBeginner
Introduction to Common Table ExpressionsVicky HarpIntermediate
Introduction to Data WarehousingMarc BeacomBeginner
Introduction to Integration ServicesMarc BeacomBeginner
Isn't that SpatialJason HornerBeginner
Kama Sutra of SSIS: A guide to loving ETLBill FellowsBeginner
Little in the middle but got much [Write]BackJosh FennessyIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E Pearson IIIAdvanced
Monitoring Databases in a Virtual EnvironmentThomas LaRockIntermediate
Only You Can Prevent Database Fires!John MorehouseBeginner
Page Latches for Mere MortalsEddie WuerchIntermediate
Parallel Processing Database ArchitectureJeff RenzBeginner
PBM and you!Tom NormanBeginner
Performance Enhancing LazinessTim FordBeginner
Performance Issue ArchetypesJoe SackIntermediate
Performance Tuning TriageJoe SackIntermediate
PowerPivot for ExcelWilliam E Pearson IIIBeginner
PowerShell and VBScript for the DBAMark HalsteadBeginner
PowerShell for the Reluctant DBA / DeveloperJason HornerBeginner
Predictive Analytics - You Can, Too!Troy KetsdeverIntermediate
Production is all Virtualized, Is Yours?Tom NormanBeginner
Real-time Data Warehouse and ReportingCarlos BossyIntermediate
Reporting DBs behind Virtual IP'sJohn Halunen & Aubra MooreIntermediate
Scaling SQL ServerGlenn BerryIntermediate
Searching for the Holy Grail of DDL AuditingColleen MorrowBeginner
Serene Velocity: Reporting Services and SSAS DataWilliam E Pearson IIIIntermediate
something about Powershell and SQL ServerTjay BeltBeginner
SQL Azure: Future-Proofing Your SQL CareerChris RandallIntermediate
SQL Report Builder for Business IntelligenceDavid EichnerBeginner
Stand-alone DBA daily/weekly/monthly tasksTjay BeltBeginner
TDE, oh what fun! Auditing, No!!Tom NormanIntermediate
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Creepy DBA, How to Stalk Your UsersJason StrateIntermediate
The Fabulous Query Plan Primer Michael FalIntermediate
The Honey Badger Approach to Policy Based MgmtMitchell BottelBeginner
The One Week Data MartJeff RenzBeginner
The Periodic Table of Dynamic Management ObjectsTim FordIntermediate
The Point of Attack – SQL Intrusion and PreventionGabriel VillaBeginner
To SSIS or Not SSIS, That is the QuestionJeff RenzBeginner
To the Cloud and Back Again!Ted MaloneIntermediate
Understanding SQL Server XML Features Randy KnightIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Using Columnstore Indexes in SQL Server 2012Carlos BossyBeginner
Want a promotion? It’s up to you!Mitchell BottelBeginner
What Are You Waiting For? Jason StrateIntermediate
XQuery Basics for the DBAJason StrateIntermediate
Your own Private Cloud for SQLBen DeBowIntermediate


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
PowerShell for DummiesBeginner

SQLSaturday Home
PASS