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 1 - Room: Room 4BI 2 - Room: Room 5DBA 1 - Room: Room 1DBA 2 - Room: Room 2Dev - Room: Room 3Prof. Dev - Room: Room 6
08:00 AMSQLSaturday 233

Registration Opens

Level: Non-Technical
SQLSaturday 233

Registration Opens

Level: Non-Technical
SQLSaturday 233

Registration Opens

Level: Non-Technical
SQLSaturday 233

Registration Opens

Level: Non-Technical
SQLSaturday 233

Registration Opens

Level: Non-Technical
SQLSaturday 233

Registration Opens

Level: Non-Technical
08:30 AMStacia Misner

(Way Too Much) Fun with Reporting Services

Level: Beginner
Andy Leonard

Using BIML as an SSIS Design Patterns Engine

Level: Advanced
Allan Hirt

SQL Server Dos and Don'ts: Keys to DBA Nirvana

Level: Beginner
Andrew Kelly

Policy-Based Management and Central Management Server

Level: Intermediate

download
Carlos Chacon

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

Level: Beginner
Melissa Demsak

Data Career Paths and Decision Making Strategies

Level: Non-Technical
09:30 AMThe Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
9:45 AMKevin Goff

SQL Server 2012 Columnstore index

Level: Intermediate
Kevin Hazzard

Change Data Capture & Change Tracking Deep Dive

Level: Advanced
Konstantin Melamud

Performance Tuning - Index Optimization

Level: Beginner
David Klee

Squeezing Performance from VMware-Based SQL Server

Level: Intermediate

download
Slava Murygin

Best SQL Server Programming practices

Level: Beginner

download
Brian Kelley

Being the Swiss Army Knife of DB Pros

Level: Beginner

download
10:45 AMThe Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
The Bean Bag

SQLSaturday 233 - Coffee Bar Open!

Level: Non-Technical
11:00 AMSamuel Vanga

Merge Dimensions Ahead

Level: Intermediate
Paul Rizza

ETL not ELT! Common mistakes and misconceptions about SSIS

Level: Advanced
Ayman El-Ghazali

SQL Server Backup and Recovery Fundamentals

Level: Beginner

download
Jason Brimhall

SQL 2012 Extended Events

Level: Advanced
Wayne Sheffield

Crazy Things That Developers Do, Part I

Level: Beginner

download
Mike Walsh

Never Have to Say "Mayday!!!" Again

Level: Beginner
12:00 PMSQLSaturday 233

Lunch Break

Level: Non-Technical
SQLSaturday 233

Lunch Break

Level: Non-Technical
Dave Bermingham Jason Smith

SIOS Lunch Presentation - High Performance SANLess Clustering

Level: Non-Technical
SQLSaturday 233

Lunch Break

Level: Non-Technical
SQLSaturday 233

Lunch Break

Level: Non-Technical
SQLSaturday 233

Lunch Break

Level: Non-Technical
02:00 PMMark Hudson

Making Predictions with Microsoft Data Mining Tools

Level: Intermediate

download
David Dye

Dealing With Errors in SSIS 2012

Level: Advanced
Joseph D'Antoni

Using Compression to Improve Database Performance

Level: Intermediate
Robert Pearl

HealthySQL

Level: Beginner
Kevin Boles

Indexing Deep Dive

Level: Advanced

download
Steve Jones

Branding Yourself for a Dream Job

Level: Beginner

download
03:00 PMSQLSaturday 233

Coffee Break

Level: Non-Technical
SQLSaturday 233

Coffee Break

Level: Non-Technical
SQLSaturday 233

Coffee Break

Level: Non-Technical
SQLSaturday 233

Coffee Break

Level: Non-Technical
SQLSaturday 233

Coffee Break

Level: Non-Technical
SQLSaturday 233

Coffee Break

Level: Non-Technical
03:15 PMTim Radney

It is TEMPDB, Why Should You Care?

Level: Intermediate

download
Jessica Moss

Data Warehouse ETL Rollback with SSIS 2012

Level: Advanced
Timothy McAliley

A Walk Around the SQL Server 2014 Audit Feature

Level: Intermediate

download
Adam Belebczuk

Introduction to SQL Server 2012 AlwaysOn Availability Groups

Level: Intermediate

download
Grant Fritchey

Tune Queries By Fixing Bad Parameter Sniffing

Level: Intermediate
Brian Moran

Workplace Coaching: Simple Skills that Change Everything

Level: Non-Technical
04:30 PMSQLSaturday 233

Raffle

Level: Non-Technical
SQLSaturday 233

Raffle

