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 TimeBonus - Room: Reed EFBusiness Intelligence - Room: Reed CDBA - Room: Reed ABDeveloper - Room: Reed D
08:30 AMWilliam E Pearson III

Practical Self-Service BI with Excel 2010/2013

Level: Beginner
Russ Loski

Introduction to BIML and BIMLScript

Level: Intermediate

download
Matthew Brimer

SQL Security Best Practices & Shrinking Your Attack Surface

Level: Intermediate

download
Kat Meadows

Database Design from User Requirements

Level: Intermediate
09:45 AMKristin Ferrier

3D Geospatial Visualization Using Power Map

Level: Beginner
Tim Mitchell

Handling Errors and Data Anomalies in SSIS

Level: Intermediate
John Sterrett

Table Partitioning: the Secret Weapon for your Big Data Problems.

Level: Beginner

download
David Stein

Have You Got the Urge to (T-SQL) Merge?

Level: Intermediate
11:00 AMBryan Smith

Let's Hadoop!

Level: Beginner

download
William E Pearson III

Getting Started with Analysis Services 2012 Tabular

Level: Beginner
Kat Meadows

Case Studies of Disaster Recovery

Level: Intermediate
Jennifer McCown

Unraveling Tangled Code

Level: Intermediate
12:15 PMAdam Herbert

Sponsor Lunch Session - Nimble Storage

Level: Beginner
Tim Costello

Sponsor Lunch Session - Interworks

Level: Beginner
David Swanson

Sponsor Lunch Session - Dell Software

Level: Beginner
Jason McKittrick

Sponsor Lunch Session - Microsoft

Level: Beginner
01:30 PMRyan Adams

How Active Directory affects SQL Server

Level: Advanced

download
Tim Costello

Agile Data Warehouse Design

Level: Beginner
Sean McCown

Beginning Powershell for DBAs 1.0

Level: Beginner
Allen Smith

Sharing SQL Data in SharePoint

Level: Beginner

download
02:45 PMDavid Stein

Data Warehouse Mistakes You Can’t Afford to Make

Level: Intermediate
Garret Edmondson

Scaling a SQL Data Warehouse to 100s of TBs

Level: Intermediate

download
Ben Miller

SMO Internals for High Performance PowerShell

Level: Advanced

download
Rob Sullivan

SQL Server vs The World

Level: Beginner
04:00 PMSean and Jen McCown

Mouth Wide Shut: Interviews from the Other Side of the Table

Level: Non-Technical
Garret Edmondson

Data Warehouse ETL

Level: Beginner

download
John Sterrett

Building Your First AlwaysOn Failover Cluster Instance

Level: Beginner

download
Russ Loski

Introduction to the XML Source

