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 TimeApplication Development - Room: 2-110Business Intelligence - Room: 4-100Database Administration - Room: 3-114Mixed Sessions - Room: 1-108Mixed Sessions 2 - Room: 6-112Professional Development And More - Room: 5-102
8:30 AMJonathan Boulineau

T-SQL: Beyond the Basics

Level: Intermediate

download
Craig Utley

Why BI Projects Fail--And What You Can Do About It

Level: Beginner

download
Adam Belebczuk

SQL Server 2012 AlwaysOn Readable Secondaries

Level: Intermediate

download
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Intermediate

download
David Liebman

BI in the Cloud

Level: Beginner
Joe Webb

Professional Development

Level: Beginner
9:45 AMRob Volk

Revenge: The SQL Part 2: The Sequel!

Level: Intermediate

download
William E. Pearson III

Bridging the Chasm: BI Theory vs. Practice

Level: Beginner
Eddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate

download
Glenn Berry

Hardware 301: Diving Deeper into Database Hardware

Level: Beginner
Kieth Mayer

Virtualizing SQL Server with Windows Server 2012 a

Level: Intermediate
Mark Swofford

I Shoulda Taken That Left Turn at Albuquerque...

Level: Beginner
11:00 AMSanil Mhatre

Parameter sniffing - make it work for you !

Level: Intermediate

download
Robert Cain

The Decoder Ring for Data Warehousing / BI

Level: Beginner
Kevin Boles

Indexing Deep Dive

Level: Advanced

download
Karen Lopez

Database Design Throwdown

Level: Intermediate

download
Mark Stacey

Slowly changing dimensions- an integrated approach

Level: Intermediate
Josh Fennessy

New Models! An Introduction to Tabular Mode SSAS

Level: Beginner
1:15 PMRick Morelan

Do SQL XML queries have to scare me?

Level: Beginner

download
Pam Shaw

Taking the Scary out of Monster Reports

Level: Intermediate

download
David Klee

Virtualizing Business Critical SQL Servers

Level: Intermediate

download
Kathi Kellenberger

SQL Server 2012 T-SQL

Level: Intermediate

download
Louis Davidson

Quiz Bowl

Level: Beginner
Joseph D'Antoni

You Wouldn't Let HR Manage Your DBs...

Level: Beginner
2:30 PMJeffrey Garbus

Rewriting bad T-SQL Code

Level: Intermediate
Daniel Evans

What's new in BI for SQL Server 2012

Level: Intermediate
Sarah Barela

Bulletproof: Hardening your SQL Server from Attack

Level: Intermediate

download
Jason Strate

Extended Events, Work Smarter Not Harder

Level: Intermediate

download
Wayne Snyder

Deeper into Tabular Models - M-to-M and the "W"

Level: Intermediate
Jonathan Gardner

Adventures in Project Management

Level: Beginner
3:45 PMDenny Cherry

TBA - Introductory SQL Session

Level: Beginner

download
Gareth Swanepoel

The Fangorn Forest - ColumnStore Indexes

Level: Intermediate
J.D. Pellerin

Custom SQL Server Transaction Log Shipping

Level: Intermediate

download
Geoff Hiten

Bad SQL

Level: Intermediate
Tim Ford

The Periodic Table of Dynamic Management Objects

Level: Intermediate
Joe Murphree

Beginners guide to Table Expressions

