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 108/110Track 2 - Room: Room 105Track 3 - Room: Room 209Track 4 - Room: Room 215Track 5 - Room: Room 111Track 6 - Room: Room 208/210
07:30 AMSQLSaturday 242

Registrations

Level: Non-Technical
     
08:30 AMKevin Boles

Windowing Functions: THE Reason to Upgrade to 2012

Level: Intermediate

download
Adam Belebczuk

Introduction to SQL Server 2012 AlwaysOn Availability Groups

Level: Intermediate

download
Joe Salvatore

Agile Data Warehouse Design – Just Enough Design for Success

Level: Intermediate

download
Tamera Clark

Designing & Formatting Reports

Level: Beginner

download
Arie Jones

Cloud Ready: Preparing Yourself for Azure SQL Databases

Level: Intermediate
William E Pearson III

Getting Started with MDX

Level: Beginner
10:00 AMNeil Hambly

Why are we Waiting..

Level: Advanced
Brent Dragoo

Going Live! Upgrading to SQL 2012 with Log Shipping

Level: Beginner
Audrey Hammonds

Pretty Output: T-SQL for Presentation

Level: Beginner

download
Brian Davis

SSIS Templates Can Make Your Life Easier

Level: Beginner

download
Allen White

Manage SQLServer Efficiently w/PowerShell Remoting

Level: Intermediate

download
Joe McTaggart

Troubleshooting SQL IO issues with Xperf

Level: Advanced

download
11:30 AMJim Miller

SQL Server ‘BI Stack’ Metadata Management

Level: Beginner
 Tony Tomarchio

High Performance SANLess Clustering

Level: Beginner
  WIT Panel

WIT Panel: You.. as a brand.

Level: Beginner
1:00 PMDavid Maxwell

DBA 911 - Database Corruption

Level: Beginner

download
Chris Bell

“Indexing” Encrypted Data

Level: Intermediate

download
Josh Burgin

Pervasive business information through Mobile BI

Level: Beginner
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
Lisa Gardner

Performance Troubleshooting Tools & Techniques

Level: Intermediate

download
02:30 PMWendy Pastrick

Visualizing Your Indexes - Science vs Art

Level: Beginner

download
Rob Volk

Denali Ho! Exploring SQL Server

Level: Intermediate

download
Julie Smith

BIML--Step by Step

Level: Intermediate

download
JD Wade

What SQL DBAs need to know about SharePoint

Level: Intermediate

download
Warren Sifre

Introduction to FileTables in SQL 2012

Level: Intermediate

download
Neil Hambly

MDS and DQS - Beyond the TLAs to Data Quality

Level: Beginner
04:00 PMAaron Cutshall

T-SQL Tips & Tricks

Level: Intermediate

download
Eddie Wuerch

Partitioning for Perf and Mgmt of Large Tables

Level: Intermediate

download
Josh Fennessy

Demystifying BISM and Tabular Mode SSAS

Level: Beginner
Kyle Neier

Into a Swan - Discovering the Beauty of RESTORE

Level: Beginner
Aaron King

Agile Database Development

Level: Intermediate

download
Luke Jian

Anatomy of a Join

Level: Intermediate

