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 Time Auditorium - Room: AuditoriumTraining 1 - Room: Training 1Training 2 - Room: Training 2Training 3 - Room: Training 3Training 4 - Room: Training 4Training 5 - Room: Training 5Training 6 - Room: Training 6
07:30 AMSQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
SQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
SQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
SQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
SQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
SQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
SQLSaturday 241

Registration Opens (Front Entrance)

Level: Non-Technical
08:00 AMSQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Opening Ceremonies (Atrium)

Level: Non-Technical
08:45 AMThomas LaRock

Query Performance Tuning: A 12 Step Program

Level: Intermediate

download
Julie Smith

BIML--Step by Step

Level: Intermediate

download
Tim Radney

Know Backups and Know Recovery

Level: Intermediate

download
Steve Jones

The Encryption Primer

Level: Beginner

download
Sam Nasr

14 New T-SQL Functions

Level: Intermediate

download
Mark Vaillancourt

MDX Trek: First Contact

Level: Intermediate

download
Paul Hiles

The Evils of Cursors

Level: Beginner

download
10:00 AMStacia Misner

Reduce, Reuse, Recycle: Automating Your BI Framework

Level: Intermediate

download
Grant Fritchey

Statistics and Query Optimization

Level: Intermediate
Brian Davis

Getting Started with Hekaton (In-Memory OLTP)

Level: Beginner

download
Kathi Kellenberger

Writing Better Queries with T-SQL Window Functions

Level: Advanced

download
Steve Hood

Monitoring and Baselines

Level: Intermediate
Jeff Mlakar

A Tour of Power BI: Pivot, View, Query, and Map

Level: Beginner

download
Kerry Tyler

Manageable SSAS Deployment Strategies

Level: Beginner

download
11:15 AMAllen White

Automate Your ETL Infrastructure with SSIS and PowerShell

Level: Intermediate

download
Thomas LaRock

Database Design: Size DOES Matter

Level: Intermediate

download
Mindy Curnutt

SQL Server Bingo – Install, Migration & Config

Level: Beginner

download
Steve Jones

Branding Yourself for a Dream Job

Level: Beginner

download
Lisa Gardner

Code Management with SQL Server Data Tools

Level: Beginner

download
Tamera Clark

45 min to build your first SSRS report

Level: Beginner

download
Jeff Moden

Hierarchies... on Steroids the No RBAR Way

Level: Intermediate

download
12:15 PMSQLSaturday 241

Lunch & Vendor Sessions - SQL Server 2014 (Microsoft)

Level: Non-Technical
SQLSaturday 241

Lunch & Vendor Sessions - SQL Sentry

Level: Non-Technical
SQLSaturday 241

Lunch & Vendor Sessions

Level: Non-Technical
SQLSaturday 241

Lunch & Vendor Sessions - Tegile

Level: Non-Technical
SQLSaturday 241

Lunch & Vendor Sessions - Digineer

Level: Non-Technical
SQLSaturday 241

Lunch & Vendor Sessions - Confio

Level: Non-Technical
SQLSaturday 241

Lunch & Vendor Sessions - TMW Systems

Level: Non-Technical
01:30 PMKendal Van Dyke

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

Level: Beginner

download
Argenis Fernandez

Code-Less Securing of SQL Server

Level: Intermediate

download
Konstantin Melamud

Performance Tuning - Analyzing Execution Plans

Level: Intermediate
Joseph D'Antoni

SQL 2012 -- All About HA and DR

Level: Beginner
David Maxwell

DBA 911 - Database Corruption

Level: Beginner

download
Mark Vaillancourt

DANGER: The Art and Science of Presenting

Level: Beginner

download
Brandon Leach

Wrangling performance with Resource Governor

Level: Beginner

download
02:45 PMTim Radney

You Inherited a Database, Now What?

Level: Beginner

download
Stacia Misner

A Big Data Primer

Level: Beginner

download
Colleen Morrow

SQL Audit - auditing doesn't have to be boring

Level: Intermediate

download
Joseph D'Antoni

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

Level: Intermediate
Hope Foley

