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 TimeBig Data/Azure/BI - Room: SWANG 100BONUS Sessions - Room: SWANG 244Business Intelligence - Room: SWANG 114DBA - Room: SWANG 110DEV - Room: SWANG 112DEV/DBA Misc - Room: SWANG 116Professional Development - Room: SWANG 104Spotlight Sessions - Room: SWANG 108
8:00 AMRuss Loski

Introduction to BIML and BIMLScript

Level: Intermediate

download
Joe Settles

Change Data Capture for Developers and DBAs

Level: Intermediate

download
Brett Tomson

ETL in a Nutshell with SSIS

Level: Beginner

download
Chris Skorlinski

Check Engine Lights

Level: Intermediate

download
Wendy Pastrick

Read Dirty to Me - Isolation Levels/User Impact

Level: Beginner

download
Richie Rump

Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Level: Intermediate

download
Geoff Hiten

Smart Rats Leave First

Level: Non-Technical
Allen White

Automate Your ETL Infrastructure with SSIS and PowerShell

Level: Intermediate

download
09:15 AMJosh Fennessy

Visual Analytics with HDInsight and Power View

Level: Beginner

download
David Maxwell

DBA 911 - Database Corruption

Level: Beginner

download
Aaron Crouch

BizTalk and SQL Server: EDI Made Simple

Level: Beginner
Robert Verell

Know Your Role(s)!

Level: Intermediate

download
Aaron Nelson

SQL Server Database Development with SSDT

Level: Intermediate
Rob Volk

Harvesting Web Data Using Data Explorer and XML

Level: Beginner
Kevin Kline

Team Leadership Fundamentals

Level: Beginner
Tim Radney

You Inherited a Database, Now What?

Level: Beginner

download
10:30 AMStuart Ainsworth

Working with "Biggish Data"

Level: Beginner

download
Mark Scott

Supercharge Microsoft BI with Pyramid Analytics

Level: Intermediate
Bill Anton

The 20-Minute Tabular Model

Level: Beginner

download
Carlos Chacon

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

Level: Beginner
Mike Hays

Trace Flags for Developers

Level: Beginner
Joseph D'Antoni

Using Compression to Improve Database Performance

Level: Intermediate

download
Joe Webb

Scaling Up Through Delegation

Level: Beginner
Kathi Kellenberger

Writing Better T-SQL Queries with Window Functions

Level: Advanced

download
11:30 AM   Denny Cherry

SANLess Clustering on the Ground and In the Cloud

Level: Beginner
Stephen LeRoy

"Flash 101 – An Introduction to Flash Storage for MS SQL Server and Data Centers."

Level: Intermediate
Wendy Pastrick

Women In Technology Roundtable

Level: Beginner
  
1:00 PMBrian Davis

SSIS Templates Can Make Your Life Easier

Level: Beginner

download
Joseph D'Antoni

In-Memory Columnstore Indexes--Make Your Data Warehouse Fly

Level: Intermediate

download
Dave Mattingly

Master Data Management

Level: Beginner

download
David Klee

SQL Server Virtualization 101

Level: Beginner

download
Kathi Kellenberger

T-SQL Window Function Performance

Level: Advanced

download
Ed Watson

Backup Strategies are for Losers!

Level: Beginner
Stuart Ainsworth

Managing a Technical Team: Lessons Learned

Level: Beginner

download
Hope Foley

My SQL Server is Not Slow for Pete's Sake! - Server Side Performance Analysis

Level: Beginner

download
02:15 PMRuss Loski

SSRS data driven subscription using SSIS

Level: Advanced

download
Tim Radney

Know Backups and Know Recovery

Level: Intermediate

download
Kerry Tyler

Manageable SSAS Deployment Strategies

Level: Beginner

download
Janis Griffin

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

Level: Intermediate

download
Leonard Lobel

Geospatial Data Types in SQL Server 2012

Level: Intermediate

download
David Dye

Column Level Encryption

Level: Beginner

