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: GwithianTrack 2 - Room: FistralTrack 3 - Room: SidmouthTrack 4 - Room: Saunton
08:00 AMJen Stirrup

The Accidental Business Intelligence Project Manager

Level: Beginner

download
Rob Sewell

PowerShell Box of Tricks

Level: Beginner

download
David Williams

SQL Server 2014 New Features (not Hekaton!)

Level: Beginner
Ian Meade

Dynamic code for efficient searching

Level: Intermediate
09:00 AMKeynote Speaker

Keynote

Level: Non-Technical
Keynote Speaker

Keynote

Level: Non-Technical
Keynote Speaker

Keynote

Level: Non-Technical
Keynote Speaker

Keynote

Level: Non-Technical
09:25 AMStacia Misner

Reduce, Reuse, Recycle: Automating Your BI Framework

Level: Intermediate
André Kamman

SQL Server 2014 and Azure SQL DB - The Road Ahead

Level: Beginner
Hugo Kornelis

Powerful T-SQL Improvements that Reduce Query Complexity

Level: Intermediate

download
Satya (SQLMaster) Shyam Jayanty

Let's cook 'best SQL Server DBA practices'

Level: Intermediate
10:45 AMDave Ballantyne

Query Optimizer internals

Level: Advanced

download
Stuart Moore

PowerShell for the curious SQL Server DBA

Level: Intermediate

download
Emil Glownia

How to become a BI Developer?

Level: Beginner
William Durkin

SQL Server Consolidation - Resistance is Futile

Level: Intermediate

download
11:45 AMNeil Hambly

Effective Index Partitioning, Compression Strategy

Level: Intermediate
Stuart Moore

PowerShell for the curious SQL Server DBA

Level: Intermediate

download
Richard Munn

Policy-based what ? (Or how I learned to stop worrying and love PBM)

Level: Beginner
André Kamman

Automate your SSIS development with BIML

Level: Intermediate
1:45 PMMladen Prajdic

SQL Impossible: Restoring/Undeleting a table

Level: Advanced
Pieter Vanhove

1, 2, 3, … wait… 1, 2, 3, … many… SQL Servers

Level: Intermediate
Kevan Riley

Uncovering the hidden gems in execution plans

Level: Intermediate

download
Matija Lah

SSIS Custom Data Flow Components

Level: Advanced

download
3:00 PMDavid Morrison

Query Plans Deep Dive

Level: Advanced
Chris Testa-O'Neill

Exam Prep for Microsoft Exam 70-463: The Data Warehousing One!

Level: Beginner
Peter Larsson

Remodel your old EAV design

Level: Intermediate
Kevin Chant

Delivering PowerView with SQL Server 2014 and SharePoint 2013

Level: Beginner
4:00 PMJames Skipwith

SQL 2014 In-Memory: Could you? Would you? Why the fudge should you?

Level: Intermediate
David Postlethwaite

A real DBA don’t need a GUI -A Guided Tour of SQL Server Management Studio

Level: Beginner

download
Stephanie Locke

An introduction to R

Level: Beginner

download
Allan Mitchell

Hadoop for the Microsoft Guy