Level: Intermediate


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
.NET, Microsoft Office and SQL Server-Building youJoe FerryIntermediate
2012 BlitzKathi KellenbergerIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
A Lap Around Data Quality Services 2012 Christopher PriceIntermediate
Add It Up: Analysis Services AggregationsCraig UtleyIntermediate
Administering the BI StackJosh FennessyIntermediate
Advanced T-SQL techniquesAlex GrinbergAdvanced
Adventures in Project ManagementJonathan GardnerBeginner
Analysis Services 2008 End-to-EndCraig UtleyBeginner
Analysis Services 2012 End-to-EndCraig UtleyBeginner
Analysis Services for the DBAMark StaceyBeginner
Asynchronous programming with Service BrokerSanil MhatreIntermediate
Attribute Discretization in Analysis ServicesWilliam E. Pearson IIIBeginner
Attribute Discretization in Analysis Services 2012William E. Pearson IIIBeginner
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Avoid Slow SSAS Queries: MDX Query TroubleshootingCraig UtleyAdvanced
Bad SQLGeoff HitenIntermediate
Basic Performance Tips and Gotchas for BeginnersRick MorelanBeginner
Become a PowerShell Pop Star - Part 1Robert CainBeginner
Become a PowerShell Pop Star - Part 2Robert CainBeginner
Becoming DAX: An Introduction ...William E. Pearson IIIIntermediate
Becoming DAX: An Introduction ...William E. Pearson IIIIntermediate
Beginners guide to Table ExpressionsJoe MurphreeIntermediate
Behind the Scenes: SQL Server StatisticsTravis WhitleyBeginner
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
BI as a Service (BIaaS)Daniel EvansAdvanced
BI in the CloudDavid LiebmanBeginner
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIBeginner
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIBeginner
Bulletproof: Hardening your SQL Server from AttackSarah BarelaIntermediate
Career Management for Data ProfessionalsKaren LopezBeginner
Choose Your Own Adventure: The Morning AfterThomas LaRockAdvanced
Concurrency in PowerShellJonathan BoulineauAdvanced
Configuring SQL Server 2012 Reporting ServicesRobert CainIntermediate
Custom SQL Server Transaction Log ShippingJ.D. PellerinIntermediate
Data Quality Services--Finally!Julie SmithBeginner
Database Design ThrowdownKaren LopezIntermediate
Database Design: Size DOES MatterThomas LaRockAdvanced
Database Health and PerformanceDavid KleeIntermediate
Decisions, Decisions: SSAS 2012 Design and StorageCraig UtleyBeginner
Deeper into Tabular Models - M-to-M and the "W"Wayne SnyderIntermediate
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Developing and Managing a BI Semantic Tabular ModePatrick LeBlancIntermediate
Discovering the Plan CacheJason StrateIntermediate
DMV Emergency Room!Glenn BerryIntermediate
Do It Right: Best Practices for Analysis ServicesCraig UtleyIntermediate
Do SQL XML queries have to scare me?Rick MorelanBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Extending the SSIS 2012 Reports with AnalyticsPatrick LeBlancIntermediate
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 involved and Getting aheadTim RadneyBeginner
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
Getting Started with Powershell for DBAsJonathan BoulineauBeginner
Getting To Know Your IndexesJason StrateIntermediate
Hardware 301: Diving Deeper into Database HardwareGlenn BerryBeginner
High Availability for SSIS in SQL Server 2012Patrick LeBlancAdvanced
How to build XML.Alex GrinbergAdvanced
I Got Your Back (Up)...Mark SwoffordBeginner
I Shoulda Taken That Left Turn at Albuquerque...Mark SwoffordBeginner
Indexing Deep DiveKevin BolesAdvanced
Indexing for Join OptimizationJeffrey GarbusAdvanced
Indexing for performanceJeffrey GarbusIntermediate
Integrating DQS, MDS and Your Data Warehouse Christopher PriceIntermediate
Intro to the new Data Alert feature in SSRS 2012Ludwig ArmbrusterBeginner
Introduction to Master Data Services 2012 Christopher PriceIntermediate
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
Know Backups and Know RecoveryTim RadneyIntermediate
Leveraging Index Operational StatisticsJason StrateIntermediate
Make SQL Server Pop with PowerShellRobert CainIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Model-Driven Database DesignKaren LopezBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockAdvanced
Moving Data With SQL Azure Data SyncPatrick LeBlancIntermediate
Moving Day - SQL Migrations with SharePointGeoff HitenIntermediate
My Favorite SSIS Tips and TricksDave FacklerIntermediate
New Models! An Introduction to Tabular Mode SSASJosh FennessyBeginner
Nuts and Bolts of Table CompressionMike ByrdIntermediate
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIBeginner
Overview of PowerPivotDavid EichnerBeginner
Parameter sniffing - make it work for you !Sanil MhatreIntermediate
Partitioning: The Rest of the StoryMike ByrdIntermediate
Performance Enhancing LazinessTim FordIntermediate
PowerPivot for Excel: For Those Unacquainted ...William E. Pearson IIIBeginner
PowerPivot for Excel: For Those Unacquainted ...William E. Pearson IIIBeginner
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Private Clouds with SQL Server 2012Sarah BarelaIntermediate
Professional DevelopmentJoe WebbBeginner
Project Deployment Model and SSISDB in SSIS 2012Ludwig ArmbrusterBeginner
Prototype with PowerPivot: External SSAS GroupsWilliam E. Pearson IIIIntermediate
Prototype with PowerPivot: External SSAS GroupsWilliam E. Pearson IIIIntermediate
Queries vs Indexes - A How to GuideJoe MurphreeIntermediate
Query Plan Tuning for BeginnersJoe MurphreeBeginner
Quiz BowlLouis DavidsonBeginner
Read Dirty to Me - Isolation Levels/User ImpactWendy PastrickBeginner
Reciprocal Symmetry: MDX in PowerPivotWilliam E. Pearson IIIIntermediate
Reciprocal Symmetry: MDX in PowerPivotWilliam E. Pearson IIIIntermediate
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Rewriting bad T-SQL CodeJeffrey GarbusIntermediate
Searching for the Holy Grail of DDL AuditingColleen MorrowBeginner
Secure SSAS Data Without Tying Yourself in KnotsCraig UtleyIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
Sets and Relations and Queries, Oh My!Allen WhiteBeginner
Slowly changing dimensions- an integrated approachMark StaceyIntermediate
So I started this blog... now what?Colleen MorrowBeginner
So you're a MS SQL N00BTamera ClarkBeginner
SQL 2012 -- All About AvailabilityJoseph D'AntoniIntermediate
SQL 2012 AlwaysOnGeoff HitenAdvanced
SQL 2012 DMV's & Extended EventsGareth SwanepoelIntermediate
SQL 2012 Error Handling, Pick your Destiny.Rick MorelanIntermediate
SQL IO for beginners (and all non-gamers)Mark StaceyBeginner
SQL Server 2012 AlwaysOn Readable SecondariesAdam BelebczukIntermediate
SQL Server 2012 Column Store IndexKevin BolesIntermediate
SQL Server 2012 T-SQLKathi KellenbergerIntermediate
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server Partitioning From A to ZKevin BolesAdvanced
SQL Server Relational Database Performance-Less isJoe FerryBeginner
SQL Server Statistics - A User's GuideJoe MurphreeIntermediate
SQL Server XML 101Alex GrinbergAdvanced
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSAS 2012 Tabular vs. MultidimensionalWilliam E. Pearson IIIBeginner
SSIS 2012—Why you might want to move to it sooner Joe FerryIntermediate
SSIS Moving Beyond the Script Task & Script ComponChristopher PriceAdvanced
SSRS in ASP.Net ApplicationDavid LiebmanBeginner
Taking the Scary out of Monster ReportsPam ShawIntermediate
TBA - Introductory SQL SessionDenny CherryBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Creepy DBA, How to Stalk Your UsersJason StrateIntermediate
The Decoder Ring for Data Warehousing / BIRobert CainBeginner
The Fangorn Forest - ColumnStore IndexesGareth SwanepoelIntermediate
The Periodic Table of Dynamic Management ObjectsTim FordIntermediate
Time Saving Tips & Tricks for SSMS 2012Aaron NelsonIntermediate
Tips & Tricks for Dynamic SSRS ReportsPam ShawBeginner
Transaction Log Deep DiveKevin BolesAdvanced
Transaction Log InternalsTim ChapmanAdvanced
Transactional Replication 101Wendy PastrickBeginner
T-SQL: Beyond the BasicsJonathan BoulineauIntermediate
Understanding SSIS PerformanceDave FacklerIntermediate
Unit Testing made easy for Database Development Sanil MhatreBeginner
Virtualizing Business Critical SQL ServersDavid KleeIntermediate
Virtualizing SQL Server with Windows Server 2012 aKieth MayerIntermediate
What Are You Waiting For?Jason StrateIntermediate
What's new in BI for SQL Server 2012Daniel EvansIntermediate
What's New in PowerShell v3Robert CainBeginner
Why BI Projects Fail--And What You Can Do About ItCraig UtleyBeginner
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Writing Faster QueriesTim ChapmanAdvanced
XQuery Basics for the DBAJason StrateIntermediate
You Inherited a Database, Now What?Tim RadneyBeginner
You Wouldn't Let HR Manage Your Databases, So ...Joseph D'AntoniBeginner
You Wouldn't Let HR Manage Your DBs...Joseph D'AntoniBeginner


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