download
Chris Skorlinski

Your Best Interview Ever

Level: Beginner

download
Denny Cherry

Index Internals

Level: Advanced
3:30 PMBill Anton

Bus Matrix – The Foundation of your Dimensional DW

Level: Beginner

download
Jason Hall

5 Common SQL Server Performance Issues

Level: Intermediate

download
Virginia Mushkatblat

Data Flow Architectures in Software Development Life-Cycle

Level: Intermediate

download
Jason Wolfkill

"Mayday!": Applying Lessons Learned from Airline Disasters to Avoid Database Disasters

Level: Non-Technical

download
Adam Belebczuk

XML Without Xanax: How to Handle XML in SQL Server

Level: Intermediate

download
miguel cebollero

Database Development Comes out of the Dark Ages

Level: Intermediate

download
Joseph D'Antoni

Taking Your IT Career to the Next Level

Level: Beginner
Daniel Evans

Self-Service BI with SSAS Multi-Dim

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
"Flash 101 – An Introduction to Flash Storage for MS SQL Server and Data Centers."Stephen LeRoyIntermediate
Consulting The Good, The Bad, The UglyHope FoleyNon-Technical
"Mayday!": Applying Lessons Learned from Airline Disasters to Avoid Database DisastersJason WolfkillNon-Technical
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
5 Common SQL Server Performance IssuesJason HallIntermediate
A heap of clustersAmi LevinAdvanced
Autogenerating a process data warehouseKennie PontoppidanAdvanced
Automate Your ETL Infrastructure with SSIS and PowerShellAllen WhiteIntermediate
Backup Strategies are for Losers!Ed WatsonBeginner
BizTalk and SQL Server: EDI Made SimpleAaron CrouchBeginner
Building On-Demand SQL Dev/Test Environments in the Cloud with Windows AzureKeith MayerIntermediate
Bus Matrix – The Foundation of your Dimensional DWBill AntonBeginner
Change Data Capture for Developers and DBAs Joe SettlesIntermediate
Check Engine LightsChris SkorlinskiIntermediate
Cloudy with a Chance of DataGeoff HitenIntermediate
Column Level EncryptionDavid DyeBeginner
Crazy Things That Developers DoWayne SheffieldBeginner
Data Flow Architectures in Software Development Life-CycleVirginia MushkatblatIntermediate
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Database Design Disasters: Common Mistakes Found in the WildRichie RumpIntermediate
Database Development Comes out of the Dark Agesmiguel cebolleroIntermediate
Database Development with SQL Server Data ToolsLeonard LobelIntermediate
DAX vs MDX Smackdown!Damu Venkatesan & Neal WaterstreetIntermediate
DBA 911 - Database CorruptionDavid MaxwellBeginner
Dealing With Errors in SSIS 2012David DyeAdvanced
Developers vs. DBA's: Cats & DogsDavid MoutrayIntermediate
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love DevelopersRichie RumpIntermediate
ETL in a Nutshell with SSISBrett TomsonBeginner
Failure Lab: An exploration into the benefits of failingJosh FennessyNon-Technical
First Normal FormDavid MoutrayBeginner
Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issuesJanis GriffinIntermediate
Geospatial Data Types in SQL Server 2012Leonard LobelIntermediate
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
Hacking the SSIS 2012 CatalogAndy LeonardBeginner
Harvesting Web Data Using Data Explorer and XMLRob VolkBeginner
Implementing Auditing in SQL Server 2012David DyeBeginner
Index InternalsDenny CherryAdvanced
Index Performance Tuning with Dynamic Management ViewsDavid MaxwellBeginner
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Joseph D'AntoniIntermediate
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Introduction to SQL Server 2012 AlwaysOn Availability GroupsAdam BelebczukIntermediate
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Introduction to the XML sourceRuss LoskiIntermediate
I've Got A SQL Database, Now What?Denny CherryBeginner
Judge, Jury, and Executioner--A First Look At Execution PlansCarlos ChaconBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
Know Your Role(s)!Robert VerellIntermediate
Lunch Session: Clusters Your Way - #SANLess clusters for physical, virtual & cloud environmentsSIOS Technology Corp. and Tim RadneyNon-Technical
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Manageable SSAS Deployment StrategiesKerry TylerBeginner
Managing a Technical Team: Lessons LearnedStuart AinsworthBeginner
Master Data ManagementDave MattinglyBeginner
My SQL Server is Not Slow for Pete's Sake! - Server Side Performance Analysis Hope FoleyBeginner
Native File Streaming with SQL Server 2012Leonard LobelIntermediate
Navigating the Options for Data RedundancyWendy PastrickIntermediate
Partitioning as a design patternKennie PontoppidanAdvanced
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Physical Join OperatorsAmi LevinAdvanced
Power This, Power That...Making Sense of Power BIBrett TomsonBeginner
Programming T-SQL Enhancements in SQL Server 2012Leonard LobelIntermediate
Read Dirty to Me - Isolation Levels/User ImpactWendy PastrickBeginner
Read Dirty to Me - Isolation Levels/User ImpactWendy PastrickBeginner
Revenge: The SQL!Rob VolkIntermediate
SANLess Clustering on the Ground and In the Cloud Denny CherryBeginner
Scaling Up Through DelegationJoe WebbBeginner
Securing Semantic Models: Real World ScenariosBrett TomsonIntermediate
Self-Service BI with SSAS Multi-DimDaniel EvansIntermediate
Smart Rats Leave FirstGeoff HitenNon-Technical
SQL anti patternsKennie PontoppidanAdvanced
SQL Server Database Development with SSDT Aaron NelsonIntermediate
SQL Server Internals and ArchitectureKevin KlineIntermediate
SQL Server Table Partitioning from the ground upDenny CherryIntermediate
SQL Server Virtualization 101David KleeBeginner
SQL Server's In Memory Database ObjectsDenny CherryIntermediate
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeBeginner
SSIS Log Providers, Custom Logging, and Event HandlersDavid DyeBeginner
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
SSRS data driven subscription using SSISRuss LoskiAdvanced
Supercharge Microsoft BI with Pyramid AnalyticsMark ScottIntermediate
Table Indexing for the .NET DeveloperDenny CherryIntermediate
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Taking Your IT Career to the Next LevelJoseph D'AntoniBeginner
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
Team Leadership FundamentalsKevin KlineBeginner
The 20-Minute Tabular ModelBill AntonBeginner
The Agile DBA: Managing your To-Do ListStuart AinsworthBeginner
The Elephant in the Room; A DBA's Guide to Hadoop & Big DataStuart AinsworthBeginner
The T-SQL Features in SQL Server 2012 You Can't IgnoreRichie RumpIntermediate
Things That Make You Go "D'Oh!": T-SQL Trip-Ups, Traps, and GotchasJason WolfkillBeginner
Top 10 Admininistrator Mistakes on SQL ServerKevin KlineBeginner
Trace Flags for DevelopersMike HaysBeginner
Troubleshooting Your Network ConnectionsMike HaysBeginner
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
T-SQL Window Function PerformanceKathi KellenbergerAdvanced
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using Compression to Improve Database PerformanceJoseph D'AntoniIntermediate
Visual Analytics with HDInsight and Power ViewJosh FennessyBeginner
What's in my database? Information Schema and catalog viewsRuss LoskiBeginner
Where did I put my (primary) keys?Ami LevinAdvanced
Where the Fish Are: Becoming a Better DeveloperDavid MoutrayBeginner
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Women In Technology RoundtableWendy PastrickBeginner
Working with "Biggish Data"Stuart AinsworthBeginner
Writing Better T-SQL Queries with Window FunctionsKathi KellenbergerAdvanced
XML Without Xanax: How to Handle XML in SQL ServerAdam BelebczukIntermediate
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.

SQLSaturday Home
PASS