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 TimeA - Administration - Room: B - Business Intelligence & Big Data - Room: C - Cloud - Room: D - Development - Room:
09:00 AMMarkus Ehrenmueller-Jensen

Opening & Keynote

Level: Beginner

download
Markus Ehrenmueller-Jensen

Opening & Keynote

Level: Beginner

download
Markus Ehrenmueller-Jensen

Opening & Keynote

Level: Beginner

download
Markus Ehrenmueller-Jensen

Opening & Keynote

Level: Beginner

download
11:00 AMKevin Boles

Indexing Deep Dive

Level: Advanced

download
Peter Myers

Preparing a Tabular Data Model for Power View Reporting

Level: Intermediate

download
Scott Klein

Windows Azure SQL Database - your cloud database and why you need it

Level: Beginner

download
Kennie Pontoppidan

SQL anti patterns

Level: Advanced

download
12:15 PMRudolf Brandstötter

Product-Demo: Idera

Level: Beginner
Wolfgang Ennikl

Product-Demo: cubido

Level: Beginner
Jen Stirrup

WiT-Panel

Level: Beginner
Inna Selipanov

Product-Demo: MelissaData

Level: Beginner
01:00 PMBoris Hristov

The nightmare of locking, blocking and isolation levels!

Level: Intermediate

download
Andrey Zavadskiy

MDS + DQS + SSIS = EIM or How to build master data management solution

Level: Intermediate

download
Gerhard Brueckl

Scaling Analysis Services in the Cloud

Level: Advanced

download
Kevin Boles

Windowing Functions: THE Reason to Upgrade to 2012

Level: Intermediate

download
02:20 PMBoris Hristov

Replay your workload as it's your actual one!

Level: Intermediate

download
Rasmus Reinholdt

Optimizing BI with SQL2014 In-Memory tables

Level: Intermediate

download
Scott Klein

SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Level: Advanced

download
Constantin Klein

SQL Server Data Tools - The IDE for database developers

Level: Beginner

download
03:40 PMNiko Neugebauer

Clustered Columnstore Deep Dive

Level: Advanced

download
Tillmann & Oliver Eitelberg & Engels

Siena calling! Project Siena a RBID App?

Level: Intermediate

download
Jen Stirrup

The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBI

Level: Beginner
Matija Lah

FILETABLEs: What They Are and How to Use Them

Level: Advanced

download
5:00 PMWolfgang Rick Kutschera

SQL2014 InMemory OLTP - Features, Limitations, Reasons and Workarounds

Level: Advanced

download
David Peter Hansen

Deep dive into SQL Server Integration Services (SSIS) 2012 internals

Level: Advanced

download
Regis Baccaro

ETL for the masses with Power Query and "M"

Level: Intermediate

download
Dejan Sarka

Temporal Data in SQL Server

