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 2150Track 10 - Room: Room 3315Track 2 - Room: Room 3314Track 3 - Room: Room 2316Track 4 - Room: Room 2315Track 5 - Room: Room 2314Track 6 - Room: Room 3316Track 7 - Room: Room 2301Track 8 - Room: Room 3311Track 9 - Room: Room 2305
08:00 AMSQLSaturday 237

Breakfast & Check-In

Level: Non-Technical
         
08:30 AMDandy Weyn

Keynote and Opening Remarks

Level: Non-Technical
         
09:15 AMPeter Myers

Mastering the CUBE Functions in Excel 2013

Level: Intermediate

download
James Serra

Transitioning to a BI role

Level: Beginner

download
Mladen Prajdic

SQL Impossible: Restoring/Undeleting a table

Level: Advanced
Andy Isley

PDW - Where are the landmines? Does it truly perform the way marketing says and at what cost?

Level: Intermediate

download
Paul Rizza

ETL not ELT! Common mistakes and misconceptions about SSIS

Level: Advanced
Aaron Nelson

SQL Server Database Development with SSDT

Level: Intermediate
Jesus Gil Velasco

1000 ways to die (your SSAS Server)

Level: Advanced
Thomas LeBlanc

Attributes & Hierarchies in Analysis Services 2012

Level: Intermediate
Mickey Stuewe

Scalable SSRS Reports Achieved Through the Powerful Tablix

Level: Intermediate
Mike Donnelly

SSIS and Azure - ETLing in the Cloud

Level: Beginner

download
10:15 AMSQLSaturday 237

Break Time

Level: Non-Technical
         
10:30 AMJen Stirrup

Data Visualisation with Hadoop Mashups, Power View and Excel 2013

Level: Intermediate
Rick Hallihan

Hadoop Part I - Launch Hadoop in just 4 clicks!

Level: Beginner
David Peter Hansen

First look at the In-Memory OLTP component in SQL Server 2014

Level: Advanced
Michael Femenella

Temporary Insanity

Level: Intermediate

download
Reza Rad

Inferred Dimension Members within MDS and SSIS

Level: Advanced

download
Neil Hambly

MDS and DQS - Beyond the TLAs to Data Quality

Level: Beginner
Mark Vaillancourt

MDX Trek: First Contact

Level: Intermediate

download
Cathy Miller

Creating Queries using Microsoft Power Query for Excel

Level: Beginner
Julie Koesmarno

From Impaired To Insightful Geospatial Reporting

Level: Beginner

download
Teo Lachev

Best Practices for Implementing an Enterprise BI Solution

Level: Advanced

download
11:30 AMSQLSaturday 237

Break Time

Level: Non-Technical
         
11:45 AMSQLSaturday 237

Lunch Break

Level: Non-Technical
         
12:45 PMStacia Misner

A Big Data Primer

Level: Beginner
Geoff Hiten

Smart Rats Leave First

Level: Beginner
Benjamin Nevarez

Dive into the Query Optimizer-Undocumented Insight

Level: Advanced

download
Jason Horner

Dimensional Modeling Design Patterns: Beyond Basics

Level: Intermediate
Jose Chinchilla

Change Data Capture tool for BI,Auditing,DR & more

Level: Beginner
Tim Mitchell

Handling Errors and Data Anomalies in SSIS

Level: Intermediate
Wayne Snyder

Understand/Code/Debug Many-to-Many Relationships i

Level: Intermediate
Rob Volk

Harvesting Web Data Using Power Query & Other Tools

Level: Beginner

download
Bradley Schacht

New Hotness: SQL Server 2012 and SharePoint 2013

Level: Beginner
Allan Mitchell

Hadoop for the Microsoft Guy

Level: Intermediate
01:45 PMSQLSaturday 237

Break Time

Level: Non-Technical
         
02:00 PMAndy Leonard

Hacking the SSIS 2012 Catalog

Level: Beginner
Jessica Moss