Spatial Data: Cooler Than You'd Think!

Level: Beginner

download
Kendal Van Dyke

Building Your Own SQL Server Virtual Playground

Level: Intermediate

download
Craig Purnell

Simplify your infrastructure with Managed Service Accounts

Level: Intermediate

download
04:00 PMBen Miller

Be Friendly to SQL Server with TSQL Best Practices

Level: Beginner

download
Tim Chapman

SQL Server Transaction Log Internals

Level: Advanced
Adam Belebczuk

XML Without Xanax: How to Handle XML in SQL Server

Level: Intermediate

download
Erin Stellato

Making the Leap from Profiler to Extended Events

Level: Beginner
Kevin Boles

SQL Server 2014 New Features

Level: Intermediate

download
Wendy Pastrick

Navigating the Options for Data Redundancy

Level: Intermediate

download
Cory Stevenson

SSIS Olympics

Level: Intermediate
05:00 PMSQLSaturday 241

Closing Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Closing Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Closing Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Closing Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Closing Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Closing Ceremonies (Atrium)

Level: Non-Technical
SQLSaturday 241

Closing Ceremonies (Atrium)

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
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
14 New T-SQL FunctionsSam NasrIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
A Big Data PrimerStacia MisnerBeginner
A heap of clustersAmi LevinAdvanced
A Tour of Power BI: Pivot, View, Query, and MapJeff MlakarBeginner
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Automated Database Build and TestSteve JonesIntermediate
Bad code leads to anger. Anger leads to hate. Hate leads to sufferingWilliam WolfBeginner
Be Friendly to SQL Server with TSQL Best PracticesBen MillerBeginner
Best Practices for Database DeploymentGrant FritcheyIntermediate
Better know who can access your SQL server and what can they do in there!Howard PinchamIntermediate
BIML--Step by StepJulie SmithIntermediate
Branding Yourself for a Dream JobSteve JonesBeginner
Building Products vs. ApplicationsAustin ZellnerBeginner
Building Your Own SQL Server Virtual PlaygroundKendal Van DykeIntermediate
Code Management with SQL Server Data ToolsLisa GardnerBeginner
Code-Less Securing of SQL ServerArgenis FernandezIntermediate
Common Problems in Backup and Recovery and How to Handle ThemGrant FritcheyBeginner
Common TSQL MistakesKevin BolesIntermediate
Conquering ETL ProjectsAustin ZellnerBeginner
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
DANGER: The Art and Science of PresentingMark VaillancourtBeginner
Database Design: Size DOES MatterThomas LaRockIntermediate
DBA 911 - Database CorruptionDavid MaxwellBeginner
Designing an SSIS Framework Andy LeonardAdvanced
Disabling xp_CmdShell - Is it really a best practice?Jeff ModenIntermediate
Discover, Document, & Diagnose Your Servers on Your Coffee BreakKendal Van DykeBeginner
Exposing SQL data with SharePointScott BrickeyBeginner
Extending SQL Server with Advanced Analytics and RMike SchulteBeginner
Failure Lab: An exploration into the benefits of failingJosh FennessyNon-Technical
Full-Text Search in SQL 2012 with Custom ProximitySam NasrIntermediate
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Help! I've Got XML In My Database!Kendal Van DykeIntermediate
Hierarchies... on Steroids the No RBAR WayJeff ModenIntermediate
Implementing a HIPAA Compliance Strategy with SQL ServerBrandon LeachBeginner
Index Performance Tuning with Dynamic Management ViewsDavid MaxwellBeginner
Indexes: The BasicsKathi KellenbergerBeginner
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Joseph D'AntoniIntermediate
Introducing Power BIStacia MisnerBeginner
Introduction to SQL Server 2012 AlwaysOn Availability GroupsAdam BelebczukIntermediate
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Introduction to SSIS 2012Sam NasrIntermediate
Introduction to SSRS 2012Sam NasrBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
LinkedIn for SQL Server ProfessionalsCraig PurnellBeginner
Lunch & Vendor SessionsSQLSaturday 241Non-Technical
Lunch & Vendor Sessions - ConfioSQLSaturday 241Non-Technical
Lunch & Vendor Sessions - DigineerSQLSaturday 241Non-Technical
Lunch & Vendor Sessions - SQL SentrySQLSaturday 241Non-Technical
Lunch & Vendor Sessions - SQL Server 2014 (Microsoft)SQLSaturday 241Non-Technical
Lunch & Vendor Sessions - TegileSQLSaturday 241Non-Technical
Lunch & Vendor Sessions - TMW SystemsSQLSaturday 241Non-Technical
Making the Leap from Profiler to Extended EventsErin StellatoBeginner
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Manageable SSAS Deployment StrategiesKerry TylerBeginner
MDX Trek: First ContactMark VaillancourtIntermediate
Minions and MeKonstantin MelamudBeginner
Monitoring and BaselinesSteve HoodIntermediate
Moving past "It Depends" to add DBA value to SalesAustin ZellnerBeginner
Navigating the Options for Data RedundancyWendy PastrickIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance Troubleshooting – Random Magic or a Science?Paul HilesIntermediate
Performance Tuning - Analyzing Execution PlansKonstantin MelamudIntermediate
Performance Tuning - Index OptimizationKonstantin MelamudBeginner
Periodic Table of DMVs: Part Two - The SQLTim FordAdvanced
Physical Join OperatorsAmi LevinAdvanced
Power BI with SQL, Excel and SharePointScott BrickeyBeginner
Present This, Not That!Kendal Van DykeBeginner
Query Performance Tuning: A 12 Step ProgramThomas LaRockIntermediate
Reduce, Reuse, Recycle: Automating Your BI FrameworkStacia MisnerIntermediate
Searching Binary Data in SQL Server 2012Steve JonesIntermediate
Self Service BI using Office 2013 and SQL 2012Akesh GuptaIntermediate
Simplify your infrastructure with Managed Service AccountsCraig PurnellIntermediate
SMO Internals for High Performance PowerShellBen MillerIntermediate
Spatial Data: Cooler Than You'd Think!Hope FoleyBeginner
SQL 2012 -- All About HA and DRJoseph D'AntoniBeginner
SQL Audit - auditing doesn't have to be boringColleen MorrowIntermediate
SQL Server 2014 Column Store Index vNEXTKevin BolesAdvanced
SQL Server 2014 New FeaturesKevin BolesIntermediate
SQL Server Bingo – Install, Migration & ConfigMindy CurnuttBeginner
SQL Server Defaults SUCK!!Kevin BolesIntermediate
SQL Server File ManagementLisa GardnerIntermediate
SQL Server Gameshow - Maint, Backup & RecoveryMindy CurnuttBeginner
SQL Server Index InternalsTim ChapmanAdvanced
SQL Server TDEBen MillerIntermediate
SQL Server Transaction Log InternalsTim ChapmanAdvanced
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS OlympicsCory StevensonIntermediate
Statistics and Query OptimizationGrant FritcheyIntermediate
Stored Procedures vs. Ad-Hoc Queries: Performance Showdown!Argenis FernandezIntermediate
The Encryption PrimerSteve JonesBeginner
The Evils of Cursors Paul HilesBeginner
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
Troubleshoot SQL Server Issues like a Microsoft EngineerTim ChapmanAdvanced
Updates to Statistics and Effects on Query PerformanceErin StellatoIntermediate
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using FiletablesSam NasrIntermediate
Using Statistical Semantic SearchSam NasrAdvanced
Visual Analytics with HDInsight and Power ViewJosh FennessyBeginner
Where did I put my (primary) keys?Ami LevinAdvanced
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Women in Tech PanelKathi KellenbergerBeginner
Wrangling performance with Resource GovernorBrandon LeachBeginner
Writing Better Queries with T-SQL Window FunctionsKathi KellenbergerAdvanced
Writing faster queriesTim ChapmanAdvanced
XML Without Xanax: How to Handle XML in SQL ServerAdam BelebczukIntermediate
You Inherited a Database, Now What?Tim RadneyBeginner


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