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 TimeAsk The Experts! - Room: 20501 BI Roadshow - Room: 21602 BI HorsePower - Room: 21803 Admin Highway - Room: 20604 Code Paths - Room: 20405 Availability Horsepower - Room: 22006 Pro Racing - Room: 10707 High Performance - Room: 21208 BI Traffic Analysis - Room: 11209 Spaghetti Junction - Room: 21310 DBA Radar Detectors - Room: 21011 Express Toll Lane ETL - Room: 211
07:30 AMSQLSaturday 285

Registrations

Level: Non-Technical
           
08:15 AMMultiple Experts

Ask The Experts!

Level: Beginner
Julie Smith

BIML--Step by Step

Level: Intermediate
Bill Anton

The 20-Minute Tabular Model

Level: Beginner

download
Jason Carter

Maintenance and Backups: Intro to Ola Hallengren

Level: Beginner

download
Sergey Barskiy

Using SSDT (SQL Server Data Tools) to Manage Database Lifecycle

Level: Intermediate

download
Ryan Adams

SQL 2012 AlwaysOn Quickstart

Level: Beginner

download
Michael French

Independent Contracting 101

Level: Beginner
Carlos Chacon

Judge, Jury, and Executioner--A First Look At Execution Plans

Level: Beginner
Teo Lachev

Predictive Analytics for the Data Scientist and BI Pro

Level: Intermediate

download
Argenis Fernandez

Troubleshooting SQL Server with SysInternals Tools

Level: Advanced

download
Wayne Sheffield

Crazy Things That Developers Do

Level: Beginner

download
Rafael Salas

ETL Architecture Chekup: Avoiding Costly Mistakes

Level: Intermediate
9:30 AMMultiple Experts

Ask The Experts!

Level: Beginner
Paul Turley, Rushabh Mehta, and Mark Tabladillo

BI Expert Panel - Part 1

Level: Intermediate

download
Patrick LeBlanc

Introduction to Power BI

Level: Intermediate

download
David Klee

Squeezing Top Performance from Your Virtualized SQL Server

Level: Intermediate

download
miguel cebollero

Database Development Comes out of the Dark Ages

Level: Intermediate

download
Eric Peterson

SQL Server 2012 Always On - The Good, the Bad and the Ugly

Level: Intermediate
Brian Moran

Workplace Coaching: Simple Skills that Change Everything

Level: Non-Technical
Janis Griffin

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Level: Intermediate
Kerry Tyler

Manageable SSAS Deployment Strategies

Level: Beginner

download
Denny Cherry

SQL Server's In Memory Database Objects

Level: Intermediate

download
Robert Verell

READY FOR PROD

Level: Beginner

download
Scott Currie

Create and Load a Staging Environment from Scratch in an Hour with Biml

Level: Beginner
10:45 AMMultiple Experts

Ask The Experts!

Level: Beginner
Paul Turley, Rushabh Mehta, and Mark Tabladillo

BI Expert Panel - Part 2

Level: Intermediate
Justin Stephens

Data Visualization Using Excel

Level: Intermediate
David Dye

Implementing Auditing in SQL Server 2012

Level: Beginner
Ken Colson

Using recursive Common Table Expressions (CTE)

Level: Beginner

download
David Bermingham

High Availability with Windows Server 2012 R2 and SQL Server 2014

Level: Intermediate
Chris Skorlinski

Best Interview Ever

Level: Beginner

download
Grant Fritchey

Statistics and Query Optimization

Level: Intermediate
Lance England

Fundamentals of MDX

Level: Intermediate

download
Kathi Kellenberger

T-SQL Window Function Performance

Level: Advanced

download
Argenis Fernandez

Peace of Mind: Making DBCC CHECKDB Go Faster

Level: Intermediate

download
Allen White

Automate Your ETL Infrastructure with SSIS and PowerShell

Level: Intermediate

download
12:00 PMMultiple Experts

Quiz Bowl! - Room 223

Level: Beginner
Mark Scott

Governed Data Discovery with Pyramid Analytics (Why BI Office is way better than Tableau!)

Level: Non-Technical
JJ McDaniel

Cisco Unified Computing System

Level: Non-Technical
Carl Berglund

When Clustering and Virtualization Aren't Enough: How to Create an Application Availability Frame

Level: Non-Technical
Michael Sullivan

Automation beyond the SQL Server Scheduling capabilities with Streamworks

Level: Non-Technical

download
Geoff Hiten

Clusters Your Way.™ #SANLess clustering for physical, virtual and cloud environments

Level: Non-Technical
Rie Irish

Women in Technology Round Table Discussion

Level: Non-Technical
Janis Griffin

Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)

Level: Non-Technical
 Vin Prasad

SQL Server In-Memory OLTP Meets ioMemory by Fusion-io

