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 TimeGeneral Use - Room: LC 23BI / DBA - Room: LC 25Business Intelligence - Room: LC 20Database Administration - Room: LC 21Database Design - Room: LC 22Development - Room: LC 24
07:30 AMSQLSaturday 302

Breakfast

Level: Non-Technical
     
08:30 AMEarl Shaffer

A gentle introduction to Oracle 12 for SQL Server DBAs

Level: Intermediate
Joe Rourke

Seven Strategies for Awesome Excel Dashboards

Level: Beginner
James Phillips

Creating an SSIS Framework

Level: Intermediate
Tim Radney

Know Backups and Know Recovery

Level: Intermediate
Matthew Slocum

101 Stupid Things Your Colleagues Do When Setting Up SQL Server

Level: Intermediate
Chris Hyde

Ten T-SQL Techniques with Tally Tables

Level: Beginner
10:00 AMParesh Motiwala

Database Forensics - Part 1

Level: Advanced
Andy Tabisz

Creating Access 2013 Web Apps based on SQL Azure using SharePoint

Level: Beginner
Josh Luedeman

Show me whatcha workin' with: Big Data Edition

Level: Intermediate
Thomas Grohser

SQL Server Storage Engine under the hood

Level: Intermediate
Grant Fritchey

Statistics and Query Optimization

Level: Intermediate
Justin Dearing

MongoDB for the Relational DBA

Level: Beginner
11:30 AMSQLSaturday 302

Lunch

Level: Non-Technical
     
12:00 PMSQLSaturday 302

Lunch

Level: Non-Technical
   George Walters

SQL Server 2014: New Features Explained!

Level: Non-Technical
Kristi Ibello

Why the World Needed Another Storage Company

Level: Non-Technical
12:30 PMParesh Motiwala

Database Forensics - Part 2

Level: Advanced
Chris Bell

The Spy Who Loathed Me - An Intro to SQL Security

Level: Beginner

download
Julie Smith

BIML--Step by Step

Level: Intermediate
Janis Griffin

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

Level: Intermediate
Brandon Leach

Treating Tables Like Legos, Partitioning Basics

Level: Beginner
Kelly Gendron

Entity Framework - Optimization & Best Practices

Level: Beginner
02:00 PMMark Vaillancourt

DANGER: The Art and Science of Presenting

Level: Beginner
Robert Pearl

HealthySQL 2.0

Level: Beginner
Steve Simon

DAX and the tabular model

Level: Intermediate

download
Derek Stanley

Remove the Linked Server 2 Hop Limitation by Implementing Kerberos

Level: Advanced
Michael Nowill

SQL Server Compression - Getting More Out of Less

Level: Beginner
Bryan Cafferky

PowerShell for Database Developers

Level: Intermediate
03:30 PMMike Hillwig

How Not to Be a Cranky DBA

Level: Beginner
Sunil Kadimdiwan

Develop Impressive Dashboards using SSRS 2014

Level: Intermediate
Daniel Bowlin

SSIS Optimization techniques

Level: Intermediate
George Walters

Hybrid Cloud Scenarios with SQL Server 2014

Level: Intermediate

download
John Flannery

What the Hekaton

Level: Intermediate
John Miner

Effective use of temporary tables

Level: Intermediate
05:00 PMSQLSaturday 302