download
05:15 PMSQLSaturday 242

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
“Indexing” Encrypted DataChris BellIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
Advanced SSRS: Scale-out Deployments and SharePoint IntegrationJoe McTaggartAdvanced
Agile Data Warehouse Design – Just Enough Design for SuccessJoe SalvatoreIntermediate
Agile Database DevelopmentAaron KingIntermediate
Anatomy of a JoinLuke JianIntermediate
Become a SQL Block’stroyerKyle NeierAdvanced
BIML--Step by StepJulie SmithIntermediate
Build a SQL-Server 2012 Environment on Hyper-V Client 2012Ludwig ArmbrusterBeginner
Change Data Capture and SSIS 2012Andy ThiruBeginner
Cloud Ready: Preparing Yourself for Azure SQL DatabasesArie JonesIntermediate
Coffee BreakSQLSatruday 242Non-Technical
Common TSQL MistakesKevin BolesIntermediate
Database Design Contentious IssuesKaren LopezIntermediate
DBA 911 - Database CorruptionDavid MaxwellBeginner
Demystifying BISM and Tabular Mode SSASJosh FennessyBeginner
Denali Ho! Exploring SQL ServerRob VolkIntermediate
Design and Implement BI like Edison! William E Pearson IIIBeginner
Designing & Formatting ReportsTamera ClarkBeginner
Dimensional Modeling 101Audrey HammondsBeginner
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started with MDXWilliam E Pearson IIIBeginner
Getting Your Data into those Nice, White, Fluffy CloudsEnrique LimaIntermediate
Going Live! Upgrading to SQL 2012 with Log ShippingBrent DragooBeginner
Going SpatialFrank MurphyBeginner
Goodbye Next Next Next, Hello Automated InstallsBrian DavisIntermediate
Hacking SQL SaturdayRob VolkBeginner
Hekaton - Why is it SOOO FAST?!?Kevin BolesAdvanced
High Performance SANLess ClusteringTony TomarchioBeginner
High Performance SANLess ClusteringTony TomarchioBeginner
Index Performance Tuning with Dynamic Management ViewsDavid MaxwellBeginner
Into a Swan - Discovering the Beauty of RESTOREKyle NeierBeginner
Introduction to FileTables in SQL 2012Warren SifreIntermediate
Introduction to SQL Server 2012 AlwaysOn Availability GroupsAdam BelebczukIntermediate
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Lock It - Don't Block It!Kyle NeierBeginner
Lunch BreakSQLSaturday 242Non-Technical
Manage SQLServer Efficiently w/PowerShell RemotingAllen WhiteIntermediate
Matching with Data Quality ServicesJulie SmithIntermediate
Matching with Data Quality ServicesJulie SmithIntermediate
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
Moving Enterprise database to cloudAndy ThiruBeginner
Navigating the Options for Data RedundancyWendy PastrickIntermediate
Near Unlimited Scalability with SQL Azure Federations Arie JonesIntermediate
Page Latches for Mere MortalsEddie WuerchAdvanced
Partitioning for Perf and Mgmt of Large TablesEddie WuerchIntermediate
Perform ETL with Excel 2013 - The Data Explorer!Ludwig ArmbrusterIntermediate
Performance Troubleshooting Tools & TechniquesLisa GardnerIntermediate
Personal => Enterprise: Getting Started with Data Governance and Self-Service BI Infrastructure Dominic GoNon-Technical
Pervasive business information through Mobile BIJosh BurginBeginner
Possible Musics: Choosing between Analysis Services 2012 Multidimensional and TabularWilliam E Pearson IIIIntermediate
PowerShell 101 for the SQL Server DBAAllen WhiteBeginner
Practical Self-Service BI with Excel 2013William E Pearson IIIBeginner
Pretty Output: T-SQL for PresentationAudrey HammondsBeginner
Quickie MartJames ConwayAdvanced
RaffleSQLSaturday 242Non-Technical
Reading Query PlansJoe McTaggartAdvanced
RegistrationsSQLSaturday 242Non-Technical
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
SQL Server ‘BI Stack’ Metadata ManagementJim MillerBeginner
SQL Server 2012 Column Store IndexKevin BolesIntermediate
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server File ManagementLisa GardnerIntermediate
SQL Server for SharePoint: Do You want a Hot Rod or a Jalopy?John FerringerIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS 2012 - Best Practices and Design PatternsJoe SalvatoreIntermediate
SSIS Templates Can Make Your Life EasierBrian DavisBeginner
Stream Those BLOBs! Using SQL Server FILESTREAM and FILETABLE Arie JonesIntermediate
Troubleshooting SQL IO issues with XperfJoe McTaggartAdvanced
T-SQL Tips & TricksAaron CutshallIntermediate
Up and Running with SSISJulie SmithBeginner
Visualizing Your Indexes - Science vs ArtWendy PastrickBeginner
What SQL DBAs need to know about SharePointJD WadeIntermediate
Why are we Waiting..Neil HamblyAdvanced
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
WIT Panel: You.. as a brand.WIT PanelBeginner


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
Troubleshooting SQL IO issues with XPerfAdvanced

SQLSaturday Home
PASS