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 TimeApp Dev - Room: IRN 128App Dev / DBA - Room: IRN 129BI Architecture - Room: IRN 120BI Architecture - Room: IRN 106BI Delivery - Room: IRN 131BI Delivery - Room: IRN 219DBA - Room: IRN 126Microsoft - Room: SC 140-144Professional Development / Azure - Room: IRN 125SSIS - Room: IRN 123
08:30 AMRobert Miller

Using Change Tracking and Change Data Capture

Level: Intermediate
Randy Knight

Understanding SQL Server XML Features

Level: Intermediate

download
Carlos Bossy

Fast-track to BI Analytics with SQL Server 2012

Level: Beginner

download
Jason Volpe

How To Create A BI Semantic Model

Level: Intermediate

download
Stacia Misner

(Way Too Much) Fun with Reporting Services

Level: Beginner
Andrew Thornton-Smith

SQL Considerations for SharePoint 2010 Farms

Level: Beginner

download
Samuel greene

Automation and Monitoring for the DBA

Level: Beginner
Lou Carbone

Migrating Oracle to SQL Server

Level: Intermediate
Wil Sisney

6 Steps to a Stellar Performance Review

Level: Beginner

download
Brad Baker

What's New in SQL Server 2012 SSIS Development

Level: Beginner

download
09:45 AMJeff Jones

Transact-SQL does Windows

Level: Intermediate

download
Denise McInerney

“BEGIN…COMMIT” is Not Enough

Level: Beginner

download
William E. Pearson III

Beyond Plateaux: Optimize SSAS with Best Practices

Level: Intermediate
Josh Sivey

SSAS - Usage Based Optimization

Level: Intermediate

download
Erika Bakse

Dynamic MDX: Packing a Punch into One .rdl

Level: Intermediate
Tom Marek

"Ad Hoc Analytics – Can my customer do that?”

Level: Beginner

download
Douglas Brendle

What is this cache and how did it get so big?

Level: Intermediate

download
Gus Apostol

SQL Server 2012 Memory Manager Changes

Level: Advanced

download
Kathrine Lord

Agile modeling and reporting with BISM and Azure

Level: Intermediate

download
Jeff Renz

Advanced SQL Server Integration Services

Level: Advanced
11:00 AMSteve Jones

Encryption in SQL Server

Level: Beginner

download
Randy Knight

Become Bilingual! Oracle for the SQL Server DBA

Level: Intermediate

download
Jeff Renz

The 2012 Data Warehouse Architecture Debate

Level: Beginner
Matt Smith

What's this columnstore index thing all about?

Level: Intermediate

download
Angel Abundez

Mobile BI with SSRS and SharePoint

Level: Intermediate

download
Stacia Misner

Data Visualization in Reporting Services

Level: Beginner

download
Meredith Ryan

Backup Basics - Know your options

Level: Beginner

download
Jason Volpe

The Ins and Outs of PowerView

Level: Intermediate

download
David Ikeda

Training & Certifications for SQL Server 2012

Level: Beginner
Wil Sisney

5 SSIS Tricks to Take You from Beginner to Awesome

Level: Beginner

download
12:30 PM       Amy Lewis

Women in Technology Panel

Level: Beginner
  
01:30 PMMark Bosley

Stupid SQL and the Programmers that Write it

Level: Intermediate

download
Tom Kallal

T-SQL Utilities for Serious DBAs

Level: Intermediate

download
Martin Schoombee

DW Architecture: More than just Facts & Dimensions

Level: Intermediate

download
William E. Pearson III

Many-to-Many: Multiple Calendars in a Single Cube

Level: Advanced
Erika Bakse

Think Outside the Group! Take MDX to the next leve

Level: Intermediate
Jacob Wilson

SSRS 2012 and SharePoint 2010 Integration

Level: Advanced

download
Kathy Gibbs

Best Practices for Monitoring Databases on VMware

Level: Intermediate

download
David Ikeda

Introduction to SQL Server 2012 AlwaysON

Level: Intermediate
 Rushabh Metha

SSIS 2012 Mgmt Considerations & Best Practices

Level: Intermediate

download
02:45 PMRandy Knight

But it worked great in Dev! Perfomance for Devs

Level: Beginner

download
Meredith Ryan

Replication Basics

Level: Beginner

download
Carlos Bossy

Real-time Data Warehouse and Reporting

Level: Intermediate

download
Tom Marek

BISM Partitions, Security and Hierarchies

Level: Intermediate

download
Jeff Renz

The Best Dashboard on the Block

Level: Beginner
Stacia Misner

Power View: A Peek Behind the Curtain

Level: Beginner

download
Ryan McCauley

Lightning Talks with Ryan McCauley/Matt Smith

Level: Intermediate

download
Gus Apostol

Troubleshooting SQL Server Performance

Level: Intermediate

download
Steve Jones

Branding Yourself for a Dream Job

Level: Beginner

download
Amy Lewis

Data Cleansing Using the "Scrubbing Bubbles" of SS

Level: Intermediate
4:00 PMRobert Miller

Using TVPs in .Net applications

Level: Advanced
 Josh Sivey

SSAS/MDX - Performing "point in time" analysis

Level: Intermediate

download
Martin Schoombee

Temporal Fact Tables: The Road Less Traveled

Level: Advanced

download
  Colin Smith

Powershell for the DBA

Level: Beginner

download
Jason Volpe

What Does SQL 2012 Mean For SharePoint