Raffle & Closing

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
101 Stupid Things Your Colleagues Do When Setting Up SQL ServerMatthew SlocumIntermediate
A dive into Data Quality ServicesSteve SimonIntermediate
A gentle introduction to Oracle 12 for SQL Server DBAsEarl ShafferIntermediate
An introduction to Data MiningSteve SimonIntermediate
Analysis Services Terms and Concepts for the DBAMark VaillancourtIntermediate
Auditing and administering SQL Server with PowershellJustin DearingIntermediate
Basic Database Design John MinerBeginner
Basic Database ProgrammingJohn MinerBeginner
Becoming Certified In Microsoft SQL ServerChris HydeBeginner
Best Practices for Database DeploymentGrant FritcheyIntermediate
BIML--Step by StepJulie SmithIntermediate
BreakfastSQLSaturday 302Non-Technical
Challenges to designing financial warehouses, lessons learntSteve SimonIntermediate
Creating Access 2013 Web Apps based on SQL Azure using SharePointAndy TabiszBeginner
Creating an SSIS FrameworkJames PhillipsIntermediate
Creating efficient and effective SSRS BI SolutionsSteve SimonIntermediate
DANGER: The Art and Science of PresentingMark VaillancourtBeginner
Data Partitioning - Doing the splits…in the name of performance, scalability and sanity!Michael NowillIntermediate
Database design for mere developersSteve SimonIntermediate
Database Forensics - Part 1Paresh MotiwalaAdvanced
Database Forensics - Part 2Paresh MotiwalaAdvanced
DAX and the tabular modelSteve SimonIntermediate
DBA for DummiesRobert PearlBeginner
DBA to Project Manager in 75 minutes flatParesh MotiwalaAdvanced
Develop Impressive Dashboards using SSRS 2014Sunil KadimdiwanIntermediate
Development Lifecycle with SQL Server Data ToolsJohn FlanneryIntermediate
Dimensional Modeling: The Heart of the Data WarehouseBryan CafferkyIntermediate
Effective use of temporary tablesJohn MinerIntermediate
Entity Framework - Optimization & Best PracticesKelly GendronBeginner
Establishing a SLAThomas GrohserIntermediate
From Mess to Mastery: Managing Large Environments Mike HillwigBeginner
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
Get your Mining Model Predictions out to allSteve SimonIntermediate
HealthySQL 2.0Robert PearlBeginner
How Not to Be a Cranky DBAMike HillwigBeginner
How to audit and prevent unwanted user actions.John MinerIntermediate
How to build a visual explore screen in ExcelJoe RourkeBeginner
Hybrid Cloud Scenarios with SQL Server 2014George WaltersIntermediate
Implementing a HIPAA Compliance Strategy with SQL ServerBrandon LeachBeginner
Keeping the "Business" in Business IntelligenceMark VaillancourtBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
LunchSQLSaturday 302Non-Technical
Master Data Services Best PracticesSteve SimonIntermediate
Master Data Services Disaster RecoverySteve SimonIntermediate
MDX Trek: First ContactMark VaillancourtIntermediate
Mind your language!! Cursors are a dirty wordSteve SimonIntermediate
MongoDB for the Relational DBAJustin DearingBeginner
Monitoring Server health via Reporting Services dashboardsSteve SimonIntermediate
Network or PerishParesh MotiwalaAdvanced
Optimizing Protected IndexesChris BellIntermediate
PowerShell for Database DevelopersBryan CafferkyIntermediate
Query Optimization Crash CourseEdward PollackBeginner
Raffle & ClosingSQLSaturday 302Non-Technical
Recovery and Backup for BeginnersMike HillwigBeginner
Remove the Linked Server 2 Hop Limitation by Implementing KerberosDerek StanleyAdvanced
Security and High Availability and DRThomas GrohserIntermediate
Seven Strategies for Awesome Excel DashboardsJoe RourkeBeginner
Show me whatcha workin' with: Big Data EditionJosh LuedemanIntermediate
So you think you know SSIS? What about Scripting? Bryan CafferkyAdvanced
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 2014: New Features Explained!George WaltersNon-Technical
SQL Server Compression - Getting More Out of LessMichael NowillBeginner
SQL Server Reporting Services Best PracticesSteve SimonIntermediate
SQL Server Storage Engine under the hood Thomas GrohserIntermediate
SSIS 2012 – The Project Deployment ModelJohn FlanneryBeginner
SSIS 2012 Parameters, deployments, and environmentsDaniel BowlinIntermediate
SSIS Optimization techniquesDaniel BowlinIntermediate
Statistics and Query OptimizationGrant FritcheyIntermediate
Ten T-SQL Techniques with Tally TablesChris HydeBeginner
The Spy Who Loathed Me - An Intro to SQL Security Chris BellBeginner
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
What the HekatonJohn FlanneryIntermediate
Why the World Needed Another Storage CompanyKristi IbelloNon-Technical
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