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 TimeAll Attendees - Room: CafeRoom 116 - Room: Room 116Room 117 - Room: Room 117Room 118 - Room: Room 118Room 214 - Room: Room 214Room 215 - Room: Room 215Room 216 - Room: Room 216Room 217 - Room: Room 217Room 218 - Room: Room 218
7:45 AMSQLSatruday 291

Registration and Check In

Level: Non-Technical
        
08:30 AMRoss LoForte

Keynote

Level: Beginner
        
09:15 AM Brent Ozar

How to Think Like the Engine

Level: Intermediate

download
Luke Jian

How to baseline performance for SQL Server

Level: Intermediate

download
Dave Mattingly

Achievement Unlocked: How to Get Promoted

Level: Beginner
Colleen Morrow

SQL Audit - auditing doesn't have to be boring

Level: Intermediate
Laerte Junior

How to properly gather performance counter data using Windows PowerShell

Level: Beginner
Allan Hirt

Business Continuity: The Real Reason for HA and DR

Level: Beginner
Mark Vaillancourt

MDX Trek: First Contact

Level: Intermediate
David Ortiz

Self Service Pitfalls

Level: Beginner
10:30 AM David Klee

SQL Server Virtualization 101

Level: Beginner
Ed Leighton-Dick

SQL Server Features That Will Blow Your Mind!

Level: Beginner
Mike Donnelly

Forward the Federations

Level: Intermediate

download
Warner Chaves

Best Practices for your Very Large Databases

Level: Intermediate
Michael Schulte

Extending SQL Server with Advanced Analytics and R

Level: Beginner
Ted Krueger

SSIS: The DBA Multiplier

Level: Beginner
Stacia Misner

Introducing Power BI

Level: Beginner
Bill Lescher

Fast and Flexible Applications with Better Database Design

Level: Beginner

download
11:30 AMSQLSatruday 291

Morning Break

Level: Non-Technical
        
12:00 PM Adam Machanic

Query Tuning Mastery: Clash of the Row Goals

Level: Advanced
Joseph D'Antoni

The Modern Analytics Architecture

Level: Intermediate
Frank Gill

Designing a Restore Strategy

Level: Intermediate
Hope Foley

Spatial Data: Cooler Than You'd Think!

Level: Beginner
Jim Dorame

PowerShell and SQLPSX the Dynamic Duo for the DBA

Level: Intermediate
Allan Hirt

Hybrid Solutions: The Future of SQL Server Disaster Recovery

Level: Intermediate
Jason Strate

5 Ways to Improve Performance through Indexing

Level: Intermediate
Jeff Prom

Master Data Services

Level: Beginner

download
01:15 PM Brian Walters

Take SQL Server performance to the next level with SQL 2014 in-memory OLTP

Level: Intermediate
Carl Berglund

When Cluster and Virtualization Aren't Enough: How to Create an Application Availability Framework

Level: Beginner
Carlos Parra

Advanced Performance Tuning Tips with Database Performance Analyzer

Level: Beginner
Wendy Pastrick

Women In Technology Panel

Level: Beginner
Grant Fritchey

Best Practices for Database Deployment

Level: Intermediate
Dave Swanson

Using Dell tools to improve visibility, efficiency and overall performance

Level: Beginner
Eric Sink

Replicate and sync SQL Server data on mobile devices

Level: Beginner
Melissa Meyer

PowerPivot and Excel Reporting

Level: Beginner
02:15 PMSQLSatruday 291

Afternoon Break

Level: Non-Technical
        
02:45 PM Mark Vaillancourt

DANGER: The Art and Science of Presenting

Level: Beginner
Scott Shaw

Pig\Hive - All That's New is Old Again

Level: Intermediate
Jason Strate

Managing SQL Server Performance with Extended Events

Level: Intermediate
Bill Fellows

2012 TSQL Sweets

Level: Intermediate
Tim Ford

