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: A 057DBA - Room: A 059DEV - Room: A 061Mixed - Room: A 063Open - Room: C 116
08:00 AMSQLSaturday 313

Registrations

Level: Non-Technical
SQLSaturday 313

Registrations

Level: Non-Technical
SQLSaturday 313

Registrations

Level: Non-Technical
SQLSaturday 313

Registrations

Level: Non-Technical
SQLSaturday 313

Registrations

Level: Non-Technical
09:00 AMSQLSaturday 313

Address of welcome (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Address of welcome (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Address of welcome (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Address of welcome (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Address of welcome (Raum A 048)

Level: Non-Technical
09:15 AMMatija Lah

SSIS Custom Data Flow Components

Level: Advanced

download
Sascha Lorenz

PowerShell 101 für SQL Administratoren

Level: Intermediate

download
Christoph Muthmann Uwe Ricken

Performancesteigerung durch Window Functions

Level: Intermediate

download
Oliver Engels Tillmann Eitelberg

Siena calling! Project Siena a RBID App?

Level: Beginner
Scott Klein

MongoDB on Windows Azure

Level: Beginner
10:15 AMSQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
10:45 AMDavid Peter Hansen

SSIS internals and performance

Level: Advanced
Milos Radivojevic

SQL Server 2014 - New Cardinality Estimator

Level: Advanced

download
Constantin Klein

Unit Testing and Continuous Deployment for DB-Development?

Level: Beginner

download
Stephan Köppen

ROLAP mit der PDW - Endlich der nötige Performanceboost

Level: Intermediate
Mihail Mateev

Node.js for Microsoft SQLServer Nerds

Level: Intermediate

download
12:00 PMJean-Pierre Riehl

Power Query vs. SSIS, which one is the most powerful?

Level: Advanced
Chris Testa-O'Neill

We have control! Resource Control in SQL Server

Level: Intermediate
Boris Hristov

The nightmare of locking, blocking and isolation levels!

Level: Intermediate

download
Andreas Wolter

Columnstore, In-Memory, Page oder Row-Compressed, OLTP vs OLAP – SQL Server 2014 Speichertypen

Level: Intermediate

download
David Postlethwaite

Beware of the Dark Side - A Guided Tour of Oracle for the SQL Server DBA

Level: Intermediate

download
01:00 PMSQLSaturday 313

Lunch Break

Level: Non-Technical
SQLSaturday 313

Lunch Break

Level: Non-Technical
SQLSaturday 313

Lunch Break

Level: Non-Technical
SQLSaturday 313

Lunch Break

Level: Non-Technical
SQLSaturday 313

Lunch Break

Level: Non-Technical
01:45 PMRoland Rosenau

Sponsor Session by Fusion-io (Raum A 057)

Level: Beginner
Roland Rosenau

Sponsor Session by Fusion-io (Raum A 057)

Level: Beginner
Roland Rosenau

Sponsor Session by Fusion-io (Raum A 057)

Level: Beginner
Roland Rosenau

Sponsor Session by Fusion-io (Raum A 057)

Level: Beginner
Roland Rosenau

Sponsor Session by Fusion-io (Raum A 057)

Level: Beginner
02:30 PMFlorian Eiden

Agile Datawarehousing: tips and tricks to deliver your BI solution using Agile methodolgy like SCRUM

Level: Intermediate
Sergey Olontsev

Data Corruption: how to detect, resolve and prevent

Level: Intermediate
Dr. Holger Schwichtenberg

Datenzugriff mit Entity Framework – brauchbar oder einfach nur langsam?

Level: Beginner
Martin Kopp

Column Store Index 2012 vs. 2014

Level: Beginner
Jascha Knack Harm Knolle

Yahoo Cloud Serving Benchmark - MS SQL Server vs. MongoDB

Level: Beginner
03:45 PMAlexander Karl

Anwenden u. Erweitern des SSIS CatalogDB für ein Logging Framework

Level: Intermediate

download
William Durkin

Database Replication - What, How and Why

Level: Beginner

download
Scott Klein

SQL Server 2014 Top 5 - Hybrid Features

Level: Intermediate
Niko Neugebauer

Clustered Columnstore Deep Dive

Level: Advanced

download
Oliver Engels Tillmann Eitelberg

SSIS und HDInsight - Zwei Welten treffen aufeinander?

Level: Beginner
04:45 PMSQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
SQLSaturday 313

Coffee Break

Level: Non-Technical
05:15 PMChristoph Seck

From XML to Nested Sets: Handling Hierarchies with SQL Server

Level: Intermediate
Frank Geisler Klaus Höltgen

Always ON 2014

Level: Beginner

download
Sascha Dittmann

MapReduce in der Praxis

Level: Intermediate
Dejan Sarka

Analyzing Text with SQL Server 2014

Level: Intermediate

download
Marcel Franke

SAP HANA, Power Pivot, SQL Server - In-Memory-Technologien im Vergleich

Level: Intermediate
06:15 PMSQLSaturday 313

Raffle (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Raffle (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Raffle (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Raffle (Raum A 048)

Level: Non-Technical
SQLSaturday 313

Raffle (Raum A 048)

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
--- to be discardedAndreas WolterNon-Technical
??? Question ??? - Has Power BI Q&A the answer?Oliver EngelsBeginner
10 Tipps für die Reporting ServicesChristoph MuthmannIntermediate
2 AM. A Disaster just began...Tobiasz KoprowskiIntermediate
A real DBA don’t need a GUI -A Guided Tour of SQL Server Management StudioDavid PostlethwaiteBeginner
Address of welcome (Raum A 048)SQLSaturday 313Non-Technical
Advanced Customer Analysis in Power Pivot using DAXGerhard BruecklIntermediate
Advanced Query Tuning TechniquesGuy GlantserAdvanced
Agile Data WarehousingChristoph SeckNon-Technical
Agile Datawarehousing: tips and tricks to deliver your BI solution using Agile methodolgy like SCRUMFlorian EidenIntermediate
Alarm for data governance! - Self Service BI is coming!Oliver Engels Tillmann EitelbergIntermediate
Always ON 2014Frank Geisler Klaus HöltgenBeginner
Analyzing Query Plans Deep DiveSergey OlontsevAdvanced
Analyzing Text with SQL Server 2014Dejan SarkaIntermediate
Anwenden u. Erweitern des SSIS CatalogDB für ein Logging FrameworkAlexander KarlIntermediate
Azure SQL Database Tips and Tricks for BeginnersTobiasz KoprowskiIntermediate
Beware of the Dark Side - A Guided Tour of Oracle for the SQL Server DBADavid PostlethwaiteIntermediate
BIG DATA MINING WITH MAHOUTPaco GonzalezIntermediate
Building abstract layers for data protection and business logicUwe RickenBeginner
Bulk load: methods for better data warehouse load performanceDavid Peter HansenAdvanced
Change Data Capture als Teil einer ETL ArchitekturSascha LorenzIntermediate
Clustered Columnstore - IntroductionNiko NeugebauerBeginner
Clustered Columnstore Deep DiveNiko NeugebauerAdvanced
Coffee BreakSQLSaturday 313Non-Technical
Column Store Index 2012 vs. 2014Martin KoppBeginner
Columnstore, In-Memory, Page oder Row-Compressed, OLTP vs OLAP – SQL Server 2014 SpeichertypenAndreas WolterIntermediate
Complex Event Processing (CEP) with StreamInsightSandra GeislerIntermediate
Connection - Session - RequestUwe RickenAdvanced
Continuous Delivery - Don't forget the Database!David AtkinsonLightning Talk
Data Corruption: how to detect, resolve and preventSergey OlontsevIntermediate
Database Replication - What, How and WhyWilliam DurkinBeginner
Datenqualität mit der DQS Componente in den Integration ServicesAlexander KarlIntermediate
Datenzugriff mit Entity Framework – brauchbar oder einfach nur langsam?Dr. Holger SchwichtenbergBeginner
Dealing with Entity Framework 6.1Mihail MateevIntermediate
Deep-Dive to Analysis Services SecurityGerhard BruecklAdvanced
Dimension Security in OLAP and TabularChristoph SeckIntermediate
DMV for administration of indexesUwe RickenAdvanced
DQS step-by-step ins Domain Management, Knowledge Discovery und in die Matching PoliciesAlexander KarlIntermediate
Dynamic code for efficient searching Ian MeadeIntermediate
Exam Prep for Microsoft Exam 70-463: The Data Warehousing One!Chris Testa-O'NeillBeginner
Extended Events - Die Top FeaturesAndreas WolterIntermediate
Extended Events to the RescueGuy GlantserIntermediate
Fasten Seat Belt and look at the Data Stewardjean-pierre riehlIntermediate
FILLFACTOR - Pro and ConUwe RickenAdvanced
From XML to Nested Sets: Handling Hierarchies with SQL ServerChristoph SeckIntermediate
High Performance Statistical QueriesDejan SarkaAdvanced
How to Use Parameters Like a Pro and Boost PerformanceGuy GlantserAdvanced
Hybrid architecture with Power BIjean-pierre riehlIntermediate
Identity Mapping and De-Duplicating Dejan SarkaAdvanced
Increasing Business and IT collaboration with SQL ServerChris Testa-O'NeillIntermediate
INSERT / UPDATE / DELETE - deep diveUwe RickenAdvanced
Integration Services SCD (slowly changing dimensions) mit dem T-SQL MERGE statt mittels SCD-ControlAlexander KarlBeginner
Lunch BreakSQLSaturday 313Non-Technical
Maintenance Plans ad HocTobiasz KoprowskiIntermediate
Manage Your Workload with Resource Governor in SQL Server 2014Guy GlantserIntermediate
MapReduce in der PraxisSascha DittmannIntermediate
Microsoft SQL Server 2012 Selective XML IndexMatija LahAdvanced
Modern BI Solutions with Power BI, Office 365 and Windows AzureMarcel FrankeIntermediate
MongoDB on Windows AzureScott KleinBeginner
Moving applications to SQL Server 2014 In-Memory OSergey OlontsevIntermediate
Node.js for Microsoft SQLServer NerdsMihail MateevIntermediate
NodeXL in ActionNiko NeugebauerBeginner
Open Source Software Development using Node.js, Microsoft Azure Storage and Azure SQL Database Mihail MateevBeginner
Optimizing Temporal QueriesDejan SarkaAdvanced
Partitioning - SQL Server 2014 Style (HA)Niko NeugebauerAdvanced
Performance & Manageability der tempdbTorsten SchüßlerIntermediate
Performancesteigerung durch Window FunctionsChristoph Muthmann Uwe RickenIntermediate
Permission Management: 12 Pitfalls & MisconceptionsSebastian MeineIntermediate
Power Query vs. SSIS, which one is the most powerful?Jean-Pierre RiehlAdvanced
PowerShell 101 für SQL AdministratorenSascha LorenzIntermediate
Practical usage of partitioning Sergey OlontsevIntermediate
Query Progress Tracking in SQL ServerMatan YungmanIntermediate
Raffle (Raum A 048)SQLSaturday 313Non-Technical
RegistrationsSQLSaturday 313Non-Technical
Replay your workload and save the business! Boris HristovIntermediate
Replication Troubleshooting & MonitoringWilliam DurkinIntermediate
Restoring Databases with PowershellJohan BijnensBeginner
ROLAP ist das neue HOLAP ?Sascha LorenzAdvanced
ROLAP mit der PDW - Endlich der nötige PerformanceboostStephan KöppenIntermediate
SAP HANA, Power Pivot, SQL Server - In-Memory-Technologien im VergleichMarcel FrankeIntermediate
Schnell, schneller, SSISMarcel FrankeAdvanced
Securing a Multi-Database ApplicationSebastian MeineIntermediate
Siena calling! Project Siena a RBID App?Oliver Engels Tillmann EitelbergBeginner
Small Changes Can Make a World of DifferenceMatan YungmanIntermediate
Sponsor Session by Fusion-io (Raum A 057)Roland RosenauBeginner
SQL Server 2012 Statistical Semantic SearchMatija LahAdvanced
SQL Server 2014 - Highlights in der Datenbank-Engine im ÜberblickAndreas WolterIntermediate
SQL Server 2014 - In-Memory OLTPTommy WarneckeIntermediate
SQL Server 2014 - New Cardinality EstimatorMilos RadivojevicAdvanced
SQL Server 2014 Memory-optimized Data ExchangeMatija LahAdvanced
SQL Server 2014 OLTP (Hekaton) Deep DiveScott KleinIntermediate
SQL Server 2014 Top 5 - Hybrid FeaturesScott KleinIntermediate
SQL Server basierte SharePoint 2013 Apps mit LightSwitch entwickelnFrank GeislerIntermediate
SQL Server Consolidation - Resistance is FutileWilliam DurkinIntermediate
SQL Server Cryptology PrimerSebastian MeineIntermediate
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 in motion - Page SplitsUwe RickenBeginner
SQL Server Source ControlTobiasz KoprowskiBeginner
SQL Server und Powershell - Eine starke KombinationFrank GeislerIntermediate
SSIS Custom Data Flow ComponentsMatija LahAdvanced
SSIS internals and performanceDavid Peter HansenAdvanced
SSIS und HDInsight - Zwei Welten treffen aufeinander?Oliver Engels Tillmann EitelbergBeginner
SSISDB Catalog Deep DiveMatija LahAdvanced
SSISDB-KatalogMarkus DelhofenAdvanced
Survival Guide to Power BI Q&A for French peoplejean-pierre riehlBeginner
Taming the Beast – How a SQL DBA can keep Kerberos under controlDavid PostlethwaiteAdvanced
Temporal Data in SQL ServerDejan SarkaAdvanced
The Good, Bad and Ugly of Cloud ReportingMihail MateevIntermediate
The nightmare of locking, blocking and isolation levels!Boris HristovIntermediate
Things You Can Find in the Plan CacheMatan YungmanAdvanced
Trace Flags in SQL Server die jeder Administrator kennen sollte, Best PracticesAndreas WolterIntermediate
Unit Testing and Continuous Deployment for DB-Development?Constantin KleinBeginner
We have control! Resource Control in SQL ServerChris Testa-O'NeillIntermediate
What's New in SQL Server 2014Guy GlantserIntermediate
Why Are We WaitingSrikanth Singh BidhaniyaAdvanced
Working with Very Large Tables Like a Pro in SQL Server 2014Guy GlantserAdvanced
Yahoo Cloud Serving Benchmark - MS SQL Server vs. MongoDBJascha Knack Harm KnolleBeginner


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
Entity Framework: Brauchbar oder einfach langsam?Beginner

SQLSaturday Home
PASS