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 TimeRoom 1 - Room: Charlemount Suite 4Room 2 - Room: Charlemount Suite 3Room 3 - Room: Charlemount Suite 2Room 4 - Room: TBA
8:00 AMCommittee Members

REGISTRATION

Level: Beginner
Committee Members

REGISTRATION

Level: Beginner
Committee Members

REGISTRATION

Level: Beginner
Committee Members

REGISTRATION

Level: Beginner
9:15 AMCommittee Members

Guest Speaker Welcome & Overview

Level: Beginner
Committee Members

Guest Speaker Welcome & Overview

Level: Beginner
Committee Members

Guest Speaker Welcome & Overview

Level: Beginner
Committee Members

Guest Speaker Welcome & Overview

Level: Beginner
9:30 AMJames Baldwin

Storage Best Practices & Performance optimization

Level: Intermediate
Allan Mitchell

Making Data Fit for Business using DQS

Level: Intermediate
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Rushabh Mehta

SSIS 2012 Management Considerations and Best Pract

Level: Intermediate

download
10:40 AMNeil Hambly

Effective Data Management using Data Compression

Level: Beginner
Jen Stirrup

SQL Server 2012: Business Intelligence & Data Viz

Level: Intermediate
Bob Beauchemin

Searching over data and files with SQL Server 2012

Level: Advanced

download
Matt Masson

SSIS in SQL Server 2012: Development Enhancements

Level: Intermediate
11:40 AMCommittee Members

COFFEE BREAK AM

Level: Beginner
Committee Members

COFFEE BREAK AM

Level: Beginner
Committee Members

COFFEE BREAK AM

Level: Beginner
Committee Members

COFFEE BREAK AM

Level: Beginner
12:00 PMAndre Kamman

Build a monitoring system with Powershell Remoting

Level: Intermediate
Pete Harris

Get the right SQL Certifications for your business

Level: Beginner
Christopher Webb

Intro to Tabular Model in Analysis Services 2012

Level: Advanced
Klaus Aschenbrenner

Advanced SQL Server 2008 Troubleshooting

Level: Advanced
1:00 PMCommittee Members

LUNCH BREAK

Level: Beginner
Committee Members

LUNCH BREAK

Level: Beginner
Committee Members

LUNCH BREAK

Level: Beginner
Committee Members

LUNCH BREAK

Level: Beginner
1:45 PMCommittee Members

LUNCH BREAK

Level: Beginner
Bob Duffy

SQL 2012 Always On-Deep Dive

Level: Advanced
Noemi Moreno & Tom Austin

Social Media, BI, & Bridging the SSMS-VS Divide

Level: Beginner
Ronan Geraghty

Drive Greater Application ROI

Level: Beginner
2:45 PMChristina Leo

SQL Server Internals: It's What's for Dinner!

Level: Beginner
Chris Testa-O'Neill

Notes on SQL 2012 Highly Available BI Environments

Level: Intermediate
Aaron Bertrand

T-SQL : Bad Habits to Kick

Level: Beginner

download
Various Speakers

Lightning Talks

Level: Beginner
3:45 PMCommittee Members

COFFEE PM

Level: Beginner
Committee Members

COFFEE PM

Level: Beginner
Committee Members

COFFEE PM

Level: Beginner
Committee Members

COFFEE PM

Level: Beginner
4:00 PMMark Broadbent

Moves like Jagger-Upgrading to SQL Server 2012

Level: Advanced
Mark Stacey

Analysis Services for the DBA

Level: Beginner
Kevin Kline

Top Ten Things Every Developer Should Know

Level: Intermediate
William E Pearson III

Getting Started with MDX: The (Very) Basics

Level: Beginner
5:30 PMCommittee Members

AFTER PARTY

Level: Beginner
Committee Members

AFTER PARTY

Level: Beginner
Committee Members

AFTER PARTY

Level: Beginner
Committee Members

