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 TimeTrack I - Room: 113Track II - Room: 205Track III - Room: 103Track IV - Room: 203Track V - Room: 211
08:30 AMBrandon Leach

Wrangling performance with Resource Governor

Level: Beginner
Grant Fritchey

Best Practices for Database Deployment

Level: Intermediate
John Flannery

What the Hekaton

Level: Intermediate

download
Sunil Kadimdiwan

Develop Impressive Dashboards using SSRS 2014

Level: Intermediate

download
David Klee

Easy SQL Server Benchmarking

Level: Beginner
09:55 AMMike Hillwig

From Mess to Mastery: Managing Large Environments

Level: Beginner
Joseph D'Antoni

SQL Server--All About HA and DR

Level: Intermediate

download
Dan Clark

Mastering Date-Time Based Analysis in DAX

Level: Intermediate
Ben Miller

SMO Internals for High Performance Automation

Level: Intermediate

download
Adam Machanic

T-SQL Power! SQL Server Windows That Open Doors

Level: Intermediate
11:20 AM Wayne Sheffield

Crazy Things That Developers Do

Level: Beginner

download
Steve Simon

DAX and the tabular model

Level: Intermediate

download
Andrew Kelly

Squeezing the Most out of Row & Page Compression

Level: Intermediate

download
Jason Hall

5 Common SQL Server Performance Issues

Level: Intermediate
12:30 PMAndy Roberts

Introducing SQL Server 2014 (Lunch Session Room 102)

Level: Beginner
Andy Roberts

Introducing SQL Server 2014 (Lunch Session Room 102)

Level: Beginner
Andy Roberts

Introducing SQL Server 2014 (Lunch Session Room 102)

Level: Beginner
Andy Roberts

Introducing SQL Server 2014 (Lunch Session Room 102)

Level: Beginner
Andy Roberts

Introducing SQL Server 2014 (Lunch Session Room 102)

Level: Beginner
01:40 PMJoseph D'Antoni

Building Perfect SQL Servers, Every Time

Level: Beginner

download
Grant Fritchey

Statistics and Query Optimization

Level: Intermediate
Ben Miller

SQL Server TDE

Level: Intermediate

download
Paresh Motiwala

DBA to Project Manager in 70 minutes flat

Level: Advanced

download
Andy Roberts

It's not just a pivot on the data...

Level: Advanced
03:05 PMDavid Klee

Squeezing Top Performance from Your Virtualized SQL Server

Level: Intermediate
Edward Pollack

Dynamic SQL: Writing Efficient Queries on the Fly

Level: Beginner

download
Dan Clark

Using Hive to Query and Process Big Data

Level: Beginner
Andrew Kelly

TempDB 101

Level: Intermediate

download
John Miner

Basic Database Programming