Level: Advanced

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
Advanced Body Language Secrets and FIVE second fixes: How to Use The New Body Language taught at tJanine DriverNon-Technical
.NET Development for the SQL Server DeveloperMarco ParenzanIntermediate
4 things that could optimize your data warehouseDavid Peter HansenIntermediate
Advanced DQS IntegrationTillmann & Oliver Eitelberg & EngelsIntermediate
Autogenerating a process data warehouseKennie PontoppidanAdvanced
Automate your SSIS development with BIMLAndré KammanIntermediate
Backup and Recovery: Basic recipesAndrey ZavadskiyBeginner
C# for SQL-Geeks - Data Driven ApplicationsChristian GiessweinBeginner
Clear View: The power of Window FunctionsConstantin KleinBeginner
Clustered Columnstore - IntroductionNiko NeugebauerBeginner
Clustered Columnstore Deep DiveNiko NeugebauerAdvanced
Common TSQL MistakesKevin BolesIntermediate
Data mining : discover patterns in your dataAlberto GastaldoBeginner
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Datenqualitätmit der DQS Componente in den Integration ServicesAlexander KarlIntermediate
DBAs are from Mars, SharePoint admins are from VenusRegis BaccaroIntermediate
Deep dive into SQL Server Integration Services (SSIS) 2012 internalsDavid Peter HansenAdvanced
Delayed durability: what are you willing to give up for the best performance?Mikhail GuryanovIntermediate
Dynamic code for efficient searching Ian MeadeIntermediate
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
ETL for the masses with Power Query and "M"Regis BaccaroIntermediate
File IO Stalls and Wait Stats - Tune Like Guru!Kevin BolesAdvanced
FILETABLEs: What They Are and How to Use ThemMatija LahAdvanced
From Big Data to secret sauce: power your organisation with PowerBIJen StirrupIntermediate
From Dashboarding zero to hero: theory and practice of dashboards Jen StirrupBeginner
Happy as a Pig in MuckAllan MitchellIntermediate
High Performance Statistical QueriesDejan SarkaAdvanced
Indexing Deep DiveKevin BolesAdvanced
Indexing Deep DiveKevin BolesAdvanced
Integration Services SCD (slowly changing dimensions) mit dem T-SQL MERGE statt mittels SCD-ControlAlexander KarlIntermediate
Introduction to Power QueryPeter MyersIntermediate
Introduction to SQL Server 2012 MDS and DQSPeter MyersIntermediate
Introduction to SQL Server Data MiningPeter MyersIntermediate
Let's Jive with HiveAllan MitchellIntermediate
Lightning fast EAV data model designPeter LarssonIntermediate
Load Testing With SQL Server ToolsNeil HamblyIntermediate
Mastering the Excel CUBE FunctionsPeter MyersIntermediate
MDS + DQS + SSIS = EIM or How to build master data management solutionAndrey ZavadskiyIntermediate
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
Microsoft Power BI 101Gerhard BruecklBeginner
Opening & KeynoteMarkus Ehrenmueller-JensenBeginner
Opening and KeynoteMarkus Ehrenmueller-JensenBeginner
Optimizing BI with SQL2014 In-Memory tablesRasmus ReinholdtIntermediate
Optimizing Temporal QueriesDejan SarkaAdvanced
Partitioning as a design patternKennie PontoppidanAdvanced
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Preparing a Tabular Data Model for Power View ReportingPeter MyersIntermediate
Product-Demo: cubidoWolfgang EnniklBeginner
Product-Demo: IderaRudolf BrandstötterBeginner
Product-Demo: MelissaDataInna SelipanovBeginner
Replay your workload as it's your actual one!Boris HristovIntermediate
Reporting Services mit Geospatial VisualizationAlexander KarlIntermediate
Rewrite Queries with SQL Server 2012Emanuele ZanchettinIntermediate
Scaling Analysis Services in the CloudGerhard BruecklAdvanced
Self-Service Big Data Analytics with Power BIPeter MyersIntermediate
Siena calling! Project Siena a RBID App?Tillmann & Oliver Eitelberg & EngelsIntermediate
SQL anti patternsKennie PontoppidanAdvanced
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server 2012 Statistical Semantic SearchMatija LahAdvanced
SQL Server 2014 in-memory OLTP (Hekaton) Deep DiveScott KleinIntermediate
SQL Server and XML QueryMatija LahAdvanced
SQL Server Data Tools - The IDE for database developersConstantin KleinBeginner
SQL Server HA and DR in a Windows Azure Virtual Machine – Deep DiveScott KleinAdvanced
SQL Server Query Performance Tuning: A 12-Step ProcessScott KleinIntermediate
SQL2014 InMemory OLTP - Features, Limitations, Reasons and WorkaroundsWolfgang Rick KutscheraAdvanced
SQLServer2012 as semantic search engineEmanuele ZanchettinIntermediate
SSIS Custom Data Flow ComponentsMatija LahAdvanced
SSISDB Catalog Deep DiveMatija LahAdvanced
StreamInsight: Complex Event Processing by MSConstantin KleinBeginner
Temporal Data in SQL ServerDejan SarkaAdvanced
The Accidental Business Intelligence Project ManagerJen StirrupBeginner
The nightmare of locking, blocking and isolation levels!Boris HristovIntermediate
The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBIJen StirrupBeginner
Tool Time! Tillmann & Oliver Eitelberg & EngelsIntermediate
T-SQL Performance Guidelines for better DB stress Shehap El-NagarAdvanced
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate
Windows Azure SQL Database - your cloud database and why you need itScott KleinBeginner
WiT-PanelJen StirrupBeginner
You need rules, you need Policy-Based Management!Boris HristovIntermediate


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