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 Time114/115 - Room: 114/115LL13 - Room: LL13LL15 - Room: LL15LL16 - Room: LL16LL2 - Room: LL2LL5 - Room: LL5LL9 - Room: LL9
8:30 AMSQLSaturday 164

Welcome

Level: Beginner
SQLSaturday 164

Welcome

Level: Beginner
SQLSaturday 164

Welcome

Level: Beginner
SQLSaturday 164

Welcome

Level: Beginner
SQLSaturday 164

Welcome

Level: Beginner
SQLSaturday 164

Welcome

Level: Beginner
SQLSaturday 164

Welcome

Level: Beginner
08:45 AMLouis Davidson

Designing for Common Problems in SQL Server

Level: Intermediate

download
Arie Jones

Strategies for Sharding with SQL Azure Federations

Level: Intermediate

download
Lisa Gardner

SQL Server and Sharepoint: Best Frienemies

Level: Intermediate

download
Rob Kerr

Designing Tabular BI Semantic Models

Level: Intermediate

download
Allen White

Sets and Relations and Queries, Oh My!

Level: Beginner

download
Andy Warren

Building Your Professional Development Plan

Level: Beginner
Kendal Van Dyke

Transactional Replication: Beyond The Basics

Level: Beginner

download
10:00 AMAndy Warren

SQL Server Security for Developers

Level: Beginner
Adam Belebczuk

Introduction to SQL Server Service Broker

Level: Beginner

download
Josh Fennessy

Administering the BI Stack

Level: Intermediate

download
Rob Kerr

Designing a SQL 2012 BI Architecture

Level: Beginner

download
Cory Stevenson

Getting Started with Report Services: The Setup

Level: Beginner

download
Matt Velic

Communicate for Great Good!

Level: Beginner

download
Colleen Morrow

Searching for the Holy Grail of DDL Auditing

Level: Beginner

download
11:15 AMThomas LaRock

Database Design Throwdown

Level: Intermediate
Shelly Noll

NoSQL: Know Your Enemy

Level: Beginner

download
Joseph D'Antoni

SQL 2012 -- All About HA and DR

Level: Intermediate

download
Ira Whiteside

Creating a Metadata Mart w/ SSIS - Data Governance

Level: Intermediate
Jason Spangler

Profiler? What is this tool you speak of?

Level: Beginner
Eric Wise

Building a Better Development Shop

Level: Beginner

download
Steven Wright

Shade Tree Mechanic's Guide to SSAS

Level: Beginner

download
12:30 PMSQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
SQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
SQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
SQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
SQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
SQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
SQLSaturday 164

Lunch and Vendor Sessions!

Level: Beginner
01:30 PMLouis Davidson

What Sequence objects are (and are not)

Level: Intermediate

download
Austin Zellner

Conquering ETL Projects

Level: Beginner
Eddie Wuerch

Page Latches for Mere Mortals

Level: Intermediate
David Eichner

Overview of PowerPivot

Level: Beginner
Timothy Corey

Before You Optimize: Understanding Execution Plans

Level: Beginner

download
Craig Purnell

LinkedIn for SQL Server Professionals

Level: Beginner
Kendal Van Dyke

Building Your Own SQL Server Virtual Playground

Level: Intermediate

download
02:45 PMJeff Moden

Hierarchies... on Steroids the No RBAR Way

Level: Intermediate

download
Jeff Mlakar

Migrating to and Integrating with SQL Azure

Level: Beginner

download
Joseph D'Antoni

Way Too Deep--Inside AlwaysOn

Level: Advanced

download
Stacia Misner

Data Visualization in Reporting Services

Level: Beginner
Kevin Boles

Fundamentals of Join Operations

Level: Beginner

download
Colleen Morrow

So I started this blog... now what?

Level: Beginner

download
Steven Wright

Resource Governor for SQL Server

Level: Intermediate

download
04:00 PMAllen White

Panel Discussion: Managing Your Career

Level: Beginner
Sam Nasr

14 New T-SQL Functions

Level: Intermediate

download
Brian Davis

Goodbye Next Next Next, Hello Automated Installs

Level: Intermediate
Stacia Misner

(Way Too Much) Fun with Reporting Services

Level: Beginner
Dave Rodabaugh

Factors for Successful Business Intelligence

Level: Beginner

download
Kevin Boles

SQL Injection

Level: Intermediate

download
Eddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate
5:00 PMSQLSaturday 164

Prize giveaway and wrap up

Level: Beginner
SQLSaturday 164

Prize giveaway and wrap up

Level: Beginner
SQLSaturday 164

Prize giveaway and wrap up

Level: Beginner
SQLSaturday 164

Prize giveaway and wrap up

Level: Beginner
SQLSaturday 164

Prize giveaway and wrap up

Level: Beginner
SQLSaturday 164

Prize giveaway and wrap up

Level: Beginner
SQLSaturday 164

Prize giveaway and wrap up

