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 Time1 - DBA - Room: Room 12 - Developers - Room: Room 23 - Business Intelligence - Room: Room 34 - Super Development - Room: Room 45 - Mixed Data - Room: Room 56 - Clustered Data - Room: Room 67 - Free Data - Room: Room 7
08:30 AMGlobal Community

Keynote

Level: Non-Technical
      
09:00 AMJohan Bijnens

Powershell: The DBA as a consumer

Level: Beginner

download
Quilson Antunes

Data auditing

Level: Intermediate

download
Oliver Engels Julian Breunung

M versus P versus R - Languages for Data Exploration

Level: Intermediate

download
Constantin Klein

SQL Server Data Tools - The IDE for database developers

Level: Beginner

download
Regis Baccaro

DBAs are from Mars, SharePoint admins are from Venus

Level: Intermediate

download
Paulo Matos

Project Sienna - The gist

Level: Beginner

download
Nabeel Derhem

Introduction to NoSQL

Level: Intermediate
10:15 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
Oliver Engels Tillmann Eitelberg

Power BI - The self service BI Lifecycle in the cloud

Level: Beginner

download
Scott Klein

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

Level: Advanced
Artur Vieira

SQL PDW vs SQL Server, let's see the big differences

Level: Intermediate

download
Allan Mitchell

Happy as a Pig in Muck

Level: Intermediate
Pedro Simoes

Good fellows: System Center and SQL Server

Level: Beginner

download
11:45 AMBrent Ozar

Real-Life SQL 2012 and 2014 Availability Group Deployments

Level: Intermediate

download
Mihail Mateev

Entity Framework 6 New Features

Level: Intermediate

download
Tim Mitchell

Handling Errors and Data Anomalies in SSIS

Level: Beginner
Bob Duffy

Optimising a dot.net solution on the SQL platform

Level: Intermediate

download
Hugo Kornelis

Create Your Own Aggregate

Level: Advanced

download
Fernando Marçal

Smart SSIS with BIML

Level: Intermediate

download
Global Community

Women in Technology

Level: Non-Technical
12:45 PMGlobal Community

Almoço

Level: Non-Technical
Global Community

Almoço

Level: Non-Technical
Global Community

Almoço

Level: Non-Technical
Global Community

Almoço

Level: Non-Technical
Global Community

Almoço

Level: Non-Technical
Global Community

Almoço

Level: Non-Technical
Global Community

Almoço

Level: Non-Technical
01:45 PMNiko Neugebauer

Clustered Columnstore Deep Dive

Level: Advanced

download
Turgay Sahtiyan

Top 10 Performance Tips for SQL Server Developers

Level: Intermediate

download
Tim Mitchell

15 Quick Tips for SSIS Performance

Level: Intermediate
Matija Lah

SQL Server and XML Query

Level: Advanced

download
Jen Stirrup

Power View from the Data Visualisation Perspective

Level: Intermediate
Murilo Miranda

Clustered Instance - Storage Introduction

Level: Intermediate

download
Peter ter Braake

MDX, it is not that hard!

Level: Intermediate

download
02:45 PMGlobal Community

Sponsor Session

Level: Non-Technical
Global Community

Sponsor Session

Level: Non-Technical
Global Community

Sponsor Session

Level: Non-Technical
    
03:30 PMBrent Ozar

How to Think Like the Engine

Level: Intermediate

download
Milos Radivojevic

Hekaton challenges from Database Development point of view

Level: Advanced

download
Paul Turley

Visualization Choices: What, When, and How?

Level: Intermediate

download
Sergey Olontsev

Analyzing Query Plans Deep Dive

Level: Advanced

download
Edwin Sarmiento

Integrating Big Data with SharePoint 2013

Level: Intermediate
Ruben Pertusa

Improving our BI solutions with Geolocated data

Level: Intermediate
Paul te Braak

Analytical Data Mining - Using Data Mining to Understand Data

Level: Intermediate

download
05:00 PMEdwin Sarmiento

The Transaction Log and How It Affects HA/DR

Level: Intermediate
Dejan Sarka

High Performance Statistical Queries

Level: Advanced

download
Paul Turley

Tabular Models: Easier & Faster Than Cubes; Really?