Level: Non-Technical
  
1:15 PMMultiple Experts

Ask The Experts!

Level: Beginner
Rodney Landrum

Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL Servers

Level: Intermediate
Melissa Coates

Administering & Managing the Power BI Environment

Level: Beginner
Jason Brimhall

SQL 2012 Table Compression

Level: Advanced

download
Richie Rump

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

Level: Intermediate
Sven Aelterman

Windows Server 2012 R2 High Availability for SQL Server

Level: Intermediate
Various Speakers

Lightning Talks!

Level: Beginner
Kenneth Urena

Indexing strategies and good physical designs for performance tuning

Level: Intermediate

download
Damu Venkatesan

DAX 101

Level: Beginner
Dan Holmes

GIS Data and Solving the Shortest Path

Level: Advanced
Brandon Leach

Wrangling performance with Resource Governor

Level: Beginner
Tim Mitchell

15 Quick Tips for SSIS Performance

Level: Intermediate
2:30 PMMultiple Experts

Ask The Experts!

Level: Beginner
Pam Shaw

Tips & Tricks for dynamic SSRS Reports

Level: Beginner

download
Julie Smith

Power Power Query Query With Julie Smith and Rob Volk.

Level: Beginner
Chris Bell

The Spy Who Loathed Me - An Intro to SQL Security

Level: Beginner

download
Jon Boulineau

T-SQL: Beyond the Basics

Level: Intermediate
Wendy Pastrick

Navigating the Options for Data Redundancy

Level: Intermediate
Stuart Ainsworth

Managing a Technical Team: Lessons Learned

Level: Beginner

download
Joe Chang

Automating Execution Plan Analysis

Level: Advanced

download
 Kevin Boles

SQL Server 2014 New Features

Level: Intermediate

download
Kalen Delaney

What’s Simple About SIMPLE Recovery?

Level: Intermediate
Steven Wake

SSIS 2012: More Than Just a Pretty UI

Level: Beginner

download
3:45 PMMultiple Experts

Ask The Experts!

Level: Beginner
Tamera Clark

45 min to build your first SSRS report

Level: Beginner

download
Jason Thomas

DataViz You Thought You Couldn't Do with SSRS

Level: Advanced
David Dye

Column Level Encryption

Level: Beginner
Jeffrey Garbus

Bad, less Bad, not Bad; rewriting bad SQL Code

Level: Beginner
Thomas Stringer

AlwaysOn Availability Groups Troubleshooting and Common Issues

Level: Intermediate

download
Louis Davidson

Database Design Fundamentals

Level: Beginner

download
Ed Watson

"So you have a performance issue. What now?"

Level: Beginner

download
Nelson Davis

Merging Excel files from SharePoint for Analysis in Tableau with the BI Stack

Level: Intermediate
Ryan Duclos

Microsoft Azure SQL Database

Level: Beginner

download
Tim Radney

It is TEMPDB, Why Should You Care?

Level: Intermediate

download
Robert Cain

Everything You Ever Knew About SSIS Is Null and Void

Level: Intermediate

