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 TimeAdministration - Room: Room 1BI & Big Data - Room: Room 2Development & Security - Room: Room 3Performance - Room: Room 4SSIS & ETL - Room: Room 2
09:00 AMAllen White

Manage SQLServer Efficiently w/PowerShell Remoting

Level: Intermediate

download
Scott Brickey

Exposing SQL data with SharePoint

Level: Beginner
Adam Belebczuk

Introduction to SQL Server Service Broker

Level: Beginner

download
Janis Griffin

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

Level: Intermediate

download
Brian Davis

SSIS Templates Can Make Your Life Easier

Level: Beginner
10:30 AMRyan Brickey

Policy Based Management: Introduction and Implementation

Level: Beginner

download
Andrew Holowaty

Full life-cycle of Self-Service BI with PowerPivot and the SSAS Tabular Model

Level: Intermediate
Kevin Boles

SQL Injection

Level: Intermediate

download
Konstantin Melamud

Performance Tuning - Analyzing Execution Plans

Level: Intermediate
George Squillace

SSIS for the Absolute Beginner

Level: Beginner
12:45 PMColleen Morrow

SQL Audit - auditing doesn't have to be boring

Level: Intermediate

download
Scott Brickey

Power BI with SQL, Excel and SharePoint

Level: Beginner
Craig Purnell

Achieving Compliance with SQL Server

Level: Beginner
Kevin Feasel

Tally 'Em Up

Level: Beginner
Allen White

Get Near Realtime ETL with Service Broker

Level: Intermediate

download
02:15 PMAdam Belebczuk

Introduction to SQL Server 2012 AlwaysOn Availability Groups

Level: Intermediate

download
Brian Davis

Getting Started with Hekaton (In-Memory OLTP)

Level: Beginner
Chris Bell

The Spy Who Loathed Me - An Intro to SQL Security

Level: Beginner

download
Steve Hood

Indexing Fundamentals

Level: Intermediate
Kevin Boles

Unit Testing SQL Server

Level: Intermediate

download
03:45 PMKonstantin Melamud

Transactional Replication-10 steps for successful implementation

Level: Intermediate
Craig Purnell

From 0 to Hadoop

Level: Beginner
Dustin Prescott

Hacking SQL Server - A Peek into the Dark Side

Level: Intermediate

download
Kevin Feasel

APPLY Yourself

Level: Beginner
George Squillace

All About the SSIS Catalog (SSISDB)

Level: Advanced


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
Achieving Compliance with SQL ServerCraig PurnellBeginner
All About the SSIS Catalog (SSISDB)George SquillaceAdvanced
APPLY YourselfKevin FeaselBeginner
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Change Data Capture in a Changing EnvironmentVern JewettBeginner
Determining Power and Cooling Requirements of the Data CenterJimmy DixonNon-Technical
DIY GeocodingFrank MurphyIntermediate
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
Exposing SQL data with SharePointScott BrickeyBeginner
Free Resources for SQL ServerGeorge SquillaceBeginner
From 0 to HadoopCraig PurnellBeginner
Full life-cycle of Self-Service BI with PowerPivot and the SSAS Tabular ModelAndrew HolowatyIntermediate
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
Get Near Realtime ETL with Service BrokerAllen WhiteIntermediate
Getting a job with Microsoft Paul RizzaNon-Technical
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
Hacking SQL Server - A Peek into the Dark SideDustin PrescottIntermediate
Hardening SQL ServerCraig PurnellBeginner
Indexing FundamentalsSteve HoodIntermediate
Introduction to SQL Server 2012 AlwaysOn Availability GroupsAdam BelebczukIntermediate
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Introduction to SSIS 2014Sam NasrIntermediate
Introduction to SSRS 2014Sam NasrBeginner
Making SSIS Packages Dynamic George SquillaceIntermediate
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Optimizing Protected IndexesChris BellIntermediate
Passing Microsoft Certification ExamsGeorge SquillaceBeginner
Performance Tuning - Analyzing Execution PlansKonstantin MelamudIntermediate
Performance Tuning - Index OptimizationKonstantin MelamudBeginner
Performance Tuning - TSQLKonstantin MelamudIntermediate
Policy Based Management: Introduction and ImplementationRyan BrickeyBeginner
Power BI with SQL, Excel and SharePointScott BrickeyBeginner
Self-Service BI with SSAS Daniel EvansIntermediate
SQL Audit - auditing doesn't have to be boringColleen MorrowIntermediate
SQL InjectionKevin BolesIntermediate
SSIS for the Absolute BeginnerGeorge SquillaceBeginner
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Tally 'Em UpKevin FeaselBeginner
The Automated DBA - Leveraging PowerShell to Automate DBA tasksRyan BrickeyIntermediate
The Spy Who Loathed Me - An Intro to SQL Security Chris BellBeginner
Transactional Replication-10 steps for successful implementationKonstantin MelamudIntermediate
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
Unit Testing SQL ServerKevin BolesIntermediate
Using FiletablesSam NasrIntermediate
Using Power BI - Tips and Tricks for Data Discovery, Data Visualization and Q&ADandy WeynBeginner
Using Statistical Semantic SearchSam NasrAdvanced
Using Statistical Semantic SearchSam NasrAdvanced
We Have NormalityKevin FeaselBeginner
Windowing Functions: THE Reason to Upgrade to 2012+Kevin BolesAdvanced
XML Without Xanax: How to Handle XML in SQL ServerAdam BelebczukIntermediate


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