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 - Room: Middle SchoolDBA - Room: C201DEV/DBA - Room: High SchoolKeynote/Lunch - Room: GymMore DBA - Room: C206Power BI - Room: C209Professional Dev - Room: C202
08:45 AMBill Fellows

Type More, Click Less: Programmatically build SSIS packages

Level: Advanced

download
AJ Mendo

DBA Survival Guide: Daily Checklist and Server Mon

Level: Beginner

download
Aaron Cutshall

T-SQL Tips & Tricks

Level: Intermediate

download
Meredith Ryan

Women In Technology Roundtable

Level: Beginner
Glenn Berry

Hardware 201: Selecting Database Hardware

Level: Beginner

download
Akesh Gupta

Self Service BI using Office 2013 and SQL 2012

Level: Intermediate
 
10:00 AMTim Mitchell

Maximizing SSIS Package Performance

Level: Intermediate
Andre DuBois

What secrets does your database schema hold?

Level: Beginner

download
Ben Miller

SMO Internals for High Performance PowerShell

Level: Intermediate

download
 Jason Kassay

Getting Started with Execution Plans

Level: Beginner

download
Marc Beacom

Introduction to Tabular Models

Level: Beginner
Chris Hyde

Becoming Certified In Microsoft SQL Server

Level: Beginner

download
11:15 AMJeff Renz

Dashboards - Introducing Pyramid Analytics

Level: Beginner
Dmitri Korotkevitch

Implementing Data Partitioning and Tiered Storage

Level: Advanced
TJay Belt

Documentation – you know you love it

Level: Beginner

download
 Keith Tate

The Curious Case of Isolation Levels

Level: Intermediate

download
Doug Lane

SQL Server Murder Mystery Hour: Dead Reports Don't Talk

Level: Beginner
Chris Shaw

Interview Tips

Level: Beginner
12:30 PM Matt Henderson

How flash storage modernizes databases and tips for tuning databases for all flash arrays

Level: Intermediate

download
  Tony Tomarchio

High Performance SANLess Clustering

Level: Beginner
Trent Mera

A Brief overview of SQL Server performance management using Spotlight on SQL Server and Performance

Level: Beginner
Bruce Adair

Bringing Sexy Back...to the Database?

Level: Intermediate
01:45 PMJason Horner

Dimension Modeling Design Patterns: Beyond Basics

Level: Intermediate
Dan Hess

SQL Server encryption 3 ways - in transit, at rest and in the database

Level: Beginner

download
Steve Stedman

Common Table Expressions - Advanced

Level: Intermediate

download
 Ryan Adams

Manage your shop with CMS and Policy Based Mgmt

Level: Beginner

download
Meagan Longoria

The Accidental Report Designer: Data Visualization Best Practices in SSRS

Level: Intermediate

download
John Morehouse

Social Networking Is Alive!

Level: Non-Technical
03:00 PMJeff Renz

Data Vault Data Warehouse Architecture

Level: Intermediate
David Klee

Virtualizing Critical SQL Servers

Level: Intermediate

download
Wendy Pastrick

Navigating the Options for Data Redundancy

Level: Intermediate

download
 Tim Ford

Periodic Table of DMVs: Part Two - The SQL

Level: Advanced
Reeves Smith

Get Into Evaluation Context with DAX, the Language of PowerPivot and Tabular

Level: Advanced

download
Ronald Yenko

Tips for Giving a Stellar Technical Presentation

Level: Non-Technical

download
04:15 PMMeagan Longoria

Somebody got BIDS Helper in my Data Tools

Level: Intermediate

download
Ben Miller

SQL Server TDE

Level: Intermediate

download
Meredith Ryan

Backup Basics

Level: Beginner

download
 Brandon Tucker

Lessons Learned: Hurricane Sandy

Level: Beginner
Carlos Bossy

Getting started with Big Data and BI

Level: Intermediate
Steve Jones

