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 1 - Room: UIndy Hall ATrack 2 - Room: UIndy Hall BTrack 3 - Room: UIndy Hall CTrack 4 - Room: Trustees A/BTrack 5 - Room: Trustees C
08:30 AMAllen White

Manage SQL Server 2012 on Server Core w/PowerShell

Level: Advanced

download
Mike Hillwig

Seven SQL Agent Jobs You Should be Running

Level: Beginner
Luke Jian

Optimizing SQL Server I/O with Solid State Drives

Level: Intermediate
Julie Smith

Data Quality Services--Finally!

Level: Beginner

download
Sanil Mhatre

Parameter sniffing - make it work for you !

Level: Intermediate

download
09:45 AMWendy Pastrick

Read Dirty to Me - Isolation Levels/User Impact

Level: Beginner
Rob Volk

Tame Your Unruly Data...With Constraints!

Level: Beginner

download
Norman Kelm

The Script Task, powerhouse of SSIS

Level: Beginner
Adam Belebczuk

SQL Server 2012 AlwaysOn Readable Secondaries

Level: Intermediate

download
Aaron King

A Complete BI Solution in About an Hour!

Level: Beginner

download
11:00 AMTed Krueger

SSIS: The DBA Multiplier

Level: Beginner
Joe McTaggart

Performance Troubleshooting Sql Server

Level: Intermediate

download
Craig Purnell

Professional Networking for IT Pros

Level: Beginner
Shaun Watts

Powershell and Perfmon...Come on!

Level: Beginner

download
Ira Whiteside