Lights, Camera, Action: Creating and Delivering Technical Presentations

Level: Non-Technical

download
Mark Vaillancourt

DANGER: The Art and Science of Presenting

Level: Beginner

download
Jeffrey Wang

Understand Evaluation Contexts in DAX

Level: Advanced
Jose L. Rivera

Tips and Tricks for Dimensional Loading

Level: Intermediate
Mickey Stuewe

Improve the Performance of Your T-SQL by Changing Your Habits

Level: Beginner
John Welch

Tuning Analysis Services Processing Performance

Level: Advanced
Steve Hughes

Using PowerPivot to Drive Quality into ETL Processes

Level: Intermediate
Pam Shaw

Tips & Tricks for dynamic SSRS Reports

Level: Beginner

download
Leo Furlong

Data Management In the Enterprise: Where does Business Intelligence and Master Data Management Fit?

Level: Non-Technical
03:00 PMSQLSaturday 237

Break Time

Level: Non-Technical
         
03:15 PMDevin Knight

Getting Started with Power Query

Level: Beginner
Paul Waters

Automating SSIS Development with Biml

Level: Beginner
Chris Bell

“Indexing” Encrypted Data

Level: Intermediate
Gregory Suarez

Hadoop Part II – Hadoop tools for the SQL DBA

Level: Beginner
Steve Simon

Challenges to designing financial warehouses, lessons learnt

Level: Intermediate
Steven Wake

SSIS 2012: More Than Just a Pretty UI

Level: Beginner

download
Guillermo Caicedo

Enrich your applications with SQL Server Reporting Services

Level: Intermediate
Bill Anton

The 20-Minute Tabular Model

Level: Beginner
Doug Cox

Self-Service BI using Excel 2013

Level: Beginner
Brent Greenwood

Faster & Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular

Level: Intermediate
04:15 PMSQLSaturday 237

Closing Remarks & Raffle