Level: Intermediate

download
William E. Pearson III

Documenting Your Integrated Microsoft BI Solution

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
"Ad Hoc Analytics – Can my customer do that?”Tom MarekBeginner
(Way Too Much) Fun with Reporting Services Stacia MisnerBeginner
“BEGIN…COMMIT” is Not EnoughDenise McInerneyBeginner
5 SSIS Tricks to Take You from Beginner to AwesomeWil SisneyBeginner
6 Steps to a Stellar Performance ReviewWil SisneyBeginner
Advanced SQL Server Integration ServicesJeff RenzAdvanced
Agile modeling and reporting with BISM and AzureKathrine LordIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Automating SQL Server source controlRyan McCauleyLightning Talk
Automation and Monitoring for the DBASamuel greeneBeginner
Backup Basics - Know your optionsMeredith RyanBeginner
Become Bilingual! Oracle for the SQL Server DBARandy KnightIntermediate
Becoming DAX: An Introduction ...William E. Pearson IIIIntermediate
Best Practices for Monitoring Databases on VMwareKathy GibbsIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
BISM Partitions, Security and HierarchiesTom MarekIntermediate
Branding Yourself for a Dream JobSteve JonesBeginner
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIIntermediate
Business Solutions Provided By SQL Server 2012Tom MarekBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Data Cleansing Using the "Scrubbing Bubbles" of SSAmy LewisIntermediate
Data Visualization in Reporting ServicesStacia MisnerBeginner
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
DW Architecture: More than just Facts & DimensionsMartin SchoombeeIntermediate
Dynamic MDX: Packing a Punch into One .rdlErika BakseIntermediate
Encryption in SQL ServerSteve JonesBeginner
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Fast-track to BI Analytics with SQL Server 2012Carlos BossyBeginner
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
How To Create A BI Semantic ModelJason VolpeIntermediate
Introduction to SQL Server 2012 AlwaysONDavid IkedaIntermediate
Introduction to SSIS 2012Jeff RenzBeginner
Lightning Talks with Ryan McCauley/Matt SmithRyan McCauleyIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Migrating Oracle to SQL ServerLou CarboneIntermediate
Mobile BI with SSRS and SharePointAngel AbundezIntermediate
Monitoring Your SQL Instances with ZabbixSamuel GreeneIntermediate
Node.js and SQL Server DevelopmentMichael CollinsIntermediate
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIIntermediate
Power View: A Peek Behind the CurtainStacia MisnerBeginner
PowerPivot for Excel: For Those Unacquainted ...William E. Pearson IIIIntermediate
Powershell for the DBAColin SmithBeginner
Preparing Data for Analysis as Tabular ModelsCarlos BossyBeginner
Prototype with PowerPivot: External SSAS GroupsWilliam E. Pearson IIIIntermediate
Real-time Data Warehouse and ReportingCarlos BossyIntermediate
Reciprocal Symmetry: MDX in PowerPivotWilliam E. Pearson IIIIntermediate
Replication BasicsMeredith RyanBeginner
Representing SQL Server data spaces visuallyRyan McCauleyLightning Talk
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
SQL Azure Scalability with FederationsScott KleinIntermediate
SQL Azure vs. Azure Tables –Clearing The ConfusionScott KleinIntermediate
SQL Considerations for SharePoint 2010 FarmsAndrew Thornton-SmithBeginner
SQL Server 2012 Memory Manager ChangesGus ApostolAdvanced
SSAS - Usage Based OptimizationJosh SiveyIntermediate
SSAS - Usage Based OptimizationJosh SiveyIntermediate
SSAS/MDX - Performing "point in time" analysisJosh SiveyIntermediate
SSIS 2012 Mgmt Considerations & Best PracticesRushabh MethaIntermediate
SSRS 2012 and SharePoint 2010 IntegrationJacob WilsonAdvanced
SSRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSRSaaS? Maybe not, but you might be surprised.Matt SmithLightning Talk
Stupid SQL and the Programmers that Write itMark BosleyIntermediate
Temporal Fact Tables: The Road Less TraveledMartin SchoombeeAdvanced
The 2012 Data Warehouse Architecture DebateJeff RenzBeginner
The basics of maintenance plansJosh SiveyBeginner
The Best Dashboard on the BlockJeff RenzBeginner
The Ins and Outs of PowerViewJason VolpeIntermediate
Think Outside the Group! Take MDX to the next leveErika BakseIntermediate
Training & Certifications for SQL Server 2012 David IkedaBeginner
Transact-SQL does WindowsJeff JonesIntermediate
Troubleshooting SQL Server PerformanceGus ApostolIntermediate
T-SQL Utilities for Serious DBAsTom KallalIntermediate
Understanding SQL Server XML Features Randy KnightIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Unstructured Data in SQL ServerSteve JonesBeginner
Using Change Tracking and Change Data CaptureRobert MillerIntermediate
Using Columnstore Indexes in SQL Server 2012Carlos BossyBeginner
Using EF Code First to Build SQL ApplicationsMichael CollinsIntermediate
Using TVPs in .Net applicationsRobert MillerAdvanced
What Does SQL 2012 Mean For SharePointJason VolpeIntermediate
What is this cache and how did it get so big?Douglas BrendleIntermediate
What's New in SQL Server 2012 SSIS DevelopmentBrad BakerBeginner
What's this columnstore index thing all about?Matt SmithIntermediate
Women in Technology PanelAmy LewisBeginner


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