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 TimeDBA Admin - Room: Room UP3103DBA Admin 2 - Room: Room UP3205DBA Admin 3 - Room: Room UP3206Prof Dev/Cloud/Misc - Room: Room UP4102BI & Big Data - Room: Room UP4103BI 2 - Room: Room UP3207Powershell - Room: Room UP4105SSIS - Room: Room UP4106
07:30 AMEd Watson

Backup Strategies are for Losers!

Level: Beginner

download
Robert Biddle

Maintaining Indexes in SQL Server

Level: Beginner

download
Don Stevic

DBA 101

Level: Beginner
Andy Warren

Building Your Professional Development Plan

Level: Beginner

download
    
08:30 AMSQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
SQLSaturday 232

Registrations

Level: Non-Technical
09:00 AMChris Bell

“Indexing” Encrypted Data

Level: Intermediate

download
Jack Corbett

An Introduction to Extended Events

Level: Beginner

download
Brandie Tarvin

Troubleshooting Tips 101

Level: Beginner
Russell Fustino

Building a Windows 8 app from scratch

Level: Beginner
Luis Figueroa

Getting started with Master Data Services 2012

Level: Beginner
Kendal Van Dyke

Discover, Document, & Diagnose Your Servers on Your Coffee Break

Level: Beginner
Aaron Nelson

PowerShell for Data Professionals

Level: Intermediate
James Phillips

Creating an SSIS Framework

Level: Intermediate
10:15 AMJonathan Kehayias

Solving Complex Problems with Extended Events

Level: Intermediate

download
Carlos Chacon

Your SQL Server Environment--Fair or foul?

Level: Beginner

download
James McAuliffe

Changing Data Is Easy, Managing Data Change is Hard!

Level: Intermediate

download
Michael Antonovich

Putting Quality Back Into Your Data Analysis

Level: Intermediate

download
John Welch

Moving Big Data - SSIS, Pig, and Sqoop

Level: Beginner
Josh Luedeman

SSRS: On Premises or Azure? What's the difference?

Level: Intermediate

download
Rob Volk

Revenge: The SQL Part 2: The Sequel!

Level: Intermediate

download
Jen Underwood

Best Practice Data Visualization

Level: Intermediate
11:30 AMHope Foley

Spatial Data: Cooler Than You'd Think!

Level: Beginner

download
Dan Taylor

Will SQL Server Standard edition meet your needs?

Level: Beginner
Jeffrey Garbus

Indexing for Join Optimization

Level: Advanced
Shannon Lowder

OnPremise to Azure

Level: Intermediate

download
Anthony Sammartino

DAX for T-SQL folks

Level: Beginner
Jose L. Rivera

Predictive Analytics at your fingertips

Level: Intermediate
Max Trinidad

SSIS - Integrating PowerShell in a ScriptTask component

Level: Intermediate

download
Bradley Ball

SQL Server 2014: A First Look at What’s New!

Level: Intermediate
12:45 PMTony Tomarchio and Sandy Sandifer

High Performance SANLess Clustering (begins at 1:15)

Level: Beginner
Idera Demo

Idera Product Demos

Level: Non-Technical
SQLSaturday 232

Lunch Break

Level: Non-Technical
SQLSaturday 232

Lunch Break

Level: Non-Technical
SQLSaturday 232

Lunch Break

Level: Non-Technical
SQLSaturday 232

Lunch Break

Level: Non-Technical
SQLSaturday 232

Lunch Break

Level: Non-Technical
SQLSaturday 232

Lunch Break

Level: Non-Technical
02:00 PMRonald Dameron

Cure your sysadmin addiction

Level: Intermediate

download
John Morehouse

10 Things That Every DBA Should Know!

Level: Beginner

download
Eric Wisdahl

An Introductory Look at Execution Plans

Level: Beginner

download
Jonathon Moorman

Strategies in Data Deployment

Level: Intermediate

download
Mike Davis

Complex DAX Functions

Level: Intermediate
Kevin Grohoske

Integrating PowerPivot and SharePoint

Level: Intermediate

download
Michael Wells

DBA Task Automation: Unleash the PowerShell Hero in You!

Level: Advanced

download
Jorge Novo

SSIS Development Using .net

Level: Advanced

download
03:15 PMRichie Rump

Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Level: Intermediate

download
Mike Hillwig

What the VLF?

Level: Advanced
Dmitri Korotkevitch

From S to 3XL: Implementing Data Partitioning and Tiered Storage

Level: Advanced
Eddie Wuerch

Join Us! Getting Started as a Technical Speaker

Level: Beginner
Chris Schmidt

DQS: Business logic meets integration

Level: Beginner

download
Guillermo Caicedo

