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 TimeSQL Clinic - Room: 146Track #1 (BI) - Room: 135Track #2 (BI) - Room: 237Track #3 (Pro Dev) - Room: 231Track #4 (DBA) - Room: 229Track #5 (Dev) - Room: 240Track #6 (Misc) - Room: 145Track #7 (Misc) - Room: 220
8:45 AMSQL Saturday 277

SQL Clinic

Level: Non-Technical
Jason Thomas

DataViz You Thought You Couldn't Do with SSRS

Level: Advanced
Melissa Coates

Administering & Managing the Power BI Environment

Level: Beginner
Chris Skorlinski

Your Best Interview Ever

Level: Beginner

download
Tim Radney

Know Backups and Know Recovery

Level: Intermediate

download
Chris Bell

The Spy Who Loathed Me - An Intro to SQL Security

Level: Beginner

download
Brandon Leach

Wrangling performance with Resource Governor

Level: Beginner
Jason Brimhall

SQL 2012 Extended Events

Level: Advanced
10:00 AMSQL Saturday 277

SQL Clinic

Level: Non-Technical
Andy Leonard

Hacking the SSIS 2012 Catalog

Level: Beginner
Rafael Salas

ETL Architecture Chekup: Avoiding Costly Mistakes

Level: Intermediate
Doug Purnell

Congrats on your promotion to DBA, now what?

Level: Beginner

download
Andrew Kelly

Squeezing the Most out of Row & Page Compression

Level: Intermediate

download
Mike Sullivan

Practical SQL: High Availability and Disaster Recovery for SQL Server

Level: Intermediate
Wayne Sheffield

Crazy Things That Developers Do

Level: Beginner

download
Kevin Feasel

T-SQL Anti-Patterns

Level: Intermediate

download
11:15 AMSQL Saturday 277

SQL Clinic

Level: Non-Technical
Geoff Johnson

Using Expressions to Avoid Three SSRS Annoyances

Level: Intermediate

download
Brian Davis

SSIS Templates Can Make Your Life Easier

Level: Beginner
Jessica Moss

Lights, Camera, Action: Creating and Delivering Technical Presentations

Level: Non-Technical
Rick Heiges

Community and Cool Stuff

Level: Beginner
John Sterrett

Automate your daily checklist with PBM and CMS

Level: Intermediate

download
Louis Davidson

How to Write a DML Trigger

Level: Intermediate

download
Jason Brimhall

SQL 2012 Table Compression

Level: Advanced
12:15 PM Timothy McAliley

SQL Server 2014 Launch: Breakthrough Data Platform Performance with SQL 2014

Level: Non-Technical
  Carlos Parra

Database Performance Analyzer

Level: Beginner
Jason Smith

Application Acceleration

Level: Non-Technical
 David Orlandi

Database Performance Monitoring with Spotlight on SQL Server Enterprise

Level: Beginner
01:30 PMSQL Saturday 277

SQL Clinic

Level: Non-Technical
Andy Leonard

Using BIML as an SSIS Design Patterns Engine

Level: Advanced
Mark Hudson

Making Predictions with Microsoft Data Mining Tools

Level: Intermediate

download
Paul Rizza

Getting a job with Microsoft

Level: Non-Technical
Slava Murygin

Inside of Indexes

Level: Intermediate

download
Brandon Leach

Treating Tables Like Legos, Partitioning Basics

Level: Beginner
John Sterrett

12 Steps to Workload Tuning

Level: Intermediate

download
Rick Heiges

Basic Monitoring with Perfmon

Level: Beginner
02:45 PMSQL Saturday 277

SQL Clinic

Level: Non-Technical
Jessica Moss

Data Warehouse ETL Rollback with SSIS 2012

Level: Advanced
Timothy McAliley

Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure

Level: Intermediate
 Carlos Chacon

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

Level: Beginner
Ayman El-Ghazali

SQL Server Internals Party: Storage, Memory and the Query Life-cycle

Level: Beginner

download
 Chris Skorlinski

Check Engine Lights

Level: Intermediate

