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 TimeGorm - Room: DiscoveryHarald - Room: JupiterKnud - Room: KantinenMagnus - Room: Kantinen 2Svend - Room: A+B
8:30 AMRégis Baccaro

Welcome & Keynote

Level: Non-Technical
Régis Baccaro

Welcome & Keynote

Level: Non-Technical
Régis Baccaro

Welcome & Keynote

Level: Non-Technical
Régis Baccaro

Welcome & Keynote

Level: Non-Technical
Régis Baccaro

Welcome & Keynote

Level: Non-Technical
9:20 AMAndreas Wolter

SQL Server 2014 In-Memory OLTP / XTP Management Deep Dive

Level: Advanced

download
Milos Radivojevic

SQL Server 2014 - New Cardinality Estimator

Level: Advanced

download
Aaron Nelson

PowerShell for Data Professionals

Level: Intermediate
Bjorn D. Jensen

Why proper data quality and modelling matters

Level: Beginner
Hans Hansen

Encryption in SQL Server - things to consider before flipping the switch

Level: Intermediate

download
10:20 AMGlenn Berry

Analyzing I/O Subsystem Performance

Level: Intermediate

download
Mark Stacey

Overview of a PDW project

Level: Intermediate
David Peter Hansen

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

Level: Advanced
Jens Melhede

Sponsor session + Michael Frandsen - Meet the Windows Flash Array (WFA): Win2k12R2 + Violin Array

Level: Intermediate
SQLSaturday 275

Women in Technology

Level: Non-Technical
11:30 AMJen Stirrup

Let's PowerBI Denmark with Big Data!

Level: Intermediate
André Kamman

Automate your SSIS development with BIML

Level: Intermediate
Jens Vestergaard

Analysis Services Security

Level: Advanced

download
Salvatore Buccoliero

Sponsor session - Using Fusion ioMemory to leverage Buffer Pool Extension and In-memory OLTP capabil

Level: Intermediate
Marcin Szeliga

Indexing for denormalization

Level: Intermediate
1:10 PMMarco Russo

Optimizing DAX Analyzing Query Plans

Level: Advanced

download
Carmel Gunn

The Irish Economic Crisis, Visualized with Power BI

Level: Beginner
Hugo Kornelis

Advanced Indexing

Level: Advanced

download
Eric Sink

Sponsor session - Zumero for SQL Server

Level: Beginner
Brian Bønk

Dynamic Partitioning Cubes

Level: Advanced

download
2:20 PMMichael Frandsen

High Performance Infrastructure for SQL Server 2014

Level: Advanced

download
Christina Leo

Building Your T-SQL Tool Kit: Window Function Fundamentals

Level: Intermediate

download
Neil Hambly

SQL Server 2012 Memory Management

Level: Intermediate
Satya (SQLMaster) Shyam Jayanty

Let's cook 'best SQL Server DBA practices'

Level: Intermediate
Kennie Pontoppidan

Autogenerating a process data warehouse

Level: Advanced

download
3:50 PMUwe Ricken

INSERT / UPDATE / DELETE - deep dive

Level: Advanced

download
Erik Svensen

Prepare your Excel Power Pivot models for QA

Level: Intermediate

download
Just Blindbaek

Unit testing Analysis Services

Level: Intermediate

download
Boris Hristov

Replay your workload as it's your actual one!

Level: Intermediate

download
Mikael Wedham

Practical use of the SSIS Script components

Level: Intermediate

download
5:00 PMMark S. Rasmussen

Recovering Data from Fatally Corrupt Databases

Level: Advanced
Bob Duffy

MIgrating to the Azure and the cloud

Level: Intermediate

download
Rasmus Reinholdt

Optimizing BI with SQL2014 In-Memory tables

Level: Intermediate

download
Kenneth Nielsen

Microsoft Master Data Services - Used for more than just data management

Level: Advanced

download
Steen Dybboe