Power View & Reporting Enhancements in SQL Server

Level: Intermediate

download
Sebastian Meine

15 aspects of SQL Server indexes that you might not know

Level: Intermediate
Julie Smith

Matching with Data Quality Services

Level: Intermediate
04:30 PMTimothy McAliley

A Walk Around the SQL Server 2012 Audit Feature

Level: Intermediate

download
Jason Carter

5 TSQL Commands I've been missing

Level: Beginner

download
David Dye

Whats New in T-SQL With SQL Server 2012

Level: Beginner
Tim and Amy Ford

He Said - She Said: A Telemcommuting Love Story

Level: Beginner
Christopher Price

Into the Wild,Taming Unstructured Data

Level: Intermediate
Pam Shaw

When Reporting is More than Reporting

Level: Intermediate
Allen White

Automate Your ETL Infrastructure with SSIS and PowerShell

Level: Intermediate

download
Tim Mitchell

Maximizing SSIS Package Performance

Level: Intermediate
05:45 PMSQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

Raffle

Level: Non-Technical
SQLSaturday 232

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
“Indexing” Encrypted DataChris BellIntermediate
10 Things That Every DBA Should Know!John MorehouseBeginner
15 aspects of SQL Server indexes that you might not knowSebastian MeineIntermediate
5 Key Points for Effective T-SQL Unit TestingSebastian MeineIntermediate
5 TSQL Commands I've been missingJason CarterBeginner
A Balanced BI Approach (Self-Service & Corporate)Anthony SammartinoIntermediate
A Walk Around the SQL Server 2012 Audit FeatureTimothy McAlileyIntermediate
Advanced Tabular DevelopmentChris SchmidtAdvanced
An Introduction to Extended EventsJack CorbettBeginner
An Introductory Look at Execution PlansEric WisdahlBeginner
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Back to Basics: SSIS 2012 for BeginnersBradley SchachtBeginner
Backup Strategies are for Losers!Ed WatsonBeginner
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Best Practice Data VisualizationJen UnderwoodIntermediate
BIML--Step by StepJulie SmithIntermediate
Building a Windows 8 app from scratchRussell FustinoBeginner
Building Your Own Monitors with the SQL AgentMike HillwigIntermediate
Building Your Own SQL Server Virtual PlaygroundKendal Van DykeIntermediate
Building Your Professional Development PlanAndy WarrenBeginner
Changing Data Is Easy, Managing Data Change is Hard!James McAuliffeIntermediate
Coffee BreakSQLSatruday 232Non-Technical
Column Level EncryptionDavid DyeBeginner
Complex DAX FunctionsMike DavisIntermediate
Creating an SSIS FrameworkJames PhillipsIntermediate
Cure for the Common Code - Diagnosing Sick SQLRodney LandrumIntermediate
Cure your sysadmin addictionRonald DameronIntermediate
Data Profiling, Cleansing, Enrichment & Matching with SSISChristopher PriceBeginner
Data Quality Made SimpleEric WisdahlBeginner
Database Design Disasters: Common Mistakes Found in the WildRichie RumpIntermediate
Database Projects - An IntroductionJonathon MoormanIntermediate
DAX for T-SQL folksAnthony SammartinoBeginner
DBA 101Don StevicBeginner
DBA Task Automation: Unleash the PowerShell Hero in You!Michael WellsAdvanced
DBA's Rules for Dummies... And DevelopersMike HillwigBeginner
Deadlocking for Mere MortalsJonathan KehayiasIntermediate
Dealing With Errors in SSIS 2012David DyeAdvanced
Denali Ho! Exploring SQL ServerRob VolkIntermediate
Discover, Document, & Diagnose Your Servers on Your Coffee BreakKendal Van DykeBeginner
Distributed Replay in SQL Server 2012Jonathan KehayiasIntermediate
DQS: Business logic meets integrationChris SchmidtBeginner
Dr. StrangeTrace or: How I Learned to Stop Worrying and Love ProfilerDon StevicBeginner
Dynamic SQL - Uses and RisksRobert BiddleIntermediate
Enrich your applications with SQL Server Reporting ServicesGuillermo CaicedoIntermediate
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love DevelopersRichie RumpIntermediate
Free tools from the SQL Server CommunityEric WisdahlBeginner
From 0 to big data in 60 minutesLuis FigueroaIntermediate
From S to 3XL: Implementing Data Partitioning and Tiered StorageDmitri KorotkevitchAdvanced
Getting started with Master Data Services 2012Luis FigueroaBeginner
Harvesting Web Data Using Data Explorer and XMLRob VolkBeginner
He Said - She Said: A Telemcommuting Love StoryTim and Amy FordBeginner
High Performance SANLess Clustering (begins at 1:15)Tony Tomarchio and Sandy SandiferBeginner
How to be a GREAT DBAJeffrey GarbusBeginner
Idera Product DemosIdera DemoNon-Technical
Implementing Auditing in SQL Server 2012David DyeBeginner
Indexing for Join OptimizationJeffrey GarbusAdvanced
Indexing for performanceJeffrey GarbusIntermediate
Inroduction to TriggersJack CorbettBeginner
Integrating PowerPivot and SharePointKevin GrohoskeIntermediate
Into the Wild,Taming Unstructured DataChristopher PriceIntermediate
Introducing Cube World To Users From Flat Table LandMichael AntonovichIntermediate
Introducing DAXChris SchmidtBeginner
Introduction to SQL Server ReplicationChad ChurchwellBeginner
Introduction to SSASBradley SchachtBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Loading a Data Warehouse with SSISRobert BiddleAdvanced
Lunch BreakSQLSaturday 232Non-Technical
Maintaining Indexes in SQL ServerRobert BiddleBeginner
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Matching with Data Quality ServicesJulie SmithIntermediate
Maximizing SSIS Package PerformanceTim MitchellIntermediate
MDS in Practice: An Integrated ApproachChristopher PriceBeginner
Mistake Please DeleteRob VolkBeginner
Moving Big Data - SSIS, Pig, and SqoopJohn WelchBeginner
OnPremise to AzureShannon LowderIntermediate
Parent/Child Structures in SSISTim MitchellIntermediate
PCI For The SQLDBAAndy WarrenBeginner
Periodic Table of DMVs: Part Two - The SQLTim FordAdvanced
Power View & Reporting Enhancements in SQL Server Guillermo CaicedoIntermediate
PowerPivot+Powerview=Self-service BI RevolutionJose ChinchillaBeginner
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Predictive Analytics at your fingertipsJose L. RiveraIntermediate
Putting Quality Back Into Your Data AnalysisMichael AntonovichIntermediate
RaffleSQLSaturday 232Non-Technical
Recovery and Backup for BeginnersMike HillwigBeginner
RegistrationsSQLSaturday 232Non-Technical
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Social Networking Is Alive!John MorehouseNon-Technical
Solving Complex Problems with Extended EventsJonathan KehayiasIntermediate
Spatial Data: Cooler Than You'd Think!Hope FoleyBeginner
SQL Automation Using SSISJorge NovoIntermediate
SQL Database Basics for the DeveloperBrandie TarvinBeginner
SQL Server 2012 AlwaysOn for HA and DRChad ChurchwellIntermediate
SQL Server 2014: A First Look at What’s New!Bradley BallIntermediate
SQL Server Data Tools, What can you do for me?Guillermo CaicedoBeginner
SQL Server Database Development with SSDT Aaron NelsonIntermediate
SQL Server Databaseology 201John MorehouseIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS - Integrating PowerShell in a ScriptTask componentMax TrinidadIntermediate
SSIS 2008R2 configurationsChris SchmidtIntermediate
SSIS 2012 Reporting: Now what?Chris SchmidtIntermediate
SSIS Development Using .netJorge NovoAdvanced
SSIS Incremental Load Design PatternsTim MitchellIntermediate
SSIS Programming using .NetJorge NovoAdvanced
SSRS: On Premises or Azure? What's the difference?Josh LuedemanIntermediate
Strategies in Data DeploymentJonathon MoormanIntermediate
Successfully Virtualizing SQL Server in ProductionJonathan KehayiasIntermediate
Taking the Scary out of Monster ReportsPam ShawBeginner
The T-SQL Features in SQL Server 2012 You Can't IgnoreRichie RumpIntermediate
Tips & Tricks for dynamic SSRS ReportsPam ShawBeginner
Trace is Dead! (...and Better Than Ever!)Eddie WuerchIntermediate
Troubleshooting & Optimizing Performance! NOW!Bradley BallIntermediate
Troubleshooting Tips 101Brandie TarvinBeginner
Tuning Analysis Services Processing PerformanceJohn WelchAdvanced
Unit Testing SSIS PackagesJohn WelchIntermediate
Viagra for your SSIS package: Tips for performanceJose ChinchillaIntermediate
Visualizing Data with Reporting ServicesChristopher PriceBeginner
What the VLF? Mike HillwigAdvanced
Whats New in T-SQL With SQL Server 2012David DyeBeginner
When Reporting is More than ReportingPam ShawIntermediate
Will SQL Server Standard edition meet your needs?Dan TaylorBeginner
Your SQL Server Environment--Fair or foul?Carlos ChaconBeginner


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