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: Room 214Track 2 - Room: Room 116Track 3 - Room: Room 216Track 4 - Room: Room 217Track 5 - Room: Room 117Track 6 - Room: Room 118Track 7 - Room: Room 215Track 8 - Room: Room 218
09:00 AMChris Webb

What’s New for BI in Excel 2013?

Level: Intermediate

download
Jason Strate

Discovering the Plan Cache

Level: Intermediate
Jorge Segarra

What is a BI DBA?

Level: Intermediate

download
Scott Shaw

The Future of the DBA

Level: Beginner
Allan Hirt

Demystifying Clustering for the DBA

Level: Intermediate

download
Ed Leighton-Dick

Service Broker: The Queue Continuum

Level: Intermediate
Aaron Lowe

Writing Professional Database Code

Level: Intermediate
Mike Donnelly

Flipping Through the SSIS Catalag

Level: Intermediate

download
10:30 AMJason Thomas

Advanced Charting Techniques in SSRS

Level: Intermediate
Erin Stellato

Making the Leap from Profiler to Extended Events

Level: Beginner

download
Joseph Vertido

Data Quality Services Approach to Cleansing

Level: Intermediate
James Serra

What exactly is Business Intelligence?

Level: Beginner
David Klee

Database Health and Performance

Level: Intermediate

download
Frank Gill

Tools to Make Multi-Object Administration Easier

Level: Intermediate
Merrill Aldrich

PowerShell 101

Level: Beginner

download
Paul Turley

Visualization Choices: What, When, and How?

Level: Beginner

download
1:00 PMDoug Lane

Hailing Frequencies: SSAS Terms and Concepts

Level: Beginner

download
Jason Strate

What Are You Waiting For?

Level: Intermediate
Josh Fennessy

Demystifying BISM and Tabular Mode SSAS

Level: Beginner
Kyle Neier

Locks, Blocks, and Deadlocks

Level: Intermediate

download
Eddie Wuerch

Partitioning for Perf and Mgmt of Large Tables

Level: Intermediate

download
Joseph D'Antoni

Using Compression to Improve Database Performance

Level: Intermediate
Rob Volk

Tame Your Unruly Data...With Constraints!

Level: Beginner

download
Stacia Misner

Dashboard Do's and Don'ts

Level: Beginner
2:30 PMTed Krueger

Upgrading to SQL Server 2012 with limited downtime

Level: Beginner
Kevin Kline

SQL Server Internals & Architecture

Level: Intermediate

download
Julie Koesmarno

Analytic Cartography: Master geospatial reporting

Level: Intermediate

download
Neil Hambly

SQL Server 2012 Memory Management

Level: Intermediate
Paul Timmerman

An Optimistic Approach: Snapshot Isolation in SQL

Level: Intermediate

download
Rick Krueger

Rules of Engagement: NoSQL is SQL Server's Ally

Level: Beginner

download
Sanil Mhatre

Database Unit Testing made Easy

Level: Beginner

download
Terry Bunio

How to install and configure SSRS 2012/Sharepoint

Level: Beginner
4:00 PMJames Serra

Building an Effective Data Warehouse Architecture

Level: Beginner

download
Kathi Kellenberger

SQL Server 2012 T-SQL

Level: Intermediate

download
Leonard Murphy

Getting the most out of Power View

Level: Beginner

download
Erin Stellato

Demystifying Database Statistics

Level: Intermediate
Ross LoForte

Deep dive on SQL Server 2012 Availability Groups

Level: Beginner

download
Haidong Ji

Monitoring and collecting storage info for DBAs

Level: Beginner

download
Luke Jian

Anatomy of a Join

Level: Intermediate

download
Hope Foley

