| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Klaus Aschenbrenner | Database Development | The dangerous beauty of Bookmark Lookups |
| 09:00:00 | M Streutker | Data Science | An introduction to Data Science |
| 09:00:00 | Bob Duffy | Business Intelligence | Desigining Complex Tabular Models - A Case Study |
| 09:00:00 | David Williams | SQL Server 2016 | SQL Server 2016 New Feaures (Not Query Store!) |
| 09:00:00 | Tobias Koprowski | Cloud | SQL Security in the Cloud |
| 10:15:00 | Jeffrey Verheul | Data Science | Boost your analytical superpowers with spatial data |
| 10:15:00 | Aaron Bertrand | Database Development | T-SQL : Bad Habits Best Practices |
| 10:15:00 | Joost van Rossum | SQL Server 2016 | What's new in SSIS 2016 |
| 10:15:00 | Gabi Münster | Business Intelligence | Scoped assignments – Threat or salvation? Some real life experiences… |
| 10:15:00 | Denny Cherry | Database Adminstration | Optimizing SQL Server Performance in a Virtual Environment |
| 10:15:00 | Scott Klein | Business Intelligence | Big Data for the SQL Ninja |
| 11:30:00 | Tanja Vukov | Data Science | Azure Machine Learning - drag, drop, predict |
| 11:30:00 | Neil Hambly | Database Adminstration | Performance Troubleshooting Using DMVs |
| 11:30:00 | Jan Pieter Posthuma | Business Intelligence | Power BI API |
| 11:30:00 | Edgar Walther | SQL Server 2016 | Temporal Tables in SQL 2016 |
| 13:30:00 | David Postlethwaite | Database Adminstration | Taming the Beast – How a SQL DBA can keep Kerberos under control |
| 13:30:00 | Niels Naglé | Data Science | Dive into NoSQL with Azure |
| 13:30:00 | Pieter Vanhove | SQL Server 2016 | SQL Server 2016 Security Innovations |
| 13:30:00 | Hugo Kornelis | Database Development | Now Where Did THAT Estimate Come From? - Part 1 |
| 13:30:00 | Jan Van humbeek | Business Intelligence | Datazen – Microsoft’s shiny dashboard-tool |
| 13:30:00 | Henk van der Valk | BI Platform Architecture, Development Administration | Introductie van Azure SQL Data Warehouse (MPP in de cloud) |
| 14:45:00 | John Martin | Database Adminstration | Monitoring SQL Server, Key performance metrics and how to interpret them |
| 14:45:00 | Leonard Lobel | Cloud | Introduction to Azure DocumentDB |
| 14:45:00 | Henk Vlootman | Business Intelligence | Best practices in modelling Power pivot. |
| 14:45:00 | Enrico van de Laar | Database Adminstration | Debugging SQL Server |
| 14:45:00 | Joseph D'Antoni | Cloud | Flying Through the Clouds--Performance Tuning in Azure |
| 14:45:00 | Hugo Kornelis | Database Development | Now Where Did THAT Estimate Come From? - Part 2 |
| 16:00:00 | Dandy Weyn | Cloud | Become the DBA of the future, everything you need to know about A |
| 16:00:00 | Dejan Sarka | Data Science | SQL Server Power BI Geographic and Temporal Predictions |
| 16:00:00 | Peter Jonk | SQL Server 2016 | Moving away from SQL Profiler to use Extended Events |
| 16:00:00 | Sander van der hoeff | Business Intelligence | Agile BI from the cloud with Team Foundation Services |
| 16:00:00 | Niall MacLeod | Business Intelligence | Microsoft SQL Server Data Warehouse Fast Track – Understanding th |
Event Date: 26-09-2015 - Session time: 09:00:00 - Track: Database Development
Event Date: 26-09-2015 - Session time: 09:00:00 - Track: Data Science
But what does it take to be a Data Scientist? And how do you get started? This session will give you a brief introduction to Data Science. We’ll explore the steps involved to take on an analytical endeavour, and show how these concepts work with several demos. Attend this session and discover what (Microsoft) tools and technologies you can use to extract value from (big) data! This session will be co-presented by Maarten van Duren.
Event Date: 26-09-2015 - Session time: 09:00:00 - Track: Business Intelligence
This one hour session will walk through an actual case study of a tabular model and discuss the pain points we encountered on the way, along with solutions and workarounds.
Event Date: 26-09-2015 - Session time: 09:00:00 - Track: SQL Server 2016
Event Date: 26-09-2015 - Session time: 09:00:00 - Track: Cloud
Event Date: 26-09-2015 - Session time: 10:15:00 - Track: Data Science
In this session, we're going to take a look at how spatial data works, how you can query it, and how to use it to leverage your decision making process.
Event Date: 26-09-2015 - Session time: 10:15:00 - Track: Database Development
Event Date: 26-09-2015 - Session time: 10:15:00 - Track: SQL Server 2016
Event Date: 26-09-2015 - Session time: 10:15:00 - Track: Business Intelligence
Sometimes your projects get that complex. You will need to choose between many options and it might get hard to even measure the impact or test out all consequences. This session will not answer all your questions, but you will get some real life experiences on what better not to do…
Event Date: 26-09-2015 - Session time: 10:15:00 - Track: Database Adminstration
We will discuss how to look for CPU performance issues at the host level. We will also be looking at the Memory Balloon drivers and what they actually do, as well as how you should be configuring them and why.
We will then talk about some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server, and we’ll finish up the session with some storage configuration options.
Event Date: 26-09-2015 - Session time: 10:15:00 - Track: Business Intelligence
Event Date: 26-09-2015 - Session time: 11:30:00 - Track: Data Science
Event Date: 26-09-2015 - Session time: 11:30:00 - Track: Database Adminstration
We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available
Event Date: 26-09-2015 - Session time: 11:30:00 - Track: Business Intelligence
Event Date: 26-09-2015 - Session time: 11:30:00 - Track: SQL Server 2016
Event Date: 26-09-2015 - Session time: 13:30:00 - Track: Database Adminstration
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
Event Date: 26-09-2015 - Session time: 13:30:00 - Track: Data Science
Microsoft Azure supports a variety of NoSQL technologies (i.e. key/value, document, column and graph databases). In this session we walk through the options, explaining what each one provides.
Event Date: 26-09-2015 - Session time: 13:30:00 - Track: SQL Server 2016
Event Date: 26-09-2015 - Session time: 13:30:00 - Track: Database Development
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates. Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Event Date: 26-09-2015 - Session time: 13:30:00 - Track: Business Intelligence
In this session we will discover what it has to offer and what kind of effort is needed for publishing your very own dashboards. We will go through local dashboards on Excel and evolve to a basic server setup with your dashboards published to mobile devices and SharePoint. Let us guide you on your way to the future of mobile BI.
Event Date: 26-09-2015 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 26-09-2015 - Session time: 14:45:00 - Track: Database Adminstration
Event Date: 26-09-2015 - Session time: 14:45:00 - Track: Cloud
Event Date: 26-09-2015 - Session time: 14:45:00 - Track: Business Intelligence
Event Date: 26-09-2015 - Session time: 14:45:00 - Track: Database Adminstration
In this session we will debug the various parts of SQL Server using WinDbg. I’ll show you how to setup, configure and use WinDbg to extract information from a running SQL Server process. We will take a look at the various dump files that record information when a SQL Server crash occurs, capturing valuable information on why SQL Server crashed. And finally, I will demonstrate how you can use Extended Events to create dump files when specific conditions occur, helping you learn more about why they occur.
Don't worry if you are not a programmer. We will go through this session at a relaxed pace without causing (too many) headaches!
Event Date: 26-09-2015 - Session time: 14:45:00 - Track: Cloud
• Optimizing TempDB in an Azure VM • Reducing latency between application VMs and database VMs • Right sizing Azure VMs for performance and cost • Striping I/O across devices in Azure VMs • Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.
Event Date: 26-09-2015 - Session time: 14:45:00 - Track: Database Development
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates. Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Event Date: 26-09-2015 - Session time: 16:00:00 - Track: Cloud
Become the DBA of the future!
Event Date: 26-09-2015 - Session time: 16:00:00 - Track: Data Science
Event Date: 26-09-2015 - Session time: 16:00:00 - Track: SQL Server 2016
Extended Events were first introduced in SQL Server 2008 and should be used instead of the SQL Profiler. Still lots of DBA's and DEV's use SQL Profiler nowadays because of the convenience and lack of an Extended Events GUI in SQL 2008. Extended events however impose a minimal performance penalty on SQL Server and provides much more detailed tracing.
Event Date: 26-09-2015 - Session time: 16:00:00 - Track: Business Intelligence
With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more.
In my session you will get the directions to a quick start with Visual Studio Online. You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.
Event Date: 26-09-2015 - Session time: 16:00:00 - Track: Business Intelligence