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: Room DBonus 1 - Room: Room CBonus 2 - Room: Room EDBA - Room: Room BDev - Room: Room A
08:00 AMSQLSaturday 309

Registrations

Level: Non-Technical
SQLSaturday 309

Registrations

Level: Non-Technical
SQLSaturday 309

Registrations

Level: Non-Technical
SQLSaturday 309

Registrations

Level: Non-Technical
SQLSaturday 309

Registrations

Level: Non-Technical
08:30 AMAllen Smith

BI Basics - Finding Return on Data

Level: Beginner
William E Pearson III

Getting Started with MDX

Level: Beginner
Tim Costello

Windowing Functions

Level: Beginner

download
David Klee

SQL Server Virtualization 101

Level: Beginner
Hakim Ali

INDEXING 101 - WHAT IS AN INDEX?

Level: Beginner
09:45 AMAllen Smith

ColumnStore Indexes in SQL 2014

Level: Intermediate
William E Pearson III

Design and Implement BI like Edison!

Level: Beginner
Tim Costello

Source Code Control: Revision management for the data dude.

Level: Beginner

download
Brandon Leach

SQL Server Storage internals: Looking under the hood.

Level: Advanced
Hakim Ali

T-SQL Throwdown

Level: Intermediate
11:00 AMBryan Smith

Finding and Cleansing Data with Excel Power Query

Level: Beginner

download
Brett Tomson

Power This, Power That...Making Sense of Power BI

Level: Beginner

download
Tom Norman

Converting Unreliable Deployments Into Consistent Releases

Level: Intermediate

download
Wesley Brown

Understanding Storage Systems and SQL Server

Level: Beginner
JK Wood

Temporary Query Items and You

Level: Intermediate
12:15 PMLunch Session

Sponsor Lunch Session - Profisee

Level: Beginner
Lunch Session

Sponsor Lunch Session - Microsoft

Level: Beginner
Lunch Session

Sponsor Lunch Session - Interworks

Level: Beginner
Lunch Session

Sponsor Lunch Session - Dell

Level: Beginner
Lunch Session

Sponsor Lunch Session - Violin Memory

Level: Beginner
01:30 PMBryan Smith

Overcoming Complex Data Cleansing Challenges with Excel Power Query

Level: Intermediate

download
Jennifer McCown

T-SQL Code Sins

Level: Beginner
Mike Byrd

Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Level: Intermediate

download
Amy Herold

Beginning Automation with Powershell

Level: Beginner
Patrick Bewley

Develop SQL Server Databases from Visual Studio: SQL Server Data Tools

Level: Intermediate
02:45 PMPam Matthews

Building an MDM Center of Excellence with MDS and Maestro

Level: Beginner
Jennifer McCown

Introduction to Powershell cmdlets for DBAs

Level: Beginner
Tom Norman

I’m New, Select Me!

Level: Beginner

download
Michael Bourgon

SQL Watchdog - find out instantly when SQL changes in production

Level: Intermediate

download
Tim Mitchell

Parent/Child Structures in SSIS

Level: Intermediate
04:00 PMDerek Dai

Data Discovery and Insights using Excel 2013 Power BI

Level: Advanced
Sean McCown

DIY Performance Reporting

Level: Intermediate
Jeremy Marx

BIML: Taking the Pain Out of Integration Services Development

Level: Intermediate
Ryan Adams

AlwaysOn Live Deployment

Level: Intermediate

download
Rudy Rodarte