download
4:45 PMSQLSaturday 285

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
"So you have a performance issue. What now?"Ed WatsonBeginner
12 Steps to Workload TuningJohn SterrettBeginner
15 Quick Tips for SSIS PerformanceTim MitchellIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
5 TSQL Commands I've Been MissingJason CarterBeginner
A better Craigslist search with Power Query.Will HarveyBeginner
Administering & Managing the Power BI EnvironmentMelissa CoatesBeginner
Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite) Janis GriffinNon-Technical
AlwaysOn Availability Groups Troubleshooting and Common IssuesThomas StringerIntermediate
AlwaysOn Live DeploymentRyan AdamsIntermediate
Ask The Experts!Multiple ExpertsBeginner
Automate your daily checklist with PBM and CMSJohn SterrettIntermediate
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Automating Execution Plan AnalysisJoe ChangAdvanced
Automation beyond the SQL Server Scheduling capabilities with StreamworksMichael SullivanNon-Technical
Backup Strategies are for Losers!Ed WatsonBeginner
Bad, less Bad, not Bad; rewriting bad SQL CodeJeffrey GarbusBeginner
Best Interview EverChris SkorlinskiBeginner
Best Practices for Database DeploymentGrant FritcheyIntermediate
BI Expert Panel - Part 1Paul Turley, Rushabh Mehta, and Mark TabladilloIntermediate
BI Expert Panel - Part 2Paul Turley, Rushabh Mehta, and Mark TabladilloIntermediate
BIML--Step by StepJulie SmithIntermediate
Bus Matrix – The Foundation of your Dimensional DWBill AntonIntermediate
Capture Change and Apply it With Change Data Capture & SSISSteven WakeIntermediate
Check Engine LightsChris SkorlinskiIntermediate
Cisco Unified Computing SystemJJ McDanielNon-Technical
Clusters Your Way.™ #SANLess clustering for physical, virtual and cloud environmentsGeoff HitenNon-Technical
Code-Less Securing of SQL ServerArgenis FernandezIntermediate
Column Level EncryptionDavid DyeBeginner
Configuring PowerBI in O365Patrick LeBlancIntermediate
Crazy Things That Developers DoWayne SheffieldBeginner
Create and Load a Staging Environment from Scratch in an Hour with BimlScott CurrieBeginner
Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL ServersRodney LandrumIntermediate
Data Visualization Using ExcelJustin StephensIntermediate
Database Design Disasters: Common Mistakes Found in the WildRichie RumpIntermediate
Database Design FundamentalsLouis DavidsonBeginner
Database Development Comes out of the Dark Agesmiguel cebolleroIntermediate
DataViz You Thought You Couldn't Do with SSRSJason ThomasAdvanced
DAX 101Damu VenkatesanBeginner
Dealing With Errors in SSIS 2012David DyeAdvanced
Deploying Highly Available SQL Servers in the Amazon EC2 CloudDavid BerminghamIntermediate
Designing & Formatting ReportsTamera ClarkBeginner
Determining Power and Cooling Requirements of the Data CenterJimmy DixonNon-Technical
Disaster Recovery Strategies from BackupsKenneth UrenaIntermediate
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love DevelopersRichie RumpIntermediate
ETL Architecture Chekup: Avoiding Costly MistakesRafael SalasIntermediate
Everything You Ever Knew About SSIS Is Null and VoidRobert CainIntermediate
Everything you wanted to know about credit card processing but were afraid to askJimmy DixonNon-Technical
Excel - the Ultimate Self-Service BI ClientJustin StephensBeginner
Exposing Data through ASP.Net Web APIJim WooleyAdvanced
Fundamentals of MDXLance EnglandIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
GIS Data and Solving the Shortest PathDan HolmesAdvanced
Governed Data Discovery with Pyramid Analytics (Why BI Office is way better than Tableau!)Mark ScottNon-Technical
High Availability and Disaster Recovery in the Microsoft Azure CloudDavid BerminghamIntermediate
High Availability with Windows Server 2012 R2 and SQL Server 2014David BerminghamIntermediate
How Active Directory affects SQL ServerRyan AdamsAdvanced
How to Argue with Your Infrastructure Admins – and WinDavid KleeIntermediate
How to be a GREAT DBAJeffrey GarbusBeginner
How to Implement a Hierarchy in SQL ServerLouis DavidsonIntermediate
How to Write a DML TriggerLouis DavidsonIntermediate
I'm Bringing Sexyback (Writeback)Justin StephensAdvanced
Implementing a HIPAA Compliance Strategy with SQL ServerBrandon LeachBeginner
Implementing Auditing in SQL Server 2012David DyeBeginner
Independent Contracting 101Michael FrenchBeginner
Index Tuning for the DBABen DeBowIntermediate
Indexes: Taking the Next StepJon BoulineauIntermediate
Indexing for Join OptimizationJeffrey GarbusAdvanced
Indexing for performanceJeffrey GarbusIntermediate
Indexing strategies and good physical designs for performance tuningKenneth UrenaIntermediate
Introducing the SSAS 2012 BI Semantic Model, aka TabularRobert CainIntermediate
Introduction to Power BIPatrick LeBlancIntermediate
Introduction to Power BI Data Management GatewayPatrick LeBlancIntermediate
Introduction to PowerShell for DBAsJon BoulineauBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
I've Got A SQL Database, Now What?Denny CherryBeginner
Judge, Jury, and Executioner--A First Look At Execution PlansCarlos ChaconBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
Know Your Role(s)!Robert VerellIntermediate
Lightning Talks!Various SpeakersBeginner
Location Location Location Preparing and Presenting Geographic DataDavid DyeBeginner
Lunch BreakSQLSaturday 285Non-Technical
Maintenance and Backups: Intro to Ola HallengrenJason CarterBeginner
Make Your SQL Server Management PowerShell Code Go FasterThomas StringerIntermediate
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Manage your shop with CMS and Policy Based MgmtRyan AdamsBeginner
Manageable SSAS Deployment StrategiesKerry TylerBeginner
Managing a Technical Team: Lessons LearnedStuart AinsworthBeginner
Master the Date Dimension Like a Time LordSteven WakeBeginner
Merging Excel files from SharePoint for Analysis in Tableau with the BI StackNelson DavisIntermediate
Microsoft Azure SQL DatabaseRyan DuclosBeginner
Mirroring Start to FinishRyan AdamsIntermediate
Modern PerformanceJoe ChangAdvanced
Multidimensional vs. Tabular: Which ModelPatrick LeBlancIntermediate
Murder They WroteJason BrimhallIntermediate
Navigating the Options for Data RedundancyWendy PastrickIntermediate
Optimizing Protected IndexesChris BellIntermediate
Peace of Mind: Making DBCC CHECKDB Go FasterArgenis FernandezIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Power Power Query Query With Julie Smith and Rob Volk.Julie SmithBeginner
Predictive Analytics for the Data Scientist and BI ProTeo LachevIntermediate
Quiz Bowl! - Room 223Multiple ExpertsBeginner
RaffleSQLSaturday 285Non-Technical
READY FOR PRODRobert VerellBeginner
Real-time BI with StreamInsightTeo LachevIntermediate
RegistrationsSQLSaturday 285Non-Technical
Scaling Out SQL Server Reporting ServicesSven AeltermanAdvanced
Scripting in SSISTim MitchellBeginner
Self-Service BI Reporting using SharePoint 2013Robert CainBeginner
Self-Service ETL and Power Query: Are we there yet?Rafael SalasIntermediate
So you think MDX is hard?Robert CainIntermediate
SQL 2012 AlwaysOn QuickstartRyan AdamsBeginner
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL Server 2012 Always On - The Good, the Bad and the UglyEric PetersonIntermediate
SQL Server 2014 Column Store Index vNEXTKevin BolesAdvanced
SQL Server 2014 Demos GalorePatrick LeBlancBeginner
SQL Server 2014 New FeaturesKevin BolesIntermediate
SQL Server Defaults SUCK!!Kevin BolesIntermediate
SQL Server In-Memory OLTP Meets ioMemory by Fusion-ioVin PrasadNon-Technical
SQL Server Optimization for SharePointSven AeltermanIntermediate
SQL Server Virtualization 101David KleeBeginner
SQL Server's In Memory Database ObjectsDenny CherryIntermediate
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeIntermediate
SSAS Tabular SecurityPatrick LeBlancIntermediate
SSIS 2012: More Than Just a Pretty UISteven WakeBeginner
Statistics and Query OptimizationGrant FritcheyIntermediate
Supercharge Microsoft BI with Pyramid AnalyticsMark ScottIntermediate
Surviving Your Peak Database LoadBen DeBowIntermediate
Table Indexing for the .NET DeveloperDenny CherryIntermediate
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettBeginner
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Tabular Models: Easier & Faster Than Cubes; Really? Paul TurleyIntermediate
Taking the Scary out of Monster ReportsPam ShawBeginner
Tax, Finance, and Money Tips for consultants: 20+ years of experienceBrian MoranBeginner
The 20-Minute Tabular ModelBill AntonBeginner
The Agile DBA: Managing your To-Do ListStuart AinsworthBeginner
The Elephant in the Room; A DBA's Guide to Hadoop & Big DataStuart AinsworthBeginner
The Last Mile: Dynamically Created ObjectsDan HolmesAdvanced
The Secret Life of an INSERT StatementArgenis FernandezIntermediate
The Spy Who Loathed Me - An Intro to SQL SecurityChris BellBeginner
TheSQLGuru's Free and Low-Cost ToolsKevin BolesBeginner
Tips & Tricks for dynamic SSRS ReportsPam ShawBeginner
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
Troubleshooting SQL Server with Extended EventsThomas StringerIntermediate
Troubleshooting SQL Server with SysInternals ToolsArgenis FernandezAdvanced
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
T-SQL Window Function PerformanceKathi KellenbergerAdvanced
T-SQL: Beyond the BasicsJon BoulineauIntermediate
Using recursive Common Table Expressions (CTE)Ken ColsonBeginner
Using SQL Server 2012s Always OnDenny CherryIntermediate
Using SSDT (SQL Server Data Tools) to Manage Database LifecycleSergey BarskiyIntermediate
What’s Simple About SIMPLE Recovery?Kalen DelaneyIntermediate
When Clustering and Virtualization Aren't Enough: How to Create an Application Availability FrameCarl Berglund Non-Technical
When reporting is more than reportingPam ShawIntermediate
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Windows Azure SQL DatabaseRyan DuclosBeginner
Windows Server 2012 R2 High Availability for SQL ServerSven AeltermanIntermediate
Women in Tech PanelKathi KellenbergerBeginner
Women in Technology Round Table DiscussionRie IrishNon-Technical
Workplace Coaching: Simple Skills that Change EverythingBrian MoranNon-Technical
Wrangling performance with Resource GovernorBrandon LeachBeginner
Wrangling performance with Resource GovernorBrandon LeachBeginner
Writing Better T-SQL Queries with Window FunctionsKathi KellenbergerAdvanced
You Inherited a Database, Now What?Tim RadneyBeginner
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