Window Functions Unleashed

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
.NET Development for the SQL Server DeveloperMarco ParenzanIntermediate
“SQL Attack…ed” – SQL Server under attack.Andreas WolterAdvanced
4 things that could optimize your data warehouseDavid Peter HansenIntermediate
Advanced Data Visualisation with Reporting ServicesJen StirrupIntermediate
Advanced IndexingHugo KornelisAdvanced
Advanced Reporting Techniques & Managing ReportsSubramani ParamasivamIntermediate
Analysis Services for the DBAMark StaceyBeginner
Analysis Services SecurityJens VestergaardAdvanced
Analyzing I/O Subsystem PerformanceGlenn BerryIntermediate
Autogenerating a process data warehouseKennie PontoppidanAdvanced
Automate your SSIS development with BIMLAndré KammanIntermediate
BI is maturing - BI applications for specific industriesMark StaceyNon-Technical
Building Your T-SQL Tool Kit: Window Function FundamentalsChristina LeoIntermediate
Create Your Own AggregateHugo KornelisAdvanced
Create Your Own Data TypeHugo KornelisAdvanced
Dashboard madness with PerformancePoint ServicesJust BlindbækIntermediate
Dashboard tools - comparison of the many possibilities in SharePointJust BlindbækBeginner
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Database history class 101Kennie PontoppidanNon-Technical
DAX Query Engine Internals Marco RussoAdvanced
DBAs - extend your trace capability without impactSatya (SQLMaster) Shyam JayantyIntermediate
Deep Dive from DB Developer Perspective of SQL Server 2014 In-Memory OLTP TechnologyBelkis OzhorasanIntermediate
Deep dive into SQL Server Integration Services (SSIS) 2012 internalsDavid Peter HansenAdvanced
DMV for administration of indexesUwe RickenAdvanced
Does the optimistic concurrency resolve your blocking problems?Margarita NaumovaAdvanced
Dos and Don'ts of Columnstore indexesRasmus ReinholdtAdvanced
Dr. DMV's Troubleshooting ToolkitGlenn BerryIntermediate
Dynamic Partitioning CubesBrian BønkAdvanced
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
Encryption in SQL Server - things to consider before flipping the switchHans HansenIntermediate
Entity Framework 6 New FeaturesMihail MateevIntermediate
Error catchingBjorn D. JensenBeginner
Everything you always wanted to know about MERGE (but were afraid to ask)Hugo KornelisBeginner
Excel Services 2013 - the BI frontend of the futureJust BlindbækBeginner
Extended Events - The Top FeaturesAndreas WolterIntermediate
FILLFACTOR - Pro and ConUwe RickenAdvanced
Find and tune those queries!Margarita NaumovaAdvanced
From Dashboarding zero to hero: theory and practice of dashboardsJen StirrupBeginner
From Dashboarding zero to hero: theory and practice of dashboardsJen StirrupBeginner
Getting started with encryption in SQL ServerHans HansenBeginner
Getting Started with SQL Server Service BrokerHugo KornelisIntermediate
Harvesting Honey with Hive, HDInsight and SQLJen StirrupIntermediate
High Performance Infrastructure for SQL Server 2014Michael FrandsenAdvanced
Improving Reporting Services using DAXMarco RussoIntermediate
Indexing for denormalizationMarcin SzeligaIntermediate
INSERT / UPDATE / DELETE - deep diveUwe RickenAdvanced
Inside the Columnstore Index - Deep DiveHugo KornelisAdvanced
Inside xVelocity In-Memory Engine Marco RussoAdvanced
Integration Services RundownJens VestergaardBeginner
Introduction to Power QueryErik SvensenIntermediate
Let's cook 'best SQL Server DBA practices'Satya (SQLMaster) Shyam JayantyIntermediate
Let's PowerBI Denmark with Big Data!Jen StirrupIntermediate
Load Testing Analysis ServicesBob DuffyAdvanced
Make Your Queries Fly With Columnstore IndexesHugo KornelisIntermediate
MDS + DQS + SSIS = EIM or How to build master data management solutionAndrey ZavadskiyIntermediate
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
Memory Grant – what is it, do I have control here?Margarita NaumovaAdvanced
Microsoft Master Data Services - Used for more than just data managementKenneth NielsenAdvanced
Microsoft Master Data Services - Used for more than just data managementKenneth NielsenAdvanced
Microsoft PDW - What is this acronym about?Kenneth NielsenIntermediate
MIgrating to the Azure and the cloudBob DuffyIntermediate
Optimising a dot.net solution on the SQL platformBob DuffyIntermediate
Optimizing BI with SQL2014 In-Memory tablesRasmus ReinholdtIntermediate
Optimizing DAX Analyzing Query PlansMarco RussoAdvanced
Overview of a PDW projectMark StaceyIntermediate
Partitioning in Analysis ServicesJens VestergaardAdvanced
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Power BI for Office 365 - a Complete Self-Service BI in the CloudMihail MateevIntermediate
Powerful T-SQL Improvements that Reduce Query ComplexityHugo KornelisIntermediate
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Practical use of the SSIS Script componentsMikael WedhamIntermediate
Prepare your Excel Power Pivot models for QAErik SvensenIntermediate
Recovering Data from Fatally Corrupt DatabasesMark S. RasmussenAdvanced
Replay your workload as it's your actual one!Boris HristovIntermediate
Rewrite Queries with SQL Server 2012Emanuele ZanchettinIntermediate
Salesforce – integrate with SQL ServerKenneth NielsenIntermediate
Secret Recipe on High Performance DatabaseSubramani ParamasivamAdvanced
Sponsor session - Using Fusion ioMemory to leverage Buffer Pool Extension and In-memory OLTP capabilSalvatore BuccolieroIntermediate
Sponsor session - Zumero for SQL Server Eric SinkBeginner
Sponsor session + Michael Frandsen - Meet the Windows Flash Array (WFA): Win2k12R2 + Violin ArrayJens MelhedeIntermediate
SQL 2014 Availability Groups. From on premise to cloudBob DuffyIntermediate
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server 2012 Parallel Data Warehouse (PDW v2)Belkis OzhorasanIntermediate
SQL Server 2012 Parallel Data Warehouse (PDW v2)Belkis OzhorasanIntermediate
SQL Server 2014 - New Cardinality EstimatorMilos RadivojevicAdvanced
SQL Server 2014 - What's in it for you?Andreas WolterIntermediate
SQL Server 2014 In-Memory OLTP / XTP Management Deep DiveAndreas WolterAdvanced
SQL Server Data platform upgrade Techniques, best practices & notes from the fieldSatya (SQLMaster) Shyam JayantyAdvanced
SQL Server HA 2008 R2, 2012 & 2014: Overview & SolutionsSatya (SQLMaster) Shyam JayantyIntermediate
SQL Server HA 2008 R2, 2012 & 2014: Overview & SolutionsSatya (SQLMaster) Shyam JayantyIntermediate
SQL Server in motion - Page SplitsUwe RickenBeginner
SSAS – Gesundheit!Jens VestergaardBeginner
SSIS Patterns-Performance testing, parallel packagMark StaceyIntermediate
Stored procedures — facts and mythsMarcin SzeligaAdvanced
The Accidental Business Intelligence Project ManagerJen StirrupBeginner
The Good, Bad and Ugly of Cloud ReportingMihail MateevIntermediate
The Irish Economic Crisis, Visualized with Power BICarmel GunnBeginner
The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBIJen StirrupAdvanced
Top .NET Developer Tips, Tricks & MistakesMark S. RasmussenIntermediate
Top 10 things you shouldn’t do with your databaseMargarita NaumovaIntermediate
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
Understanding IndexesHugo KornelisIntermediate
Unit testing Analysis ServicesJust BlindbaekIntermediate
User-defined functions, or: How to kill performance in one easy stepHugo KornelisIntermediate
Using Power BI to enrich your data with public datasetsErik SvensenAdvanced
Welcome & KeynoteRégis BaccaroNon-Technical
Whaf if I could use my Microsoft BI tools on my wife…David SmeetsNon-Technical
When built-in features not are enough...Bjorn JensenAdvanced
Why proper data quality and modelling mattersBjorn D. JensenBeginner
Window Functions UnleashedSteen DybboeAdvanced
Women in Technology SQLSaturday 275Non-Technical
Working with cubes, examples based on real casesBjorn JensenAdvanced
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