Level: Non-Technical
         


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
Mickey StueweBeginner
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
“Indexing” Encrypted DataChris BellIntermediate
10 Tips and Tricks for better SSIS PerformanceDavid Peter HansenAdvanced
1000 ways to die (your SSAS Server)Jesus Gil VelascoAdvanced
A Big Data PrimerStacia MisnerBeginner
A dive into Data Quality ServicesSteve SimonIntermediate
Advanced Data Visualisation with Reporting ServicesJen StirrupIntermediate
Analysing Data with Power ViewJen StirrupIntermediate
Applied Enterprise Semantic MiningMark TabladilloIntermediate
Attributes & Hierarchies in Analysis Services 2012Thomas LeBlancIntermediate
Automating SSIS Development with BimlPaul WatersBeginner
Back to Basics: SSIS 2012 for BeginnersBradley SchachtBeginner
Bad SQLGeoff HitenIntermediate
Best Practices for Implementing an Enterprise BI SolutionTeo LachevAdvanced
Best Practices to Deliver BI SolutionsJames SerraBeginner
BI Mobile - The next Generation?Jesus Gil VelascoIntermediate
Big Data Analytics with PowerPivot and Power ViewPeter MyersIntermediate
BIML vs EzAPI - Do you really need them? Will they speed up my develpment?Andy IsleyIntermediate
Building an Effective Data Warehouse ArchitectureJames SerraBeginner
Building an Effective Data Warehouse ArchitectureJames SerraBeginner
Building BI Solutions with Excel 2013Steve HughesBeginner
Capture Change and Apply it With Change Data Capture & SSISSteven WakeIntermediate
Challenges to designing financial warehouses, lessons learntSteve SimonIntermediate
Challenges to designing financial warehouses, lessons learntSteve SimonIntermediate
Change Data Capture tool for BI,Auditing,DR & moreJose ChinchillaBeginner
Clustering for Mere Mortals.Geoff HitenIntermediate
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Creating a Power View Reporting SolutionDevin KnightBeginner
Creating an Extensible Data Quality FoundationKevin HazzardIntermediate
Creating an SSIS template using BIMLRuss LoskiIntermediate
Creating Dashboards with PerformancePoint ServicesDevin KnightIntermediate
Creating efficient and effective SSRS BI SolutionsSteve SimonIntermediate
Creating Queries using Microsoft Power Query for ExcelCathy MillerBeginner
DANGER: The Art and Science of PresentingMark VaillancourtBeginner
Data Capture & Tracking Deep DiveKevin HazzardIntermediate
Data Management In the Enterprise: Where does Business Intelligence and Master Data Management Fit?Leo FurlongNon-Technical
Data Mining Innovation with SQL Server 2012Mark TabladilloAdvanced
Data Mining with the Data Mining Plugin for ExcelBradley SchachtBeginner
Data Visualisation with Hadoop Mashups, Power View and Excel 2013Jen StirrupIntermediate
Data Warehouse ETL Rollback with SSIS 2012Jessica MossAdvanced
DAX and the tabular modelSteve SimonIntermediate
Defeating the Limitations of the Query OptimizerBenjamin NevarezAdvanced
Dimensional Modeling Design Patterns: Beyond BasicsJason HornerIntermediate
Dive into the Query Optimizer-Undocumented InsightBenjamin NevarezAdvanced
Dynamic SSISMichael FemenellaIntermediate
End-User Microsoft BI tools – Clearing up the confusionJames SerraBeginner
Enrich your applications with SQL Server Reporting ServicesGuillermo CaicedoIntermediate
ETL not ELT! Common mistakes and misconceptions about SSISPaul RizzaAdvanced
Excel 2013: BI for the MassesDevin KnightBeginner
Extract and Transform XML Data From Web ServicesReza RadIntermediate
Faster & Leaner: Optimize DW Solution Delivery with Power Pivot and AS TabularBrent GreenwoodIntermediate
First look at the In-Memory OLTP component in SQL Server 2014David Peter HansenAdvanced
Flipping Through the SSIS CatalagMike DonnellyBeginner
From Impaired To Insightful Geospatial ReportingJulie KoesmarnoBeginner
From SQL Traces to Extended Events. The next big switch.Mladen PrajdicIntermediate
G.I.G.O. (Garbage In Garbage Out) - Data Quality For DummiesDavid OrtizBeginner
Get your Mining Model Predictions out to allSteve SimonIntermediate
Getting Started with Power QueryDevin KnightBeginner
Grab your pick and shovel. Let's get miningSteve SimonIntermediate
Hacking the SSIS 2012 CatalogAndy LeonardBeginner
Hadoop for the Microsoft GuyAllan MitchellIntermediate
Hadoop Part I - Launch Hadoop in just 4 clicks!Rick HallihanBeginner
Hadoop Part II – Hadoop tools for the SQL DBAGregory SuarezBeginner
Handling Errors and Data Anomalies in SSISTim MitchellIntermediate
Harvesting Web Data Using Power Query & Other ToolsRob VolkBeginner
How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise EditionDon Boxley JrIntermediate
How to Make a LOT More Money as a BI ConsultantJames SerraBeginner
Improve the Performance of Your T-SQL by Changing Your HabitsMickey StueweBeginner
Inferred Dimension Members within MDS and SSIS Reza RadAdvanced
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Introduction to SQL Server 2012 MDS and DQSPeter MyersIntermediate
Introduction to SQL Server Data MiningPeter MyersIntermediate
Introduction to SSASBradley SchachtBeginner
Introduction to Tableau: SQL Server's Best FriendRussell ChristopherBeginner
Introduction to the XML sourceRuss LoskiIntermediate
Keynote and Opening RemarksDandy WeynNon-Technical
Layered Partitioning - manage very large data setsDavid Peter HansenAdvanced
Learning SSIS under 1 hourJose ChinchillaBeginner
Let's Jive with HiveAllan MitchellIntermediate
Lights, Camera, Action: Creating and Delivering Technical PresentationsJessica MossNon-Technical
Master Data Services Best PracticesSteve SimonIntermediate
Mastering the CUBE Functions in Excel 2013Peter MyersIntermediate
Maximizing SSIS Package PerformanceTim MitchellIntermediate
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
MDX Trek: First ContactMark VaillancourtIntermediate
Monitoring Server health via Reporting Services dashboardsSteve SimonIntermediate
Moving Big Data - SSIS, Pig, and SqoopJohn WelchBeginner
New Hotness: SQL Server 2012 and SharePoint 2013Bradley SchachtBeginner
O, There's My Data, OData for Data GuysSteve HughesIntermediate
PDW - Where are the landmines? Does it truly perform the way marketing says and at what cost?Andy IsleyIntermediate
Power View & Reporting Enhancements in SQL 2012Guillermo CaicedoIntermediate
Power View: A Peek Behind the CurtainStacia MisnerBeginner
Real-world Fuzzy matching with SSISJose ChinchillaBeginner
Scalable SSRS Reports Achieved Through the Powerful TablixMickey StueweIntermediate
Scripting in SSISTim MitchellIntermediate
Self-Service BI using Excel 2013Doug CoxBeginner
Semantic Model in Analysis Services 2012Thomas LeBlancIntermediate
Server Application Virtualization - Picking Up Where Server Virtualization Leaves OffDon Boxley JrNon-Technical
Sizing your DW Hardware - SMP, Fast Track or PDWAndy IsleyIntermediate
Smart Rats Leave FirstGeoff HitenBeginner
Social Marketing 2013 for Microsoft ProfessionalsMark TabladilloBeginner
SQL Impossible: Restoring/Undeleting a table Mladen PrajdicAdvanced
SQL Injection: From Website to SQL ServerMladen PrajdicIntermediate
SQL Server Data Tools, What can you do for me?Guillermo CaicedoBeginner
SQL Server Database Development with SSDT Aaron NelsonIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS 2012: More Than Just a Pretty UISteven WakeBeginner
SSIS and Azure - ETLing in the CloudMike DonnellyBeginner
SSIS CDC Tasks in SQL 2012Mike DonnellyBeginner
SSRS data driven subscription using SSISRuss LoskiAdvanced
Tableau and SQL Server: Not Quite ParadiseRussell ChristopherAdvanced
Taking BI to the Next Level: CollaborationStacia MisnerIntermediate
Taking the Scary out of Monster ReportsPam ShawBeginner
TARDDIS: Time and Reusable Date Dimensions in ScriptSteven WakeIntermediate
Temporary InsanityMichael FemenellaIntermediate
The 20-Minute Tabular ModelBill AntonBeginner
The evolution of business intelligenceArturo CardenasIntermediate
Tips & Tricks for dynamic SSRS ReportsPam ShawBeginner
Tips and Tricks for Dimensional LoadingJose L. RiveraIntermediate
To the Cloud and Beyond with MSBI Anthony SammartinoIntermediate
Top BI enhancements for SQL Server 2012James SerraBeginner
Top Query Optimizer Topics for Better PerformanceBenjamin NevarezIntermediate
Transitioning from self-service BI to corporate BIJames SerraBeginner
Transitioning to a BI roleJames SerraBeginner
Troubleshooting MDX Query PerformanceStacia MisnerAdvanced
Tuning Analysis Services Processing PerformanceJohn WelchAdvanced
Understand Evaluation Contexts in DAXJeffrey WangAdvanced
Understand/Code/Debug Many-to-Many Relationships iWayne SnyderIntermediate
Unit Testing SSIS PackagesJohn WelchIntermediate
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using PowerPivot to Drive Quality into ETL ProcessesSteve HughesIntermediate
Using SSIS 2012 for ETL in a Data WarehouseThomas LeBlancIntermediate
What exactly is Business Intelligence?James SerraBeginner
What's in the SQL Server 2012 Business Intelligence Suite?Jessica MossBeginner
When reporting is more than reportingPam ShawIntermediate


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