Level: Non-Technical
SQLSaturday 233

Raffle

Level: Non-Technical
SQLSaturday 233

Raffle

Level: Non-Technical
SQLSaturday 233

Raffle

Level: Non-Technical
SQLSaturday 233

Raffle

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
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
(Way Too Much) Fun with Reporting Services Stacia MisnerBeginner
12 Steps to Workload TuningJohn SterrettBeginner
14 New T-SQL FunctionsSam NasrIntermediate
A Big Data PrimerStacia MisnerBeginner
A Walk Around the SQL Server 2014 Audit FeatureTimothy McAlileyIntermediate
Advanced Tabular DevelopmentChris SchmidtAdvanced
Automate your daily checklist with PBM and CMSJohn SterrettIntermediate
Being the Swiss Army Knife of DB ProsBrian KelleyBeginner
Best SQL Server Programming practicesSlava MuryginBeginner
Biml for Fun and Profit with SSISSamuel VangaIntermediate
Branding Yourself for a Dream JobSteve JonesBeginner
Branding Yourself for a Dream JobSteve JonesBeginner
Building an Infrastructure for Secure SQL ServersBrian KelleyBeginner
Business Continuity: The Real Reason for HA and DRAllan HirtBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Change Data Capture & Change Tracking Deep DiveKevin HazzardAdvanced
Coffee BreakSQLSaturday 233Non-Technical
Column Level EncryptionDavid DyeBeginner
Crazy Things That Developers Do, Part IWayne SheffieldBeginner
Crazy Things That Developers Do, Part IIWayne SheffieldBeginner
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Creating an Extensible Data Quality FoundationKevin HazzardIntermediate
Data Career Paths and Decision Making StrategiesMelissa DemsakNon-Technical
Data Warehouse ETL Rollback with SSIS 2012Jessica MossAdvanced
Database Backups for the Accidental DBAGrant FritcheyBeginner
Database Design Disasters: Common Mistakes Found in the WildRichie RumpIntermediate
Database Health and PerformanceDavid KleeIntermediate
Database Health and PerformanceDavid KleeIntermediate
Dealing With Errors in SSIS 2012David DyeAdvanced
Deploying Highly Available SQL Servers in the Amazon EC2 CloudDavid BerminghamIntermediate
DQS: Business logic meets integrationChris SchmidtBeginner
Entity Framework: Or How I Learned to Stop Worrying and Learned to Love DevelopersRichie RumpIntermediate
ETL not ELT! Common mistakes and misconceptions about SSISPaul RizzaAdvanced
Exploring The Microsoft Reporting TechnologiesDavid OrtizBeginner
Floating on a Hybrid Cloud: SQL Server 2014 & Windows Azure Timothy McAlileyIntermediate
Full-Text Search in SQL 2012 with Custom ProximitySam NasrIntermediate
G.I.G.O. (Garbage In Garbage Out) - Data Quality For DummiesDavid OrtizBeginner
Hacking the SSIS 2012 CatalogAndy LeonardBeginner
HealthySQL Robert PearlBeginner
How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise EditionDon Boxley JrIntermediate
Implementing a HIPAA Compliance Strategy with SQL ServerBrandon LeachBeginner
Implementing Auditing in SQL Server 2012David DyeBeginner
Implementing Data Warehouse Patterns with the Microsoft BI ToolsKevin GoffIntermediate
Indexing Deep DiveKevin BolesAdvanced
Inside of IndexesSlava MuryginIntermediate
Integrating Reporting Services with SharePointKevin GoffIntermediate
Internal Structure of SQL DBSlava MuryginAdvanced
Interrogating the Transaction Log Frank GillIntermediate
Into the Wild:Taming Unstructured DataChristopher PriceBeginner
Introducing DAXChris SchmidtBeginner
Introducing DAXChris SchmidtBeginner
Introducing Power BIStacia MisnerBeginner
Introduction to SQL Server 2012 AlwaysOn Availability GroupsAdam BelebczukIntermediate
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Introduction to SSIS 2012Sam NasrIntermediate
Introduction to SSRS 2012Sam NasrBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
It's All About the Performance, Right?David KleeIntermediate
Judge, Jury, and Executioner--A First Look At Execution PlansCarlos ChaconBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
Lights, Camera, Action: Creating and Delivering Technical PresentationsJessica MossNon-Technical
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Lunch BreakSQLSaturday 233Non-Technical
Make your junky code less junkyWilliam WolfBeginner
Making Predictions with Microsoft Data Mining ToolsMark HudsonIntermediate
MDS in Practice: An Integrated ApproachChristopher PriceBeginner
Merge Dimensions AheadSamuel VangaIntermediate
Microsoft Power BI: Your first RoadmapMelissa DemsakBeginner
Minions and MeKonstantin MelamudBeginner
Never Have to Say "Mayday!!!" AgainMike WalshBeginner
OnPremise to AzureShannon LowderIntermediate
Patch Management Strategies for SQL ServerAllan HirtBeginner
Performance Tuning - Analyzing Execution PlansKonstantin MelamudIntermediate
Performance Tuning - Index OptimizationKonstantin MelamudBeginner
Policy-Based Management and Central Management Server Andrew KellyIntermediate
Put Your Data on the MapMark HudsonBeginner
RaffleSQLSaturday 233Non-Technical
Registration OpensSQLSaturday 233Non-Technical
Searching Binary Data in SQL Server 2012Steve JonesIntermediate
Self Service BI using Office 2013 and SQL 2012Akesh GuptaIntermediate
Server Application Virtualization - Picking Up Where Server Virtualization Leaves OffDon Boxley JrNon-Technical
SIOS Lunch Presentation - High Performance SANLess ClusteringDave Bermingham Jason SmithNon-Technical
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL 2012 Table CompressionJason BrimhallAdvanced
SQL InjectionKevin BolesIntermediate
SQL Server 2012 AlwaysOn Step-by-StepDavid BerminghamIntermediate
SQL Server 2012 Columnstore indexKevin GoffIntermediate
SQL Server 2014 Column Store Index vNEXTKevin BolesAdvanced
SQL Server 2014 Hekaton Deep DiveKevin BolesAdvanced
SQL Server Backup and Recovery FundamentalsAyman El-GhazaliBeginner
SQL Server Dos and Don'ts: Keys to DBA NirvanaAllan HirtBeginner
SQL Server Encryption Decrypted Brian KelleyIntermediate
SQL Server ForensicsBrian KelleyBeginner
SQL Server Index InternalsTim ChapmanAdvanced
SQL Server Indexing FundamentalsAyman El-GhazaliBeginner
SQL Server Integration Services RecipesSamuel VangaBeginner
SQL Server Internals Party: Storage, Memory and the Query Life-cycleAyman El-GhazaliBeginner
SQL Server Reporting Services, attendees chooseKevin GoffIntermediate
SQL Server Transaction Log InternalsTim ChapmanAdvanced
SQL2012 Query & Procedure Call Statistics Andrew KellyIntermediate
SQLSaturday 233 - Coffee Bar Open!The Bean BagNon-Technical
Squeezing Performance from VMware-Based SQL ServerDavid KleeIntermediate
SSAS 911 - The Field Medic's Guide to Performance Tuning Analysis ServicesChristopher PriceAdvanced
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettBeginner
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Taking BI to the Next Level: CollaborationStacia MisnerBeginner
Team-based Database Development with Source ControSteve JonesBeginner
The BI Guys Little Guide to Big DataChristopher PriceIntermediate
The Cheap Replica: Offloading with Transactional ReplicationJohn SterrettBeginner
The Encryption PrimerSteve JonesBeginner
The Encryption PrimerSteve JonesBeginner
The new tabular model in Analysis Services 2012Kevin GoffIntermediate
The T-SQL Features in SQL Server 2012 You Can't IgnoreRichie RumpIntermediate
Tools to Make Multi-Object Administration EasierFrank GillIntermediate
Troubleshoot SQL Server Issues like a Microsoft EngineerTim ChapmanAdvanced
T-SQL for Application Developers - Attendees choseKevin GoffIntermediate
Tune Queries By Fixing Bad Parameter Sniffing Grant FritcheyIntermediate
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using Compression to Improve Database PerformanceJoseph D'AntoniIntermediate
Using FiletablesSam NasrIntermediate
Using Powershell to Monitor GoldenGate ReplicationAmy HeroldIntermediate
Using Statistical Semantic SearchSam NasrAdvanced
WellDBA: Performance Root Cause Analysis in 10 MinutesJohn SterrettBeginner
What Can Data Quality Services Do for You?Mark HudsonBeginner
What's in the SQL Server 2012 Business Intelligence Suite?Jessica MossBeginner
Whats New in T-SQL With SQL Server 2012David DyeBeginner
Why OLAP? Building SSAS cubes and benefits of OLAPKevin GoffIntermediate
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Workplace Coaching: Simple Skills that Change EverythingBrian MoranNon-Technical
Wrangling performance with Resource GovernorBrandon LeachBeginner
You Inherited a Database, Now What?Tim RadneyBeginner
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