Level: Intermediate


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
"Cursors are Evil"Dave BallantyneIntermediate
1, 2, 3, … wait… 1, 2, 3, … many… SQL ServersPieter VanhoveIntermediate
A Big Data PrimerStacia MisnerBeginner
A real DBA don’t need a GUI -A Guided Tour of SQL Server Management StudioDavid PostlethwaiteBeginner
Advanced Data Visualisation with Reporting ServicesJen StirrupIntermediate
Advanced IndexingHugo KornelisAdvanced
An introduction to RStephanie LockeBeginner
Automate your SSIS development with BIMLAndré KammanIntermediate
Baselining your dev servers with SQL Server Data ToolsRichard MunnIntermediate
Column Level EncryptionDavid DyeBeginner
Configuring SQL Server Virtual Machines using Hyper-V on Windows 8 ProfessionalKevin ChantIntermediate
Create Your Own AggregateHugo KornelisAdvanced
Create Your Own Data TypeHugo KornelisAdvanced
Custom Replication w/ Service Broker and Change TrackingMladen PrajdicIntermediate
Data Visualisation with Hadoop Mashups, Power View and Excel 2013Jen StirrupIntermediate
Database Design: Size DOES MatterThomas LaRockIntermediate
Database Replication - What, How and WhyWilliam DurkinBeginner
DBAs - extend your trace capability without impactSatya (SQLMaster) Shyam JayantyIntermediate
Dealing With Errors in SSIS 2012David DyeAdvanced
Delivering a successful BI solutionIan MeadeNon-Technical
Delivering PowerView with SQL Server 2014 and SharePoint 2013Kevin ChantBeginner
DUPLICATE Custom Replication w/ Service Broker and CDCMladen PrajdicIntermediate
Dynamic code for efficient searching Ian MeadeIntermediate
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
Estimation and Statistics : The Basis of query optimizationDave BallantyneAdvanced
Everything you always wanted to know about MERGE (but were afraid to ask)Hugo KornelisBeginner
Exam Prep for Microsoft Exam 70-463: The Data Warehousing One!Chris Testa-O'NeillBeginner
Extended Events – Effective UsageNeil HamblyIntermediate
FILETABLEs: What They Are and How to Use ThemMatija LahAdvanced
From SQL Traces to Extended Events. The next big switch.Mladen PrajdicIntermediate
Getting Started with SQL Server Service BrokerHugo KornelisIntermediate
Hadoop for the Microsoft GuyAllan MitchellIntermediate
Happy as a Pig in MuckAllan MitchellIntermediate
Harder, Better, Stronger and more securePieter VanhoveIntermediate
How to become a BI Developer? Emil GlowniaBeginner
Implementing Auditing in SQL Server 2012David DyeBeginner
Inside the Columnstore Index - Deep DiveHugo KornelisAdvanced
Introducing Power BIStacia MisnerBeginner
KeynoteKeynote SpeakerNon-Technical
Let's cook 'best SQL Server DBA practices'Satya (SQLMaster) Shyam JayantyIntermediate
Let's Jive with HiveAllan MitchellIntermediate
Make Your Queries Fly With Columnstore IndexesHugo KornelisIntermediate
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Policy-based what ? (Or how I learned to stop worrying and love PBM)Richard MunnBeginner
Power View from the Data Visualisation PerspectiveJen StirrupIntermediate
Powerful T-SQL Improvements that Reduce Query ComplexityHugo KornelisIntermediate
PowerShell Box of TricksRob SewellBeginner
PowerShell for the curious SQL Server DBAStuart MooreIntermediate
Query Optimizer internalsDave BallantyneAdvanced
Query Performance Tuning - A practical approachKevan RileyBeginner
Query Plans Deep DiveDavid MorrisonAdvanced
Quiz Session: Simpler and Faster Data Analysis with SQL Server 2012/2014Emil GlowniaBeginner
Reduce, Reuse, Recycle: Automating Your BI FrameworkStacia MisnerIntermediate
Remodel your old EAV designPeter LarssonIntermediate
Room Change. .Non-Technical
SQL 2014 In-Memory: Could you? Would you? Why the fudge should you?James SkipwithIntermediate
SQL Impossible: Restoring/Undeleting a table Mladen PrajdicAdvanced
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server 2012 Statistical Semantic SearchMatija LahAdvanced
SQL Server 2014 and Azure SQL DB - The Road AheadAndré KammanBeginner
SQL Server 2014 New Features (not Hekaton!)David WilliamsBeginner
SQL Server and XML QueryMatija LahAdvanced
SQL Server Consolidation - Resistance is FutileWilliam DurkinIntermediate
SQL Server Data platform upgrade Techniques, best practices & notes from the fieldSatya (SQLMaster) Shyam JayantyAdvanced
SQL Server High Availability: Overview & SolutionsSatya (SQLMaster) Shyam JayantyAdvanced
SQL Server Replication BasicsDavid WilliamsIntermediate
SSIS Custom Data Flow ComponentsMatija LahAdvanced
SSIS Log Providers, Custom Logging, and Event HandlersDavid DyeBeginner
SSISDB Catalog Deep DiveMatija LahAdvanced
Statistics, Estimation & Plan Caching - The Big ThreeDavid MorrisonIntermediate
Taking BI to the Next Level: CollaborationStacia MisnerBeginner
tbcJames Rowland-JonesBeginner
The “Dark side” of SSIS transformations!Emil GlowniaIntermediate
The Accidental Business Intelligence Project ManagerJen StirrupBeginner
Uncovering the hidden gems in execution plansKevan RileyIntermediate
Understanding IndexesHugo KornelisIntermediate
User-defined functions, or: How to kill performance in one easy stepHugo KornelisIntermediate
Whats New in T-SQL With SQL Server 2012David DyeBeginner
When bad things happen to good SQLDavid MorrisonIntermediate
When is Kimball the perfect match for Data VaultEmil GlowniaIntermediate


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
An introduction to HekatonBeginner
SQL Azure Beginner
What's new in SQL Server 2014Beginner

SQLSaturday Home
PASS