Level: Intermediate

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
Bryan SmithBeginner
12 Steps to Workload TuningJohn SterrettBeginner
3D Geospatial Visualization Using Power MapKristin FerrierBeginner
Agile Data Warehouse DesignTim CostelloBeginner
AlwaysOn Live DeploymentRyan AdamsIntermediate
Asynch Processing – Building a Service Broker AppMike HotekIntermediate
Automate your daily checklist with PBM and CMSJohn SterrettIntermediate
Beginning Powershell for DBAs 1.0Sean McCownBeginner
Beginning Powershell for DBAs 1.5Sean McCownBeginner
Beginning T-SQLJennifer McCownBeginner
Benchmarking, Baselines and Monitoring StorageWesley BrownBeginner
Beyond Plateaux: Optimize SSAS via Best PracticesWilliam E Pearson IIIIntermediate
Build a Scalable Data Validation FrameworkMike HotekIntermediate
Building Your First AlwaysOn Failover Cluster InstanceJohn SterrettBeginner
Case Studies of Disaster RecoveryKat MeadowsIntermediate
Creating an SSIS template using BIMLRuss LoskiIntermediate
Data Modeling – From Conceptual Model to Database DeploymentMike HotekIntermediate
Data Quality Framework - Fixing the Garbage PileMike HotekIntermediate
Data Security – Encrypting DataMike HotekIntermediate
Data Warehouse ETLGarret EdmondsonBeginner
Data Warehouse Mistakes You Can’t Afford to MakeDavid SteinIntermediate
Database Design from User RequirementsKat MeadowsIntermediate
Designing a Scalable, Flexible SSIS FrameworkMike HotekIntermediate
Dimensions, It's All Meaningless Without Them David SteinIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E Pearson IIIIntermediate
Extreme Design – A Real World 10+ Exabyte Data WarehouseMike HotekIntermediate
Getting Control of Your Data - Master Data ManagementMike HotekIntermediate
Getting Started with Analysis Services 2012 TabularWilliam E Pearson IIIBeginner
Handling Errors and Data Anomalies in SSISTim MitchellIntermediate
Have You Got the Urge to (T-SQL) Merge?David SteinIntermediate
High Performance Aggregates Using Windows FunctionsMike HotekAdvanced
How Active Directory affects SQL ServerRyan AdamsAdvanced
Implement High Performance, Agile, BI MethodologyMike HotekIntermediate
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Introduction to the XML SourceRuss LoskiIntermediate
Keep the Business Happy – Overview of HA FeaturesMike HotekIntermediate
Knowledge from Data–FileTable and Semantic SearchMike HotekIntermediate
Let's Hadoop!Bryan SmithBeginner
Manage your shop with CMS and Policy Based MgmtRyan AdamsBeginner
Managing Hierarchies in SQL ServerMike HotekIntermediate
Maximizing SSIS Package PerformanceTim MitchellIntermediate
Mirroring Start to FinishRyan AdamsBeginner
Mouth Wide Shut: Coherent InterviewingSean & Jen McCownBeginner
Mouth Wide Shut: Interviews from the Other Side of the TableSean and Jen McCownNon-Technical
Performance Analysis – Finding What Needs TuningMike HotekIntermediate
Practical Self-Service BI with Excel 2010/2013William E Pearson IIIBeginner
Scaling a SQL Data Warehouse to 100s of TBsGarret EdmondsonIntermediate
Scripting in SSISTim MitchellIntermediate
Sharing SQL Data in SharePointAllen SmithBeginner
SMO Internals for High Performance PowerShellBen MillerAdvanced
Sponsor Lunch Session - Dell SoftwareDavid SwansonBeginner
Sponsor Lunch Session - InterworksTim CostelloBeginner
Sponsor Lunch Session - MicrosoftJason McKittrickBeginner
Sponsor Lunch Session - Nimble StorageAdam HerbertBeginner
SQL 2012 AlwaysOn QuickstartRyan AdamsBeginner
SQL LogShipping with PowerShellBen MillerIntermediate
SQL Security Best Practices & Shrinking Your Attack SurfaceMatthew BrimerIntermediate
SQL Server 2014 – In memory OLTP DevelopmentMike HotekIntermediate
SQL Server 2014 – In memory OLTP ManagementMike HotekIntermediate
SQL Server IndexingMike HotekAdvanced
SQL Server Maintenance PlansKat MeadowsBeginner
SQL Server Statistics InternalsMike HotekAdvanced
SQL Server Storage InternalsMike HotekAdvanced
SQL Server TDEBen MillerIntermediate
SQL Server Unit TestingMike HotekIntermediate
SQL Server vs The WorldRob SullivanBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS Configurations Vs. ParametersAllen SmithIntermediate
Storage Tuning Deep DiveWes BrownIntermediate
Table Partitioning: the Secret Weapon for your Big Data Problems.John SterrettBeginner
Tell Better Stories with Microsoft BI and GeoFlowmarek koenigBeginner
The Art of the Mythical DemoMike HotekIntermediate
The Backup Tune-upSean McCownIntermediate
The Cheap Replica: Offloading with Transactional ReplicationJohn SterrettBeginner
Through Gardens Overgrown: PowerPivot to SSAS 2012TabularWilliam E Pearson IIIBeginner
Top 10 New BI Features of Excel 2013Bryan SmithBeginner
Turn Data into an Asset - Enterprise Data GovernanceMike HotekIntermediate
Understanding BackupsSean McCownBeginner
Understanding Storage Systems and SQL ServerWesley BrownBeginner
Unraveling Tangled CodeJennifer McCownIntermediate
What is Big Data?Bryan SmithBeginner
What is this cache and how did it get so big?Doug BrendleIntermediate
When a Strange Server CallsJennifer McCownBeginner
Where Is It? – Working with Spatial DataMike HotekIntermediate
Who's viewing your data? Doug BrendleIntermediate
You are NOT a Junior DBADavid SteinBeginner


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