Consulting The Good, The Bad, The Ugly

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
(Way Too Much) Fun with Reporting Services Stacia MisnerIntermediate
7 Habits of Highly Effective DBAsNicholas CainIntermediate
Accelerating the DBA with PowershellKyle NeierAdvanced
Advanced Charting Techniques in SSRSJason ThomasIntermediate
Agile Data Warehouse - The final frontier Terry BunioIntermediate
AlwaysOn - Finally, A usable 'mirror'!Jim MurphyBeginner
An Optimistic Approach: Snapshot Isolation in SQL Paul TimmermanIntermediate
Analytic Cartography: Master geospatial reportingJulie KoesmarnoIntermediate
Anatomy of a JoinLuke JianIntermediate
Asynchronous programming with Service BrokerSanil MhatreBeginner
Building an Effective Data Warehouse ArchitectureJames SerraBeginner
Business Continuity: The Real Reason for HA and DRAllan HirtBeginner
Consulting The Good, The Bad, The UglyHope FoleyBeginner
Dashboard Do's and Don'tsStacia MisnerBeginner
Data Models - Why SQL Scripts aren't enoughTerry BunioIntermediate
Data Quality Services Approach to CleansingJoseph VertidoIntermediate
Database Development: Paradox or ImperativeAaron LoweIntermediate
Database Health and PerformanceDavid KleeIntermediate
Database Unit Testing made EasySanil MhatreBeginner
DAXMD: SSAS Multidimensional meets DAX and Power VChris WebbIntermediate
Deep dive on SQL Server 2012 Availability GroupsRoss LoForteBeginner
Demystifying BISM and Tabular Mode SSASJosh FennessyBeginner
Demystifying Clustering for the DBAAllan HirtIntermediate
Demystifying Database StatisticsErin StellatoIntermediate
Dimensional Data Modeling PrimerTerry BunioBeginner
Dimensional Modelling for the DBAScott ShawIntermediate
Discovering the Plan CacheJason StrateIntermediate
Disk IO Tuning on Microsoft SQL ServerKevin KlineBeginner
Do More With Less: Consolidate and VirtualizeJorge SegarraBeginner
Don't Box Me In: Escape the CubicleTim FordBeginner
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
Extended Events – Effective UsageNeil HamblyIntermediate
Extended Events, Work Smarter Not HarderJason StrateIntermediate
Flipping Through the SSIS CatalagMike DonnellyIntermediate
GeoSpatial Analytics Using Microsoft BIJason ThomasBeginner
Get Involved!Ed Leighton-DickNon-Technical
Getting the most out of Power ViewLeonard MurphyBeginner
Hailing Frequencies: SSAS Terms and ConceptsDoug LaneBeginner
High IO, High IO, It's a Case Study Yo Ho!Tim FordIntermediate
How to install and configure SSRS 2012/SharepointTerry BunioBeginner
Interrogating the Transaction Log Frank GillIntermediate
Into a Swan - Discovering the Beauty of RESTOREKyle NeierBeginner
Introduction to Microsoft’s Master Data ServicesJames SerraBeginner
Locks, Blocks, and DeadlocksKyle NeierIntermediate
Looking Through WindowsEd Leighton-DickBeginner
LT: But I Want BI NOWWWWPaul TurleyLightning Talk
LT: Rock Your World With GeoFlowJulie KoesmarnoLightning Talk
Making the Leap from Profiler to Extended EventsErin StellatoBeginner
Matching and Survivorship Joseph VertidoIntermediate
Monitoring and collecting storage info for DBAsHaidong JiBeginner
Overview of Microsoft Appliances James SerraBeginner
Page Latches for Mere MortalsEddie WuerchIntermediate
Partitioning for Perf and Mgmt of Large TablesEddie WuerchIntermediate
Policy-Based Management in a NutshellJorge SegarraBeginner
Power to the Pivot - Intro to PowerPivot 2012 Hope FoleyBeginner
Power View: A Peek Behind the CurtainStacia MisnerBeginner
PowerShell 101Merrill AldrichBeginner
PowerShell and SQL Server Administration: upgrade Haidong JiBeginner
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Rules of Engagement: NoSQL is SQL Server's AllyRick KruegerBeginner
Running SQL Server 2012 on Windows Server Core Ross LoForteBeginner
Service Broker: The Queue ContinuumEd Leighton-DickIntermediate
Shoveling Frogs into a WheelbarrowMerrill AldrichIntermediate
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server 2012 T-SQLKathi KellenbergerIntermediate
SQL Server 2012 T-SQLKathi KellenbergerIntermediate
SQL Server Dos and Don'ts: Keys to DBA NirvanaAllan HirtBeginner
SQL Server Internals & ArchitectureKevin KlineIntermediate
SQL Server: The Undiscovered CountryRob VolkIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
Team Leadership FundamentalsKevin KlineBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Future of the DBAScott ShawBeginner
Tools to Make Multi-Object Administration EasierFrank GillIntermediate
Top 10 Admininistrator Mistakes on SQL ServerKevin KlineBeginner
T-SQL 2012 Analytic FunctionsKathi KellenbergerIntermediate
Understanding KerberosEd Leighton-DickIntermediate
Upgrading to SQL Server 2012 with limited downtimeTed KruegerBeginner
Use a custom assembly to extend reports & queriesPaul TurleyAdvanced
Using Compression to Improve Database PerformanceJoseph D'AntoniIntermediate
Virtualizing Business Critical SQL ServersDavid KleeIntermediate
Visualization Choices: What, When, and How?Paul TurleyBeginner
What Are You Waiting For?Jason StrateIntermediate
What exactly is Business Intelligence?James SerraBeginner
What is a BI DBA?Jorge SegarraIntermediate
What’s New for BI in Excel 2013?Chris WebbIntermediate
Why are we Waiting..Neil HamblyAdvanced
Why I Won't Be Hiring YouNicholas CainBeginner
Why Scans are better than SeeksRob FarleyIntermediate
Writing Professional Database CodeAaron LoweIntermediate
XQuery Basics for the DBAJason StrateIntermediate


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