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 TimeBI - Room: Room 2DBA - Room: Room 3Dev - Room: Room 1Wildcard 1 - Room: Room 4Wildcard 2 - Room: Room 5
09:00 AMChristopher Campbell

Big Data Trends with the Microsoft Parallel Data Warehouse

Level: Intermediate
Rick Brewis

SQL Server 2014 - In-Memory OLTP

Level: Intermediate
Dustin Prescott

Hacking SQL Server - A Peek into the Dark Side

Level: Advanced

download
John Gayer

SQL Server 2014 Managed Backup to Windows Azure

Level: Intermediate

download
Mark Wilkinson

What Just Happened? Why You Need to Constantly Monitor Your Environment

Level: Beginner

download
10:15 AMMichael Schulte

Extending SQL Server with Advanced Analytics and R

Level: Beginner
Allen White

Automate Your ETL Infrastructure with SSIS and PowerShell

Level: Intermediate

download
Grant Fritchey

Building a Database Deployment Pipeline

Level: Intermediate
Mike Hays

Troubleshooting Your Network Connections

Level: Beginner

download
Brian Davis

Getting Started with Hekaton (In-Memory OLTP)

Level: Beginner
12:30 PMGinger Grant

The Sqoop on Big Data from it’s humble beginnings to rise to notoriety

Level: Beginner
Jeff Moden

Partitioning System for "WORM" Tables

Level: Advanced

download
Gill Rowley

Dynamic Connections in SSIS

Level: Intermediate
David Klee

How to Argue with Your Infrastructure Admins – and Win

Level: Intermediate

download
Craig Purnell

Achieving Compliance with SQL Server

Level: Beginner
1:45 PMGeorge Squillace

All About the SSIS Catalog (SSISDB)

Level: Advanced
Jeff Moden

Partitioning System for "WORM" Tables

Level: Advanced

download
Grant Fritchey

Getting Started Reading Execution Plans

Level: Intermediate
Tim Ford

The Most Important Dynamic Management Objects for New DBAs

Level: Beginner
Ginger Grant

Power BI – Cloud Self-Service BI

Level: Beginner
3:00 PMBrian Davis

SSIS Templates Can Make Your Life Easier

Level: Beginner
Colleen Morrow

SQL Audit - auditing doesn't have to be boring

Level: Intermediate

download
Tom Groszko

T-SQL For Beginning Developers

Level: Beginner
Gill Rowley

You're the DBA. Now What?

Level: Beginner
Frank Murphy

DIY Geocoding

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
Achieving Compliance with SQL ServerCraig PurnellBeginner
All About the SSIS Catalog (SSISDB)George SquillaceAdvanced
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Big Data Trends with the Microsoft Parallel Data WarehouseChristopher CampbellIntermediate
Building a Database Deployment PipelineGrant FritcheyIntermediate
Data Quality Issues? There is a service for that.Ginger GrantIntermediate
DIY GeocodingFrank MurphyIntermediate
Dynamic Connections in SSISGill RowleyIntermediate
Extending SQL Server with Advanced Analytics and RMichael SchulteBeginner
FINALLY! An easy way to KILL a hung xp_CmdShell SPID!Jeff ModenIntermediate
Free Resources for SQL ServerGeorge SquillaceBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started Reading Execution PlansGrant FritcheyIntermediate
Getting Started with Hekaton (In-Memory OLTP)Brian DavisBeginner
Hacking SQL Server - A Peek into the Dark SideDustin PrescottAdvanced
How to Argue with Your Infrastructure Admins – and WinDavid KleeIntermediate
Inside Transactional ReplicationPrabhakaran BhaskaranIntermediate
Making SSIS Packages Dynamic George SquillaceIntermediate
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Partitioning System for "WORM" TablesJeff ModenAdvanced
Passing Microsoft Certification ExamsGeorge SquillaceBeginner
Power BI – Cloud Self-Service BIGinger GrantBeginner
Query Tuning Superstardom for BeginnersTim FordBeginner
Self-Service BI with SSAS Daniel EvansIntermediate
SQL Audit - auditing doesn't have to be boringColleen MorrowIntermediate
SQL Server 2014 - In-Memory OLTPRick BrewisIntermediate
SQL Server 2014 Managed Backup to Windows AzureJohn GayerIntermediate
SQL Server for the accidental DBA Craig PurnellBeginner
SQL Server Virtualization 101David KleeBeginner
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeIntermediate
SSIS for the Absolute BeginnerGeorge SquillaceBeginner
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Statistics and Query OptimizationGrant FritcheyIntermediate
The Most Important Dynamic Management Objects for New DBAsTim FordBeginner
The Sqoop on Big Data from it’s humble beginnings to rise to notorietyGinger GrantBeginner
Trace Flags for DevelopersMike HaysBeginner
Troubleshooting Your Network ConnectionsMike HaysBeginner
T-SQL For Beginning DevelopersTom GroszkoBeginner
Upgrade Roadmap: Let’s delve into SQL Server 2012 Craig PurnellIntermediate
What Just Happened? Why You Need to Constantly Monitor Your EnvironmentMark WilkinsonBeginner
You're the DBA. Now What?Gill RowleyBeginner


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