Level: Beginner


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
(a Few of) My Favorite DMVsEdward PollackBeginner
12 Steps to Workload TuningJohn SterrettBeginner
5 Common SQL Server Performance IssuesJason HallIntermediate
A dive into Data Quality ServicesSteve SimonIntermediate
An introduction to Data MiningSteve SimonIntermediate
Automate your daily checklist with PBM and CMSJohn SterrettIntermediate
Basic Database Design John MinerBeginner
Basic Database ProgrammingJohn MinerBeginner
Be Friendly to SQL Server with TSQL Best PracticesBen MillerBeginner
Best Practices for Database DeploymentGrant FritcheyIntermediate
Building Perfect SQL Servers, Every TimeJoseph D'AntoniBeginner
Building Your Own Monitors with the SQL AgentMike HillwigIntermediate
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Challenges to designing financial warehouses, lessons learntSteve SimonIntermediate
Changing Your Habits to Improve the Performance of Your T-SQLMickey StueweBeginner
Crazy Things That Developers DoWayne SheffieldBeginner
Creating efficient and effective SSRS BI SolutionsSteve SimonIntermediate
Database design for mere developersSteve SimonIntermediate
Database Forensics - Part 1Paresh MotiwalaAdvanced
Database Forensics - Part 2Paresh MotiwalaAdvanced
DAX and the tabular modelSteve SimonIntermediate
DBA to Project Manager in 70 minutes flatParesh MotiwalaAdvanced
Develop Impressive Dashboards using SSRS 2014Sunil KadimdiwanIntermediate
Development Lifecycle with SQL Server Data ToolsJohn FlanneryIntermediate
Diving Into Query Execution PlansEdward PollackIntermediate
Dynamic SQL: Writing Efficient Queries on the FlyEdward PollackBeginner
Easy SQL Server BenchmarkingDavid KleeBeginner
Effective use of temporary tablesJohn MinerIntermediate
From Mess to Mastery: Managing Large Environments Mike HillwigBeginner
Get your Mining Model Predictions out to allSteve SimonIntermediate
Getting the Skinny on Minimally Logged OperationsAndrew KellyIntermediate
How Not to Be a Cranky DBAMike HillwigBeginner
How to Argue with Your Infrastructure Admins – and WinDavid KleeIntermediate
How to audit and prevent unwanted user actions.John MinerIntermediate
Introducing SQL Server 2014 (Lunch Session Room 102)Andy RobertsBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
It's not just a pivot on the data...Andy RobertsAdvanced
Know Backups and Know RecoveryTim RadneyIntermediate
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Master Data Services Best PracticesSteve SimonIntermediate
Master Data Services Disaster RecoverySteve SimonIntermediate
Mastering Date-Time Based Analysis in DAXDan ClarkIntermediate
Microsoft Lunch SessionAndy RobertsNon-Technical
Mind your language!! Cursors are a dirty wordSteve SimonIntermediate
Monitoring Server health via Reporting Services dashboardsSteve SimonIntermediate
Monitoring Server health via Reporting Services dashboardsSteve SimonIntermediate
Murder They WroteJason BrimhallIntermediate
Network or PerishParesh MotiwalaAdvanced
Query Optimization Crash CourseEdward PollackBeginner
Recipe for a happy DBAJason HallBeginner
Recovery and Backup for BeginnersMike HillwigBeginner
Report With Power: New Data Tools, New InsightsJames McAuliffeBeginner
Scalable SSRS Reports Achieved Through the Powerful TablixMickey StueweIntermediate
SMO Internals for High Performance AutomationBen MillerIntermediate
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL Server 2012 AlwaysOn Availability GroupsGeorge WaltersBeginner
SQL Server 2012 Failover ClusteringGeorge WaltersIntermediate
SQL Server 2012 Performance Tuning All UpGeorge WaltersIntermediate
SQL Server 2014 New FeaturesGeorge WaltersIntermediate
SQL Server Reporting Services Best PracticesSteve SimonIntermediate
SQL Server TDEBen MillerIntermediate
SQL Server Virtualization 101David KleeBeginner
SQL Server--All About HA and DRJoseph D'AntoniIntermediate
Squeezing the Most out of Row & Page CompressionAndrew KellyIntermediate
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeIntermediate
SSIS 2012 – The Project Deployment ModelJohn FlanneryBeginner
Statistics and Query OptimizationGrant FritcheyIntermediate
Storing Data in Windows AzureAndy RobertsBeginner
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettIntermediate
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
TempDB 101Andrew KellyIntermediate
The Modern Data WarehouseAndy RobertsBeginner
Transaction Log Internals: Virtual Log FilesMike HillwigAdvanced
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
T-SQL Power! SQL Server Windows That Open DoorsAdam MachanicIntermediate
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Using Hive to Query and Process Big DataDan ClarkBeginner
What the Hek is under the covers? Andy RobertsAdvanced
What the HekatonJohn FlanneryIntermediate
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Wrangling performance with Resource GovernorBrandon LeachBeginner
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.

Suggested Session TitleSkill Level
What the Heck is SQL Anyway?Beginner

SQLSaturday Home
PASS