Expand your TSQL: Intersect, Except, and Apply

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
15 Quick Tips for SSIS PerformanceTim MitchellIntermediate
60 Minutes for All Best Practices in SSIS DesignDerek DaiAdvanced
AlwaysOn Live DeploymentRyan AdamsIntermediate
Beginning Automation with PowershellAmy HeroldBeginner
BI Basics - Finding Return on DataAllen SmithBeginner
BIML: Taking the Pain Out of Integration Services DevelopmentJeremy MarxIntermediate
Building an ETL Framework with SSISTim MitchellIntermediate
Building an MDM Center of Excellence with MDS and MaestroPam MatthewsBeginner
Business Rules, Data Governance, and Workflow with MDS and MaestroPam MatthewsIntermediate
Change Tracking: A Near Bullet-Proof ETL Synchronization ControlMike ByrdIntermediate
ColumnStore Indexes in SQL 2014Allen SmithIntermediate
Converting Unreliable Deployments Into Consistent ReleasesTom NormanIntermediate
Data Discovery and Insights using Excel 2013 Power BIDerek DaiAdvanced
DBA Career RoadmapJennifer McCownBeginner
Design and Implement BI like Edison! William E Pearson IIIBeginner
Designing Stored Procedure SolutionsJennifer McCownBeginner
Develop SQL Server Databases from Visual Studio: SQL Server Data ToolsPatrick BewleyIntermediate
DIY Performance ReportingSean McCownIntermediate
Easy SQL Server BenchmarkingDavid KleeBeginner
ETL in a Nutshell with SSISBrett TomsonBeginner
Expand your TSQL: Intersect, Except, and ApplyRudy RodarteBeginner
Fill Factor: Performance or Nuisance?William BarnesIntermediate
Finding and Cleansing Data with Excel Power QueryBryan SmithBeginner
Fundamentals of SAN, NAS and IP StorageWesley BrownIntermediate
Getting Started with MDXWilliam E Pearson IIIBeginner
How to Argue with Your Infrastructure Admins – and WinDavid KleeBeginner
I’m New, Select Me!Tom NormanBeginner
INDEXING 101 - WHAT IS AN INDEX?Hakim AliBeginner
Introduction to Powershell cmdlets for DBAsJennifer McCownBeginner
Lunch BreakSQLSaturday 309Non-Technical
Making the Leap from Developer to DBAAmy HeroldBeginner
Mirroring Start to FinishRyan AdamsIntermediate
Overcoming Complex Data Cleansing Challenges with Excel Power QueryBryan SmithIntermediate
Parent/Child Structures in SSISTim MitchellIntermediate
Performance Benefits of Data CompressionMike ByrdIntermediate
Policy Based Management, Trolls and WatchmakersTom NormanBeginner
Possible Musics: Choosing between Analysis Services 2012 Multidimensional and TabularWilliam E Pearson IIIIntermediate
Power This, Power That...Making Sense of Power BIBrett TomsonBeginner
Pro Tips: Tuning the data flow in SSISTim CostelloIntermediate
RaffleSQLSaturday 309Non-Technical
REGEX for DBAsSean McCownIntermediate
RegistrationsSQLSaturday 309Non-Technical
Sanity Testing Your DataJK WoodIntermediate
Scripting in SSISTim MitchellIntermediate
Securing Semantic Models: Real World ScenariosBrett TomsonIntermediate
Source Code Control: Revision management for the data dude.Tim CostelloBeginner
Sponsor Lunch Session - DellLunch SessionBeginner
Sponsor Lunch Session - InterworksLunch SessionBeginner
Sponsor Lunch Session - MicrosoftLunch SessionBeginner
Sponsor Lunch Session - ProfiseeLunch SessionBeginner
Sponsor Lunch Session - Violin MemoryLunch SessionBeginner
SQL Server 2012 AlwaysON (HADR) for dummiesRohan JoackhimIntermediate
SQL Server Agent: The life preserver for the drowning DBALance TidwellBeginner
SQL Server on VMWare Monitoring: Optimized for PerformanceTrent ShermanBeginner
SQL Server Storage internals: Looking under the hood.Brandon LeachAdvanced
SQL Server Virtualization 101David KleeBeginner
SQL Watchdog - find out instantly when SQL changes in productionMichael BourgonIntermediate
Squeezing Top Performance from Your Virtualized SQL ServerDavid KleeIntermediate
Tableau: Delivering Self-Serve BITim CostelloBeginner
Temporary Query Items and YouJK WoodIntermediate
Through Gardens Overgrown: PowerPivot to SSAS 2012TabularWilliam E Pearson IIIBeginner
Tools You Probably Aren’t Using. Why Not?Mike TutorBeginner
Treating Tables Like Legos, Partitioning BasicsBrandon LeachBeginner
T-SQL Code Sins Jennifer McCownBeginner
T-SQL ThrowdownHakim AliIntermediate
Understanding Storage Systems and SQL Server Wesley BrownBeginner
Windowing FunctionsTim CostelloBeginner


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