Level: Beginner


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
100x query performance improvement with xVelocityRob KerrIntermediate
14 New T-SQL FunctionsSam NasrIntermediate
Administering the BI StackJosh FennessyIntermediate
An Introduction to Master DataCarlton RamseyBeginner
Before You Optimize: Understanding Execution PlansTimothy CoreyBeginner
BI: Fact Table Modeling – Real World Case Study inChris UmbaughBeginner
Building a Better Development ShopEric WiseBeginner
Building Your Own SQL Server Virtual PlaygroundKendal Van DykeIntermediate
Building Your Professional Development PlanAndy WarrenBeginner
Cancel Your Plans!Mike HillwigIntermediate
Coding to Interfaces in the Data LayerEric WiseIntermediate
Communicate for Great Good!Matt VelicBeginner
Conquering ETL ProjectsAustin ZellnerBeginner
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Cross Tabs & Pivots - Reports on SteroidsJeff ModenIntermediate
Data Visualization in Reporting ServicesStacia MisnerBeginner
Database Design ThrowdownThomas LaRockIntermediate
Death by UDFKevin BolesIntermediate
Designing a SQL 2012 BI ArchitectureRob KerrBeginner
Designing a SQL 2012 BI ArchitectureRob KerrBeginner
Designing for Common Problems in SQL Server Louis DavidsonIntermediate
Designing Tabular BI Semantic ModelsRob KerrIntermediate
DMVs- What are they and why should a DBA care? Paul HilesBeginner
Evaluate your daily Checklist with PBM and CMSJohn SterrettIntermediate
Factors for Successful Business IntelligenceDave RodabaughBeginner
File IO Stalls and Wait Stats - Tune Like Guru!Kevin BolesAdvanced
Full Text Search for Names DataJay HollidayIntermediate
Fundamentals of Join OperationsKevin BolesBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started with Report Services: The SetupCory StevensonBeginner
Getting Started with SSRS: Your First ReportCory StevensonBeginner
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
Hierarchies... on Steroids the No RBAR WayJeff ModenIntermediate
How Not to Be a Cranky DBAMike HillwigBeginner
Intro to Oracle PL/SQL for the T-SQL ProfessionalJeff MlakarBeginner
Introduction to LocalDBSam NasrBeginner
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
LinkedIn for SQL Server ProfessionalsCraig PurnellBeginner
Looking to the future - Tabular Mode SSASJosh FennessyBeginner
LunchErin StellatoBeginner
Lunch and Vendor Sessions!SQLSaturday 164Beginner
Manage SQL Server 2012 with PowerShell and CoreAllen WhiteIntermediate
Master Data Services in SQL Server 2012Arie JonesIntermediate
Migrating to and Integrating with SQL AzureJeff MlakarBeginner
New Server in an Hour? No Problem!Mike HillwigIntermediate
NoSQL: Know Your EnemyShelly NollBeginner
Overview of PowerPivotDavid EichnerBeginner
Page Latches for Mere MortalsEddie WuerchIntermediate
Panel Discussion: Managing Your CareerAllen WhiteBeginner
Parallel Query Execution Deep DiveKevin BolesAdvanced
Performance Tuning for PiratesJohn SterrettAdvanced
Power View: A Peek Behind the CurtainStacia MisnerBeginner
Power View: visual self-service data explorationRob KerrBeginner
Prize giveaway and wrap upSQLSaturday 164Beginner
Professional Networking for IT ProsCraig PurnellBeginner
Profiler? What is this tool you speak of?Jason SpanglerBeginner
PWNED! Security, SQL Server, and You!Arie JonesIntermediate
Resource Governor for SQL ServerSteven WrightIntermediate
Searching for the Holy Grail of DDL AuditingColleen MorrowBeginner
Sets and Relations and Queries, Oh My!Allen WhiteBeginner
Seven SQL Agent Jobs You Should be RunningMike HillwigBeginner
Shade Tree Mechanic's Guide to SSASSteven WrightBeginner
So I started this blog... now what?Colleen MorrowBeginner
So Where is the Performance Bottleneck?Paul HilesIntermediate
So You Want a Career in Business Intelligence?Dave RodabaughBeginner
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL Azure Reporting ServicesArie JonesBeginner
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 Sharepoint: Best FrienemiesLisa GardnerIntermediate
SQL Server Internals: It's What's for Dinner!Christina LeoBeginner
SQL Server Partitioning From A to ZKevin BolesAdvanced
SQL Server Security for DevelopersAndy WarrenBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSAS Calc Script - Zombie KillerChris UmbaughIntermediate
SSAS Zombie Invasion - A Beginner's Survival GuideChris UmbaughBeginner
SSIS Package Realtime Visualzation & AnalyticsIra WhitesideIntermediate
Strategies for Sharding with SQL Azure FederationsArie JonesIntermediate
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Tally Table: What it is/how it replaces loopsJeff ModenIntermediate
Transaction and Balance Facts: Identical CousinsDave RodabaughAdvanced
Transaction Log Deep DiveKevin BolesAdvanced
Transactional Replication: Beyond The BasicsKendal Van DykeBeginner
Upgrade Roadmap: Let’s delve into SQL Server 2012 Craig PurnellIntermediate
Using FiletablesSam NasrIntermediate
Using PowerShell To Document Your SQL EnvronmentKendal Van DykeBeginner
Way Too Deep--Inside AlwaysOnJoseph D'AntoniAdvanced
WelcomeSQLSaturday 164Beginner
What Sequence objects are (and are not)Louis DavidsonIntermediate
What's Buried in the Plan Cache?Christina LeoIntermediate
Where Business meets ReportingJohn IosubIntermediate
Who Has My Keys: Tracking SQL PermissionsTimothy CoreyBeginner
Who’s using SQL Azure? (…and why aren’t others?)Jeff MlakarBeginner
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Working With XML In SQL Server Kendal Van DykeIntermediate


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.

Suggested Session TitleSkill Level
Panel Discussion: The NE Ohio IT job marketBeginner
Recursive CTE's and Advanced T-SQLIntermediate
What can we do to attract DBA's to the profession?Beginner
Your IT Career: So how's that working out for you?Beginner

SQLSaturday Home
PASS