Branding Yourself for a Dream Job

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
2012 TSQL SweetsBill FellowsIntermediate
7 Habits of Highly Effective DBAsNicholas CainIntermediate
A Brief overview of SQL Server performance management using Spotlight on SQL Server and Performance Trent MeraBeginner
Advanced SQL Server Integration ServicesJeff RenzAdvanced
AlwaysOn Live DeploymentRyan AdamsIntermediate
Archiving/Purging the RIGHT wayPrakash HedaAdvanced
Backup BasicsMeredith RyanBeginner
Backups & Restores: You’re Not In Kansas Anymore!John MorehouseBeginner
Becoming Certified In Microsoft SQL ServerChris HydeBeginner
Benchmarking, Baselines and Monitoring StorageWesley BrownBeginner
Branding Yourself for a Dream JobSteve JonesBeginner
Bringing Sexy Back...to the Database?Bruce AdairIntermediate
Business Continuity using SQL Server on a BudgetRonald YenkoBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Cloud Database Scalability with SQL FederationScott KleinIntermediate
Collecting Metadata for Consolidation PlanningTim FordIntermediate
Common Table Expressions - AdvancedSteve StedmanIntermediate
Common Table Expressions - IntroductionSteve StedmanBeginner
Confio Software SessionConfio SoftwareBeginner
Cross Continent DR with SQL Server 2012 AlwaysOnPat SinthusanIntermediate
Dashboards - Introducing Pyramid AnalyticsJeff RenzBeginner
Data Profiling, Cleansing, Enrichment & Matching with SSISChristopher PriceBeginner
Data Quality Services Approach to CleansingJoseph VertidoIntermediate
Data Vault Data Warehouse ArchitectureJeff RenzIntermediate
Database Health and PerformanceDavid KleeIntermediate
Database Monitoring : Trying To Keep SaneTJay BeltBeginner
Database Release Management: Tips to help organize itTJay BeltIntermediate
Datical SessionDatical SoftwareBeginner
DBA Survival Guide: Daily Checklist and Server MonAJ MendoBeginner
DBA Survival Guide: Database Backup and RestoreAJ MendoBeginner
Dell Software SessionDell SoftwareBeginner
Detect Worst Performing SQL Queries During Peak HourPrakash HedaIntermediate
Dimension Modeling Design Patterns: Beyond BasicsJason HornerIntermediate
Documentation – you know you love itTJay BeltBeginner
Don’t Miss Out on Excel Cube FunctionsMeagan LongoriaBeginner
Dr. DMV: How to Use Dynamic Management ViewsGlenn BerryBeginner
Get Into Evaluation Context with DAX, the Language of PowerPivot and TabularReeves SmithAdvanced
Getting started with Big Data and BICarlos BossyIntermediate
Getting Started with Execution PlansJason KassayBeginner
Global Address Data: Storage and VerificationJoseph VertidoIntermediate
Hardware 201: Selecting Database HardwareGlenn BerryBeginner
High Performance SANLess ClusteringTony TomarchioBeginner
How Active Directory affects SQL ServerRyan AdamsAdvanced
How flash storage modernizes databases and tips for tuning databases for all flash arraysMatt HendersonIntermediate
How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise EditionDon Boxley JrIntermediate
Idera SessionIdera SoftwareBeginner
Implementing Data Partitioning and Tiered StorageDmitri KorotkevitchAdvanced
Interview TipsChris ShawBeginner
Into the Wild,Taming Unstructured DataChristopher PriceIntermediate
Introduction to BI and Data ModelingFarouq AbukhamirehIntermediate
Introduction to Tabular ModelsMarc BeacomBeginner
It's All About the Performance, Right?David KleeIntermediate
Kama Sutra of SSIS: A guide to loving ETLBill FellowsIntermediate
Kung Fu Migration to Windows Azure SQL DatabaseScott KleinIntermediate
Lean BI Solutions w PowerPivot, Tabular & a MulletBrent GreenwoodIntermediate
Lessons Learned: Hurricane SandyBrandon TuckerBeginner
Locks, Blocks, and Deadlocks Oh My!Randy KnightIntermediate
Manage your shop with CMS and Policy Based MgmtRyan AdamsBeginner
Matching and SurvivorshipJoseph VertidoIntermediate
Maximizing SSIS Package PerformanceTim MitchellIntermediate
MDS in Practice: An Integrated ApproachChristopher PriceBeginner
Measuring BI Adoption: Dog Food Is Good For YouBrent GreenwoodIntermediate
Mirroring Start to FinishRyan AdamsIntermediate
Navigating the Options for Data RedundancyWendy PastrickIntermediate
New T-SQL features in SQL Server 2012Marc BeacomBeginner
Parent/Child Structures in SSISTim MitchellIntermediate
Periodic Table of DMVs: Part Two - The SQLTim FordAdvanced
PowerPivot, SSAS Tabular Data Model and PowerViewFarouq AbukhamirehIntermediate
Scaling SQL Server deployments – the secret’s in the flash memory Walter HintonIntermediate
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
SMO Internals for High Performance PowerShellBen MillerIntermediate
Social Networking Is Alive!John MorehouseNon-Technical
Somebody got BIDS Helper in my Data ToolsMeagan LongoriaIntermediate
SQL 2012 AlwaysOn QuickstartRyan AdamsBeginner
SQL LogShipping with PowerShellBen MillerIntermediate
SQL Security Best Practices & Shrinking Your Attack SurfaceMatthew BrimerIntermediate
SQL Server 2012 over NAS StoragePat SinthusanIntermediate
SQL Server Databaseology 201John MorehouseIntermediate
SQL Server encryption 3 ways - in transit, at rest and in the databaseDan HessBeginner
SQL Server Murder Mystery Hour: Dead Reports Don't TalkDoug LaneBeginner
SQL Server TDEBen MillerIntermediate
Squeezing Performance from VMware-Based SQL ServerDavid KleeIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
Storage Tuning Deep DiveWesley BrownIntermediate
Tabular ModelsJeff RenzBeginner
The Accidental Report Designer: Data Visualization Best Practices in SSRSMeagan LongoriaIntermediate
The Curious Case of Isolation LevelsKeith TateIntermediate
The Encryption PrimerSteve JonesBeginner
Tips and Tricks for Auditing in SQL ServerRonald YenkoIntermediate
Tips and Tricks for Writing Better TSQLRonald YenkoIntermediate
Tips for Giving a Stellar Technical PresentationRonald YenkoNon-Technical
T-SQL Tips & TricksAaron CutshallIntermediate
T-SQL Tips & Tricks Part 2Aaron CutshallIntermediate
Type More, Click Less: Programmatically build SSIS packagesBill FellowsAdvanced
Understanding Storage Systems and SQL ServerWesley BrownBeginner
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Violin Memory SessionViolin MemoryBeginner
Virtualizing Critical SQL ServersDavid KleeIntermediate
What is this cache and how did it get so big?Doug BrendleIntermediate
What secrets does your database schema hold?Andre DuBoisBeginner
Who's viewing your data? Doug BrendleIntermediate
Why I Won't Be Hiring YouNicholas CainBeginner
Windows Azure SQL Database - your cloud databaseScott KleinBeginner
Women In Technology RoundtableMeredith RyanBeginner


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