Level: Intermediate

download
Etienne Lopes

Securing SQL Server

Level: Intermediate
Bruno Basto

Data in, Information out

Level: Intermediate

download
Mark Broadbent

Olde Cluster Curiosity Shoppe - A Miscellany of top tips from the field

Level: Advanced
Global Community

Lightning Talks

Level: Beginner


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
“SQL Attack…ed” – SQL Server under attack.Andreas WolterAdvanced
10 Tips and Tricks for better SSIS PerformanceDavid Peter HansenAdvanced
15 Quick Tips for SSIS PerformanceTim MitchellIntermediate
4 things that could optimize your data warehouseDavid Peter HansenIntermediate
A Deep Dive in SQL Server 2012 Data WarehousingDejan SarkaAdvanced
Access Services are cool! Are you kidding? :)Oliver EngelsBeginner
Advanced Data Visualisation with Reporting ServicesJen StirrupIntermediate
Advanced Data Visualization with SQL Server ReportTillmann Eitelberg Oliver EngelsIntermediate
Advanced IndexingHugo KornelisAdvanced
AlmoçoGlobal CommunityNon-Technical
Analytical Data Mining - Using Data Mining to Understand DataPaul te BraakIntermediate
Analyzing Query Plans Deep DiveSergey OlontsevAdvanced
Architecting a SQL Server AlwaysOn Availability Groups TopologyEdwin SarmientoAdvanced
BI - It's not just for analysts anymoreJohn WhiteIntermediate
Clear View: The power of Window FunctionsConstantin KleinBeginner
Clustered Columnstore & DataWareHousing Niko NeugebauerBeginner
Clustered Columnstore Deep DiveNiko NeugebauerAdvanced
Clustered Instance - Storage IntroductionMurilo MirandaIntermediate
Configure SharePoint for Business IntelligenceJohn WhiteIntermediate
Converting websites into Sources of DataPedro CorreiaLightning Talk
Create Your Own AggregateHugo KornelisAdvanced
Create Your Own Data TypeHugo KornelisAdvanced
Custom Replication w/ Service Broker and Change TrMladen PrajdicIntermediate
Data auditingQuilson AntunesIntermediate
Data Corruption: how to detect, resolve and preventSergey OlontsevIntermediate
Data in, Information outBruno BastoIntermediate
Data Visualisation with Hadoop Mashups, Power View and Excel 2013Jen StirrupIntermediate
Database Administration StrategiesMurilo MirandaIntermediate
DBA SQL Server por AcidenteMarcus Vinícius BittencourtBeginner
DBAs are from Mars, SharePoint admins are from VenusRegis BaccaroIntermediate
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
Does the optimistic concurrency resolve your blocking problems?Margarita NaumovaAdvanced
Dynamic code for efficient searching Ian MeadeIntermediate
Dynamic code for efficient searching Ian MeadeIntermediate
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
Enterprise Development Rodrigo PintoNon-Technical
Entity Framework 6 New FeaturesMihail MateevIntermediate
ETL for the masses with Power Query and "M"Regis BaccaroIntermediate
Everything you always wanted to know about MERGE (but were afraid to ask)Hugo KornelisBeginner
Extended Events - The Top FeaturesAndreas WolterIntermediate
FILETABLEs: What They Are and How to Use ThemMatija LahAdvanced
Find and tune those queries!Margarita NaumovaAdvanced
First look at the In-Memory OLTP component in SQL Server 2014David Peter HansenAdvanced
From Dashboarding zero to hero: theory and practice of dashboardsJen StirrupBeginner
From MDS to SSRS - a short walkthroughGabi Münster Matthias KaufmannBeginner
From SQL Traces to Extended Events. The next big switch.Mladen PrajdicIntermediate
Getting Started with SQL Server Service BrokerHugo KornelisIntermediate
Good fellows: System Center and SQL ServerPedro SimoesBeginner
HA&DR with SQL Server AlwaysOn Availability GroupsTurgay SahtiyanIntermediate
Hadoop for the Microsoft GuyAllan MitchellIntermediate
Handling Errors and Data Anomalies in SSISTim MitchellBeginner
Happy as a Pig in MuckAllan MitchellIntermediate
Harvesting Honey with Hive, HDInsight and SQLJen StirrupIntermediate
Hekaton challenges from Database Development point of viewMilos RadivojevicAdvanced
Help Yourself - Self Service Data Retrieval With Power QueryJohn WhiteIntermediate
High Performance Statistical QueriesDejan SarkaAdvanced
How to Think Like the EngineBrent OzarIntermediate
How to Think Like the EngineBrent OzarIntermediate
Identity Mapping and De-Duplicating Dejan SarkaAdvanced
Improve your Database Performance in Seven Simple StepsHugo KornelisBeginner
Improving our BI solutions with Geolocated dataRuben PertusaIntermediate
Inside the Columnstore Index - Deep DiveHugo KornelisAdvanced
Integrating Big Data with SharePoint 2013Edwin SarmientoIntermediate
Introduction to Extended EventsVitor PombeiroBeginner
Introduction to NoSQLNabeel DerhemIntermediate
KeynoteGlobal CommunityNon-Technical
Lessons From the Field with SSRS SharePoint ModeJohn WhiteIntermediate
Let's cook 'best SQL Server DBA practices'Satya (SQLMaster) Shyam JayantyIntermediate
Let's Jive with HiveAllan MitchellIntermediate
Let's PowerBI Portugal! Jen StirrupBeginner
Let's PowerBI Portugal! Jen StirrupBeginner
Lightning TalksGlobal CommunityBeginner
Load Testing With SQL Server ToolsNeil HamblyIntermediate
M versus P versus R - Languages for Data ExplorationOliver Engels Julian BreunungIntermediate
Make the SQL Agent your best friend.Klaus Höltgen Gabi MünsterIntermediate
Make Your Queries Fly With Columnstore IndexesHugo KornelisIntermediate
Managing Your Alibi With Social MediaNiko NeugebauerIntermediate
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
MDX, it is not that hard!Peter ter BraakeIntermediate
Memory Grant – what is it, do I have control here?Margarita NaumovaAdvanced
MIgrating to the Azure and the cloudBob DuffyIntermediate
New Cardinality Estimator OverviewPedro LopesAdvanced
New Cardinality Estimator OverviewPedro LopesAdvanced
Olde Cluster Curiosity Shoppe - A Miscellany of top tips from the fieldMark BroadbentAdvanced
Operational Reporting and Dashboarding using Microsoft Business Intelligence SolutionsJohn WhiteIntermediate
Optimising a dot.net solution on the SQL platformBob DuffyIntermediate
Optimizing Temporal QueriesDejan SarkaAdvanced
Partitioning - SQL Server 2014 StyleNiko NeugebauerAdvanced
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Power BI - The self service BI Lifecycle in the cloudOliver Engels Tillmann EitelbergBeginner
Power BI - What Is It, How Does it Work, and Why Does It MatterJohn WhiteIntermediate
Power BI Deep Dive - Tips and Tricks From the Preview ProgramJohn WhiteIntermediate
Power BI for Office 365 - a Complete Self-Service BI in the CloudMihail MateevIntermediate
Power View from the Data Visualisation PerspectiveJen StirrupIntermediate
PowerBI Upside DownJoão LopesIntermediate
Powerful T-SQL Improvements that Reduce Query ComplexityHugo KornelisIntermediate
Powershell: The DBA as a consumerJohan BijnensBeginner
Practical usage of partitioning Sergey OlontsevIntermediate
Project Sienna - The gistPaulo MatosBeginner
Real-Life SQL 2012 and 2014 Availability Group DeploymentsBrent OzarIntermediate
Replay your workload as it's your actual one!Boris HristovIntermediate
Replay your workload as it's your actual one!Boris HristovIntermediate
Restoring Databases with PowershellJohan BijnensBeginner
Rocking with SQL 2012 Extended EventsJody RobertsIntermediate
Scripting in SSISTim MitchellIntermediate
Securing SQL ServerEtienne LopesIntermediate
Server Core. What it is ? Why ? How ? (R2 Edition)Pedro SimoesBeginner
Set Up, Configure and Fine Tune your SharePoint 2013 Database Rodrigo PintoIntermediate
SharePoint Apps , new developing paradigmsRodrigo PintoLightning Talk
SharePoint Apps , new developing paradigmsRodrigo PintoLightning Talk
SharePoint Apps with a Windows Azure SQL Database Rodrigo PintoBeginner
Smart SSIS with BIMLFernando MarçalIntermediate
Smart SSIS with BIMLFernando MarçalIntermediate
Sponsor SessionGlobal CommunityNon-Technical
SQL 2014 Availability Groups. From on premise to cloudBob DuffyIntermediate
SQL DAC(Dedicated Administrator Connection)Quilson AntunesLightning Talk
SQL Impossible: Restoring/Undeleting a table Mladen PrajdicAdvanced
SQL Injection from website to SQL ServerMladen PrajdicIntermediate
SQL PDW vs SQL Server, let's see the big differencesArtur VieiraIntermediate
SQL Server : Anti - Forensics - When the bad guys WIN!Pedro CorreiaAdvanced
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SQL Server 2012 Statistical Semantic SearchMatija LahAdvanced
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 2014 OLTP (Hekaton) Deep DiveScott KleinIntermediate
SQL Server and XML QueryMatija LahAdvanced
SQL Server Data CompressionQuilson AntunesAdvanced
SQL Server Data platform upgrade Techniques, best practices & notes from the fieldSatya (SQLMaster) Shyam JayantyAdvanced
SQL Server Data Tools - The IDE for database developersConstantin KleinBeginner
SQL Server Data Tools - The IDE for database developersConstantin KleinBeginner
SQL Server HA 2008 R2, 2012 & 2014: Overview & SolutionsSatya (SQLMaster) Shyam JayantyIntermediate
SQL Server HA and DR in a Windows Azure Virtual Machine – Deep DiveScott KleinAdvanced
SQL Server Page verification option, why it is important for every DBA?Ignacio Salom RangelAdvanced
Sql Server PartitioningQuilson AntunesIntermediate
SQL Server Query Performance Tuning: A 12-Step ProcessScott KleinIntermediate
SQLPS 2014 - what's newJohan BijnensBeginner
SQLServer in Windows Azure Virtual MachinesVitor TomazBeginner
SSIS Custom Data Flow ComponentsMatija LahAdvanced
SSISDB Catalog Deep DiveMatija LahAdvanced
Storage - Melhores Práticas com SQL Server 2012Marcus Vinícius BittencourtIntermediate
Tabular Models: Easier & Faster Than Cubes; Really? Paul TurleyIntermediate
Taking the Driver's Seat: Lead-Motivate-Inspire!Brian BlaskoIntermediate
Temporal Data in SQL ServerDejan SarkaAdvanced
Ten cool trics in SSRSPeter ter BraakeIntermediate
The Accidental Business Intelligence Project ManagerJen StirrupBeginner
The Good, Bad and Ugly of Cloud ReportingMihail MateevIntermediate
The GovernorVitor PombeiroBeginner
The Irish Economic Crisis, Visualised with Power BICarmel GunnBeginner
The 'Secret Sauce' in your Big Data: R, HDInsight and PowerBIJen StirrupAdvanced
The Transaction Log and How It Affects HA/DREdwin SarmientoIntermediate
Tool Time! Tillmann Eitelberg Oliver EngelsIntermediate
Top 10 Performance Tips for SQL Server DevelopersTurgay SahtiyanIntermediate
Top 10 things you shouldn’t do with your databaseMargarita NaumovaIntermediate
TSQL Performance TipsMilos RadivojevicIntermediate
Understanding IndexesHugo KornelisIntermediate
Unit Testing and Continuous Deployment for DB-Development?Constantin KleinBeginner
User-defined functions, or: How to kill performance in one easy stepHugo KornelisIntermediate
User-defined functions, or: How to kill performance in one easy stepHugo KornelisIntermediate
Visualization Choices: What, When, and How?Paul TurleyIntermediate
Who wants to be DBAllionaire?Pedro CorreiaIntermediate
Windows Azure SQL Database - your cloud database and why you need itScott KleinBeginner
Windows Azure StorageVitor TomazBeginner
Women in TechnologyGlobal CommunityNon-Technical
You need rules, you need Policy-Based Management!Boris HristovIntermediate
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