AFTER PARTY

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
2 AM. A Disaster just began...Tobiasz KoprowskiIntermediate
2012 TSQL SweetsBill FellowsIntermediate
A better SSIS? - Migrating a datawarehouse to 2012Andre KammanIntermediate
A temporary fix for a short term problemIan MeadeIntermediate
Advanced SQL Azure - Performance, ScalabilityNuno GodinhoAdvanced
Advanced SQL Server 2008 TroubleshootingKlaus AschenbrennerAdvanced
AFTER PARTYCommittee MembersBeginner
AfterpartySandra GunnBeginner
All about Execution Plans OperatorsFabiano Neves AmorimAdvanced
An Overview of PowerPivot William E Pearson IIIBeginner
Analysis Services & the Management Data WarehousMark StaceyIntermediate
Analysis Services for the DBAMark StaceyBeginner
Architecting a BI solution - not just hardwareMark StaceyIntermediate
Attribute Discretization in Analysis Services (BI)William E Pearson IIIBeginner
Becoming DAX: An Introduction ... William E Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E Pearson IIIIntermediate
BI for the DBA - DeepDiveMark StaceyAdvanced
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIBeginner
Build a monitoring system with Powershell RemotingAndre KammanIntermediate
Business Intelligence in Azure: SSIS & SSRS focusJen StirrupIntermediate
Coffee BreakSandra GunnBeginner
Coffee Break 2Sandra GunnBeginner
COFFEE BREAK AMCommittee MembersBeginner
COFFEE PMCommittee MembersBeginner
Database Design Contentious IssuesKaren LopezIntermediate
DBA CheckList, what/how should I look at?Fabiano Neves AmorimAdvanced
Demystifying SQL AzureVikas SahniBeginner
Design and Implement BI Like Edison! William E Pearson IIIBeginner
Designing and managing VLDBs on SQL ServerKlaus AschenbrennerIntermediate
Distribued Replay with SQL Server 2012Klaus AschenbrennerIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E Pearson IIIIntermediate
Drive Greater Application ROIRonan GeraghtyBeginner
Dynamic code for efficient searchingIan MeadeIntermediate
Dynamic code for efficient searchingIan MeadeIntermediate
Effective Data Management using Data CompressionNeil HamblyBeginner
Embedding Security into your SQL SolutionsNiall FlanaganIntermediate
Embedding Security into your SQL SolutionsNiall FlanaganIntermediate
Enter the Dragon: SQL 2012 on Server CoreMark BroadbentAdvanced
Exploring SQL Server Internals through WinDbgKlaus AschenbrennerAdvanced
Extended Events – New Age of ProfilingNeil HamblyIntermediate
Get the right SQL Certifications for your businessPete HarrisBeginner
Getting Dimensional with DataChris Testa-O'NeillIntermediate
Getting Started with MDX: The (Very) BasicsWilliam E Pearson IIIBeginner
Guest Speaker Welcome & OverviewCommittee MembersBeginner
High Availability of SQL in the context of SLATobiasz KoprowskiIntermediate
Identifying and Solving Sort Warning ProblemsMilos RadivojevicIntermediate
Illuminating SQL Server StatisticsFabiano Neves AmorimAdvanced
Intro to Tabular Model in Analysis Services 2012Christopher WebbAdvanced
Introduction to DAX Queries and CalculationsChristopher WebbAdvanced
Kama Sutra of SSIS: A guide to loving ETLBill FellowsBeginner
Lego Sets: Relational Building BlocksRob VolkBeginner
Lightning TalksVarious SpeakersBeginner
Loading Data Warehouse Dimensions in SSISAlex WhittlesAdvanced
Locked? Not on a school night please!Ian MeadeBeginner
Locked? Not on a school night please!Ian MeadeBeginner
LunchSandra GunnBeginner
LUNCH BREAKCommittee MembersBeginner
Making Data Fit for Business using DQSAllan MitchellIntermediate
Making the most of SQL2012 and Sharepoint 2010 Ronen CHennIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E Pearson IIIAdvanced
Messages from Mercury - MESSENGERdata in PowerViewMark StaceyIntermediate
Moves like Jagger-Upgrading to SQL Server 2012Mark BroadbentAdvanced
Notes on SQL 2012 Highly Available BI EnvironmentsChris Testa-O'NeillIntermediate
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIBeginner
Parameter Sniffing Problem with Stored ProceduresMilos RadivojevicIntermediate
Plan Caching in SQL ServerKlaus AschenbrennerIntermediate
Power View from the Data Visualisation PerspectiveJen StirrupBeginner
PowerPivot for Excel: For Those Unacquainted ...William E Pearson IIIBeginner
PowerPivot Vs QlikView 101Alex WhittlesIntermediate
PowerPivot with NASA dataMark StaceyIntermediate
READPAST & Furious 2 "Denali Drift"Mark BroadbentIntermediate
REGISTRATIONCommittee MembersBeginner
RegistrationSandra GunnBeginner
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Scaleout scenarios with Service BrokerKlaus AschenbrennerAdvanced
Searching over data and files with SQL Server 2012Bob BeaucheminAdvanced
Serene Velocity: Reporting Services and SSAS Data William E Pearson IIIIntermediate
Service Broker: Message in a bottleKlaus AschenbrennerAdvanced
Slowly changing dimensions- an integrated approachMark StaceyIntermediate
Social Media, BI, & Bridging the SSMS-VS Divide Noemi Moreno & Tom AustinBeginner
Solving Business Problems with StreamInsightAllan MitchellAdvanced
SQL 2012 Always On Deep DiveBob DuffyIntermediate
SQL 2012 Always On-Deep DiveBob DuffyAdvanced
SQL IO for beginners (and all non-gamers)Mark StaceyBeginner
SQL Server 2008 Database InternalsKlaus AschenbrennerAdvanced
SQL Server 2012: Business Intelligence & Data VizJen StirrupIntermediate
SQL Server Edition & LicensingNiall FlanaganIntermediate
SQL Server Internals: It's What's for Dinner!Christina LeoBeginner
SQL Server Memory ManagementKlaus AschenbrennerAdvanced
SQL Server Query TuningKlaus AschenbrennerAdvanced
SQL Server Troubleshooting with Extended EventsKlaus AschenbrennerIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSDT is here, so what's up ?Niko NeugebauerBeginner
SSIS 2012 Management Considerations and Best PractRushabh MehtaIntermediate
SSIS in SQL Server 2012: Development EnhancementsMatt MassonIntermediate
Storage Best Practices & Performance optimizationJames BaldwinIntermediate
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
The joy of SSIS packages development (C# Remix)Niko NeugebauerIntermediate
Tips & Tricks to choose your Storage StrategyNuno GodinhoAdvanced
Top Ten Things Every Developer Should KnowKevin KlineIntermediate
Troubleshooting TempDbKlaus AschenbrennerAdvanced
T-SQL : Bad Habits to KickAaron BertrandBeginner
TSQL Performance TipsMilos RadivojevicIntermediate
Understanding Microsoft Certification in SQL ServeChris Testa-O'NeillBeginner
Understanding SQL Server Execution PlansKlaus AschenbrennerAdvanced
UNIQUEIDENTIFIERS as Clustered Keys in SQL ServerKlaus AschenbrennerIntermediate
Using SQL Azure Database FederationsBob BeaucheminIntermediate
Virtual SQL Server - Physical headache...Stephen ArchboldIntermediate
We have control! Resource Control in SQL ServerChris Testa-O'NeillIntermediate
Welcome to the Licensing NightmareTobiasz KoprowskiIntermediate
What's Buried in the Plan Cache?Christina LeoIntermediate
What's new in SQL Server 2012?Aaron BertrandBeginner
Why are we Waiting..Neil HamblyAdvanced
Working with Server Side TracesChristina LeoIntermediate
Writing better code with windowing functionsFabiano Neves AmorimAdvanced
Your database is safeNiko NeugebauerIntermediate


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
The Entiry Framework 4.0 and 4.5 Deep DiveAdvanced
Virtual SQL Server - Physical headache...Intermediate
Virtual SQL Server - Physical headache...Intermediate

SQLSaturday Home
PASS