(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Level: Intermediate

download
01:00 PMArie Jones

PWNED! Security, SQL Server, and You!

Level: Intermediate
Josh Fennessy

Looking to the future - Tabular Mode SSAS

Level: Beginner
William E Pearson III

Overcoming Barriers and Avoiding Mistakes with BI

Level: Intermediate
Brent Dragoo

Database Crime Scene Investigation

Level: Intermediate
Dave Fackler

Understanding SSIS Performance

Level: Intermediate

download
02:15 PMEddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate

download
Warren Sifre

Contained DB? Did it do something wrong?

Level: Beginner

download
Wendy Pastrick

Transactional Replication 101

Level: Beginner
Kyle Neier

Powershell? Yea, but I'm a DBA!

Level: Intermediate
Aaron Lowe

Writing Professional Database Code

Level: Intermediate
03:30 PMJoe McTaggart

SQL Server and Sharepoint: Best Frienemies

Level: Intermediate

download
Kevin Boles

Parallel Query Execution Deep Dive

Level: Advanced

download
Scott Klein

SQL Azure Scalability with Federations

Level: Intermediate
Hope Foley

Consulting The Good, The Bad, The Ugly

Level: Beginner

download
Ludwig Armbruster

Introduction to the new Data Alert feature in SSRS

Level: Beginner

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
Enrique LimaIntermediate
Enrique LimaBeginner
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
A Complete BI Solution in About an Hour! Aaron KingBeginner
Administering the BI StackJosh FennessyIntermediate
Anatomy of a JoinLuke JianIntermediate
Asynchronous programming with Service BrokerSanil MhatreIntermediate
Attribute Discretization in Analysis Services (BI)William E Pearson IIIBeginner
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Becoming DAX: An Introduction ... William E Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E Pearson IIIIntermediate
Bingo.Combrave123 brave123Beginner
BLITZ! One Hour SQL Server TakeoversBrent OzarBeginner
Bridging the Chasm: BI Theory vs. PracticeWilliam E Pearson IIIIntermediate
Common TSQL MistakesKevin BolesIntermediate
Consulting The Good, The Bad, The Ugly Hope FoleyBeginner
Contained DB? Did it do something wrong?Warren SifreBeginner
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Data Quality Services--Finally!Julie SmithBeginner
Database Crime Scene InvestigationBrent DragooIntermediate
Database Development using SQL Server Data ToolsAaron LoweBeginner
Death by UDFKevin BolesIntermediate
Design and Implement BI Like Edison!William E Pearson IIIBeginner
Entity Strategies: Structuring Your ConsultancyWilliam E Pearson IIIBeginner
Extended Events 2012, The Death Knell of SQL TraceKyle NeierBeginner
File IO Stalls and Wait Stats - Tune Like Guru!Kevin BolesAdvanced
Fundamentals of Join OperationsKevin BolesBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Get Ready for SSIS in SQL Server 2012!Dave FacklerIntermediate
Getting Started with MDXWilliam E Pearson IIIBeginner
How Not to Be a Cranky DBAMike HillwigBeginner
How to Defuse Problems Like a ConsultantBrent OzarIntermediate
Indexes! Indexes! Indexes!Arie JonesIntermediate
Introduction to FileTables in SQL 2012Warren SifreBeginner
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Introduction to the new Data Alert feature in SSRSLudwig ArmbrusterBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
LinkedIn for SQL Server ProfessionalsCraig PurnellBeginner
Little in the middle but got much [Write]BackJosh FennessyIntermediate
Looking to the future - Tabular Mode SSASJosh FennessyBeginner
Manage SQL Server 2012 on Server Core w/PowerShellAllen WhiteAdvanced
Many-to-Many: Multiple Calendars in a Single CubeWilliam E Pearson IIIAdvanced
Master Data Services in SQL Server 2012Arie JonesIntermediate
Merge Replication for Offline Data MobilityTed KruegerBeginner
MS Access with SQL Server Strategies and TipsJuan SotoBeginner
My Favorite SSIS Tips and TricksDave FacklerIntermediate
New Server in an Hour? No Problem!Mike HillwigIntermediate
Optimizing SQL Server I/O with Solid State DrivesLuke JianIntermediate
Overcoming Barriers and Avoiding Mistakes with BIWilliam E Pearson IIIIntermediate
Overview of PowerPivot (for the Uninitiated ...)William E Pearson IIIBeginner
Parallel Query Execution Deep DiveKevin BolesAdvanced
Parameter sniffing - make it work for you !Sanil MhatreIntermediate
Performance Troubleshooting Sql ServerJoe McTaggartIntermediate
Performance Tuning 2012 SSIS Data LoadsHope FoleyIntermediate
PowerPivot for ExcelWilliam E Pearson IIIBeginner
Powershell and Perfmon...Come on!Shaun WattsBeginner
PowerShell, the New SQL HammerNorman KelmBeginner
Powershell? Yea, but I'm a DBA!Kyle NeierIntermediate
Professional Networking for IT ProsCraig PurnellBeginner
Project Deployment Model and SSISDB in SSIS 2012Ludwig ArmbrusterBeginner
Project Deployment Model and SSISDB in SSIS 2012Ludwig ArmbrusterBeginner
PWNED! Security, SQL Server, and You!Arie JonesIntermediate
Read Dirty to Me - Isolation Levels/User ImpactWendy PastrickBeginner
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
SAN Basics for DBAsBrent OzarBeginner
Serene Velocity: Reporting Services and SSAS DataWilliam E Pearson IIIIntermediate
Seven SQL Agent Jobs You Should be RunningMike HillwigBeginner
SQL Agent MSX Server: One Process, Many ServersMike HillwigIntermediate
SQL Azure Andy ThiruBeginner
SQL Azure Scalability with FederationsScott KleinIntermediate
SQL Azure vs. Azure Tables –Clearing The ConfusionScott KleinIntermediate
SQL InjectionKevin BolesIntermediate
SQL Server 2012 AlwaysOn Readable SecondariesAdam BelebczukIntermediate
SQL Server 2012 Column Store IndexKevin BolesIntermediate
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server and Disk IOJoe McTaggartAdvanced
SQL Server and Sharepoint: Best FrienemiesJoe McTaggartIntermediate
SQL Server Partitioning From A to ZKevin BolesAdvanced
SQL Server Security H@ck3ryNorman KelmIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS 2012 New FeaturesNorman KelmBeginner
SSIS: The DBA MultiplierTed KruegerBeginner
Take Control of Your Databases with PBM!Arie JonesIntermediate
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Script Task, powerhouse of SSISNorman KelmBeginner
The Secret Life of an INSERT StatementArgenis FernandezIntermediate
Transaction Log Deep DiveKevin BolesAdvanced
Transactional Replication 101Wendy PastrickBeginner
Understanding SSIS PerformanceDave FacklerIntermediate
Unit Testing made easy for Database Development Sanil MhatreBeginner
Upgrade Roadmap: Let’s delve into SQL Server 2012 Craig PurnellIntermediate
Using MS Access as a BI Tool with SQL ServerJuan SotoIntermediate
What? I can't buy [Vendor]'s Monitoring Package?!?Kyle NeierIntermediate
What's this cache and how did it get so big?Douglas BrendleIntermediate
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Writing Professional Database CodeAaron LoweIntermediate
Your First Performance Tuning ClassBrent OzarIntermediate
Your First SQL Internals ClassBrent OzarIntermediate


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