download


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
12 Steps to Workload TuningJohn SterrettIntermediate
Administering & Managing the Power BI EnvironmentMelissa CoatesBeginner
Application AccelerationJason SmithNon-Technical
Automate your daily checklist with PBM and CMSJohn SterrettIntermediate
Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window AzureTimothy McAlileyIntermediate
Basic Monitoring with PerfmonRick HeigesBeginner
Basic Monitoring with PerfmonRick HeigesBeginner
Best SQL Server Programming practicesSlava MuryginBeginner
Check Engine LightsChris SkorlinskiIntermediate
Community and Cool StuffRick HeigesBeginner
Congrats on your promotion to DBA, now what?Doug PurnellBeginner
Crazy Things That Developers DoWayne SheffieldBeginner
Data Warehouse ETL Rollback with SSIS 2012Jessica MossAdvanced
Database Design FundamentalsLouis DavidsonIntermediate
Database Design: Size DOES MatterThomas LaRockIntermediate
Database Forensics - Part 1Paresh MotiwalaAdvanced
Database Forensics - Part 2Paresh MotiwalaAdvanced
Database Performance AnalyzerCarlos ParraBeginner
Database Performance Monitoring with Spotlight on SQL Server EnterpriseDavid OrlandiBeginner
DataViz You Thought You Couldn't Do with SSRSJason ThomasAdvanced
DBA Code Reviews Done Dirt CheapRobert DavisIntermediate
Designing SSIS Solutions for Performance and ScalabilityJon TupitzaAdvanced
Determining Power and Cooling Requirements of the Data CenterJimmy DixonNon-Technical
ETL Architecture Chekup: Avoiding Costly MistakesRafael SalasIntermediate
ETL in a Nutshell with SSISBrett TomsonBeginner
ETL not ELT! Common mistakes and misconceptions about SSISPaul RizzaAdvanced
Everything you wanted to know about credit card processing but were afraid to askJimmy DixonNon-Technical
Extended Properties and how to automate DB Documenting process. Slava MuryginBeginner
Field Testing Buffer Pool Extension and In-Memory OLTPRick HeigesBeginner
Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure Timothy McAlileyIntermediate
Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure Timothy McAlileyIntermediate
Getting a job with Microsoft Paul RizzaNon-Technical
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Hacking the SSIS 2012 CatalogAndy LeonardBeginner
How to Write a DML TriggerLouis DavidsonIntermediate
Implementing Contained DatabasesRobert DavisIntermediate
Inside of IndexesSlava MuryginIntermediate
Intro to Common Table ExpressionsGeoff JohnsonBeginner
Intro to Ranking and Aggregate Window FunctionsGeoff JohnsonBeginner
Introduction to Modeling Data Marts and WarehousesJon TupitzaBeginner
Introduction to PowerPivot and DAXGeoff JohnsonBeginner
Introduction to Windows Azure HDInsightJon TupitzaBeginner
Judge, Jury, and Executioner--A First Look At Execution PlansCarlos ChaconBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
Lights, Camera, Action: Creating and Delivering Technical PresentationsJessica MossNon-Technical
Making Predictions with Microsoft Data Mining ToolsMark HudsonIntermediate
Maximizing the Data Exploration Capabilities of Power ViewMelissa CoatesBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockIntermediate
Network or PerishParesh MotiwalaAdvanced
Optimizing Protected IndexesChris BellIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Power This, Power That...Making Sense of Power BIBrett TomsonBeginner
Practical SQL: High Availability and Disaster Recovery for SQL ServerMike SullivanIntermediate
Put Your Data on the MapMark HudsonBeginner
Securing Semantic Models: Real World ScenariosBrett TomsonIntermediate
Self-Service ETL and Power Query: Are we there yet?Rafael SalasIntermediate
Solving Real-World Problems with Power QueryRafael SalasIntermediate
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL ClinicSQL Saturday 277Non-Technical
SQL Server 2014 Launch: Breakthrough Data Platform Performance with SQL 2014Timothy McAlileyNon-Technical
SQL Server Backup and Recovery FundamentalsAyman El-GhazaliBeginner
SQL Server Internals Party: Storage, Memory and the Query Life-cycleAyman El-GhazaliBeginner
Squeezing the Most out of Row & Page CompressionAndrew KellyIntermediate
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Tally 'Em UpKevin FeaselBeginner
TempDB 101Andrew KellyIntermediate
The Spy Who Loathed Me - An Intro to SQL SecurityChris BellBeginner
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
T-SQL Anti-PatternsKevin FeaselIntermediate
T-SQL Performance Guidelines for better DB stress Shehap El-NagarAdvanced
T-SQL SELECT Subqueries - In and Out of the BoxGeoff JohnsonBeginner
Understanding the TablixGeoff JohnsonBeginner
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using Expressions to Avoid Three SSRS AnnoyancesGeoff JohnsonIntermediate
Using SQL Server Security Features to Satisfy Custom Regulatory RequirementsJon TupitzaIntermediate
What Can Data Quality Services Do for You?Mark HudsonBeginner
What's in the SQL Server 2012 Business Intelligence Suite?Jessica MossBeginner
Why do we shun using tools for DBA job?Paresh MotiwalaAdvanced
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Workplace Coaching: Simple Skills that Change EverythingBrian MoranNon-Technical
Wrangling performance with Resource GovernorBrandon LeachBeginner
You Inherited a Database, Now What?Tim RadneyBeginner
Your Best Interview EverChris SkorlinskiBeginner
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.

Suggested Session TitleSkill Level
I want to be a DBA, but am not sure how--Help!Beginner
SharePoint DBABeginner
Table partitioning in sql serverIntermediate

SQLSaturday Home
PASS