Query Tuning Superstardom for Beginners

Level: Beginner
David Klee

Squeezing Top Performance from Your Virtualized SQL Server

Level: Intermediate
Joseph D'Antoni

In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Level: Intermediate
Ken Stuber

Database Development using SQL Server Data Tools

Level: Beginner
04:00 PM Brian Beswick

Database Unit Testing

Level: Beginner
Haidong Ji

Introduction to Big Data

Level: Beginner
Andy Yun

Every Byte Counts: Why Your Datatype Choices Matter

Level: Intermediate
David Maxwell

DBA 911 - Database Corruption

Level: Beginner
Eric Boyd

Working with Data in Windows Azure

Level: Beginner
Brent Ozar

Real-Life SQL 2012 and 2014 Availability Group Deployments

Level: Intermediate

download
Merrill Aldrich

Eureka! Visual deep dive into storage internals

Level: Intermediate
Meagan Longoria

Choose Your Geospatial Mapping Adventure

Level: Intermediate
05:00 PMSQLSatruday 291

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
2012 TSQL SweetsBill FellowsIntermediate
5 Ways to Improve Performance through IndexingJason StrateIntermediate
Achievement Unlocked: How to Get PromotedDave MattinglyBeginner
Advanced Performance Tuning Tips with Database Performance AnalyzerCarlos ParraBeginner
Agile Data Warehouse - The final frontier Terry BunioIntermediate
Best Practices for Database DeploymentGrant FritcheyIntermediate
Best Practices for your Very Large DatabasesWarner ChavesIntermediate
Business Continuity: The Real Reason for HA and DRAllan HirtBeginner
Choose Your Geospatial Mapping AdventureMeagan LongoriaIntermediate
Common T-SQL Patterns Affecting SQL Server PerformanceJason StrateIntermediate
DANGER: The Art and Science of PresentingMark VaillancourtBeginner
Database Development using SQL Server Data ToolsKen StuberBeginner
Database Unit TestingBrian BeswickBeginner
DBA 911 - Database CorruptionDavid MaxwellBeginner
Designing a Restore StrategyFrank GillIntermediate
Dimensional Data Modeling PrimerTerry BunioBeginner
Don’t Miss Out on Excel Cube FunctionsMeagan LongoriaBeginner
Don't be afraid of the big bad WASDMike DonnellyBeginner
Establishing SQL and BI Business ValueMatthew BowersNon-Technical
Eureka! Visual deep dive into storage internalsMerrill AldrichIntermediate
Every Byte Counts: Why Your Datatype Choices MatterAndy YunIntermediate
Extending SQL Server with Advanced Analytics and RMichael SchulteBeginner
Fast and Flexible Applications with Better Database DesignBill LescherBeginner
Forward the FederationsMike DonnellyIntermediate
Go from physical to virtual in one hourLuke JianBeginner
Hadoop DistilledScott ShawIntermediate
Has Big Data Killed the EDW?Stacia MisnerBeginner
How do I create an automated ETL test suite ??Terry BunioIntermediate
How to Argue with Your Infrastructure Admins – and WinDavid KleeIntermediate
How to baseline performance for SQL Server Luke JianIntermediate
How to properly gather performance counter data using Windows PowerShellLaerte JuniorBeginner
How to Think Like the EngineBrent OzarIntermediate
How to Tune QueriesBrent OzarIntermediate
Hybrid Solutions: The Future of SQL Server Disaster RecoveryAllan HirtIntermediate
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Joseph D'AntoniIntermediate
Intro to Windows Azure SQL Database and What's NewEric BoydBeginner
Introducing Power BIStacia MisnerBeginner
Introduction to Big DataHaidong JiBeginner
KeynoteMicrosoft MicrosoftBeginner
KeynoteRoss LoForteBeginner
Managing SQL Server Performance with Extended EventsJason StrateIntermediate
Master Data ServicesJeff PromBeginner
MDX Trek: First ContactMark VaillancourtIntermediate
Merge Replication for Offline Data MobilityTed KruegerIntermediate
Monitoring and collecting metrics data for DBAsHaidong JiBeginner
Patch Management Strategies for SQL ServerAllan HirtIntermediate
Performance-Tuning for Extract/Transform/Load (ETL) OperationsKen StuberIntermediate
Pig\Hive - All That's New is Old AgainScott ShawIntermediate
PowerMap: Maps, BI, and now Movies!Jeff PromBeginner
PowerPivot and Excel ReportingMelissa MeyerBeginner
PowerShell 101Merrill AldrichBeginner
PowerShell and SQLPSX the Dynamic Duo for the DBAJim DorameIntermediate
Query Tuning for DevelopersTed KruegerBeginner
Query Tuning Mastery: Clash of the Row GoalsAdam MachanicAdvanced
Query Tuning Superstardom for BeginnersTim FordBeginner
Real-Life SQL 2012 and 2014 Availability Group DeploymentsBrent OzarIntermediate
Recognizing the Parallel Data Warehouse (PDW) WorkloadJason StrateIntermediate
Reduce, Reuse, Recycle: Automating Your BI FrameworkStacia MisnerIntermediate
Replicate and sync SQL Server data on mobile devicesEric SinkBeginner
Right Data, Right NowDave MattinglyBeginner
Self Service Pitfalls David OrtizBeginner
Shoveling Frogs into a WheelbarrowMerrill AldrichIntermediate
Spatial Data: Cooler Than You'd Think!Hope FoleyBeginner
SQL and BI Cost Benefits AnalysisMatthew BowersNon-Technical
SQL Audit - auditing doesn't have to be boringColleen MorrowIntermediate
SQL Server Agent - The DBA's Best FriendDavid MaxwellBeginner
SQL Server Dos and Don'ts: Keys to DBA NirvanaAllan HirtBeginner
SQL Server Features That Will Blow Your Mind!Ed Leighton-DickBeginner
SQL Server in Windows Azure Virtual MachinesEric BoydBeginner
SQL Server Virtualization 101David KleeBeginner
SQL Server--All About HA and DRJoseph D'AntoniIntermediate
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeIntermediate
SSIS development is done: now what? Deployment, migration, maintenance and troubleshootingBill FellowsIntermediate
SSIS Package On Demand - Running an SSIS Package from Reporting ServicesSteve ScheidlerIntermediate
SSIS: The DBA Multiplier Ted KruegerBeginner
Statistics and Query OptimizationGrant FritcheyIntermediate
Strategies for SQL Server Index AnalysisJason StrateIntermediate
Tableau Integration with "R"Chad DotzenrodBeginner
Take SQL Server performance to the next level with SQL 2014 in-memory OLTPBrian WaltersIntermediate
The Accidental Report Designer: Data Visualization Best Practices in SSRSMeagan LongoriaIntermediate
The Modern Analytics ArchitectureJoseph D'AntoniIntermediate
The Super Trace: Introduction to Extended Events Warner ChavesIntermediate
The Use Cases for In-Memory OLTPWarner ChavesIntermediate
There's a Report in My SharePoint!Gina MeronekBeginner
Type More, Click Less: Programmatically build SSIS packagesBill FellowsAdvanced
Upgrading and Migrating SQL Server with limited downtime Ted KruegerIntermediate
Using Dell tools to improve visibility, efficiency and overall performanceDave SwansonBeginner
Using Tabular and Power View to Analyse Perfmon DataScott ShawIntermediate
When Cluster and Virtualization Aren't Enough: How to Create an Application Availability FrameworkCarl BerglundBeginner
When Scripting Worlds Collide: PHP + SQL ServerJeff PromIntermediate
Women In Technology PanelWendy PastrickBeginner
Working with Data in Windows AzureEric BoydBeginner


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