SQLSaturday #505 - Belgium 2016

Event Date: 03/19/2016 00:00:00

Event Location:

  • SQLSaturday Belgium
  • Campus De Vest, Zandpoortvest 60, 2800 Mechelen
  • Mechelen, Antwerp, Belgium

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Mastering indexing maintenance with DMO like a PRO

Abstract: Make your business happy with well performing databases. To master these approaches you are responsible for well performing indexes which may not harm the daily business of your customers. With a handy toolset of common database management objects (DMO) you can become the superstar in your SQL Server team. Impress your team members when you detect common indexing issues like a pro with dmo’s.


  • Uwe Ricken

Track and Room: DBA - Room 2

Title: Advanced SQL Server execution plans - level 400

Abstract: Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server. This is a 500 level session, so, expect to see lots of traceflags, undocumented and nasty execution plans.


  • Fabiano Amorim

Track and Room: DBA - Room 2

Title: It’s time to refresh your data in Power BI!

Abstract: Making sure they are analyzing the last data available is often critical for your customers. From Excel files on a OneDrive folder to Azure IoT solutions, via enterprise or personal gateway, welcome to a world with many possibilities. Which one is the best-suited for your needs and your existing environment? This session includes many demos and proposes to explain, one by one, these different solutions. We’ll also discuss benefits, constraints, free or pro subscriptions and much more!


  • Cédric Charlier

Track and Room: BI - Room 1

Title: DAX unraveled

Abstract: DAX was created as an easier alternative for MDX with the introduction of PowerPivot. Multidimensional functionality with the look and feel of Excel functions and formulas. But the concept of context makes it more difficult than it might seem at a first glance. In this session we will learn to handle row-, query- and filter context by looking at a lot of practical examples.


  • Peter ter Braake

Track and Room: BI - Room 1

Title: No more waiting – an introduction to SQL Server wait statistics

Abstract: When you are standing in line at the grocery store you know exactly what you’re waiting for, paying the things you intend to buy. In SQL Server things aren’t usually so simple and many times you have to wait for more than only the length of the queue or the speed of the cashier. Thankfully SQL Server gathers the exact time you have been waiting and what resource you have been waiting on. In this session we will take a look at how SQL Server gathers this information and how it can help you identify, troubleshoot and proactively solve performance issues.


  • Enrico van de Laar

Track and Room: DBA - Room 2

Title: Polybase in SQL Server 2016

Abstract: If you want to mix traditional relational data with semi-structured data stored on Azure or Hadoop, then the out-of-the-box Polybase functionality in SQL Server 2016 is one of the easiest ways to get started with this.

In this session we first introduce the Polybase architecture, then show how to setup and query Polybase. This demo-rich session helps both developers and DBAs in understanding the potential and practical use of Polybase.


  • Nico Jacobs

Track and Room: BI - Room 1

Title: What’s New in Integration Services 2016

Abstract: SQL Server Integration Services is Microsoft’s leading data integration and transformation tool. In this session, we will take a look at which exciting new features SQL Server 2016 has to offer. You’ll discover how much easier SSIS development becomes and how you can integrate more easily with the cloud and big data. Join us in this demo-packed talk to find out what’s coming and put yourself ahead of the learning curve.


  • Koen Verbeeck

Track and Room: BI - Room 1

Title: Run Your DBA Morning Checklist with Policy-Based Management

Abstract: A good DBA performs a morning checklist every day, to verify that all the databases and SQL Servers are still in good condition. In larger environments, that checklist can become so time-consuming that you don’t even have time for a coffee! This session demonstrates how to use policy-based management to evaluate your servers. By the end of this session, you will be able to use this Solution to verify your own SQL Server environment in no time–and have plenty of time for your morning coffee!


  • Pieter Vanhove

Track and Room: DBA - Room 2


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Peter ter Braake

Twitter: - @pbraake

LinkedIn: Peter ter Braake

Peter ter Braake, SQL Server MVP, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQLSaturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.

Uwe Ricken

Twitter: - https://twitter.com/dbBerater

LinkedIn: Uwe Ricken

Contact: http://www.sqlmaster.de

Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.

Enrico van de Laar

Twitter: - twitter.com/evdlaar

LinkedIn: Enrico van de Laar

Contact: https://www.enricovandelaar.com

Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com

Fabiano Amorim

Twitter: - mcflyamorim

LinkedIn: Fabiano Amorim

Contact: http:\blogfabiano.com

Fabiano Amorim is a Data Platform MVP that loves to conquer complex, challenging problems—especially ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his family.

Pieter Vanhove

Twitter: - http://twitter.com/Pieter_Vanhove

LinkedIn: Pieter Vanhove

Contact: http://pietervanhove.azurewebsites.net/

Pieter Vanhove is a Premier Field Engineer at Microsoft Belgium and has been working with SQL Server since 2000. Pieter has a profound knowledge in implementing high availability and disaster recovery solutions and loves the new Azure stuff. Together with the dataMinds team in Belgium, he helps organizing dataMinds Connect and is also a regular speaker at Belgian and international events.

Cédric Charlier

Twitter: - @Seddryck

LinkedIn: Cédric Charlier

Contact: http://seddryck.wordpress.com

Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.

Nico Jacobs

Twitter: - sqlwaldorf

LinkedIn: Nico Jacobs

Contact: http://blogs.u2u.be/u2u/author/Nico-Jacobs.aspx

Dr. Nico Jacobs is a Microsoft Business Intelligence and SQL Server trainer at the U2U training center since 2004. Before that, he was a machine learning researcher at the university of Leuven, Belgium. At U2U, Nico creates and delivers courses on the SQL Server business intelligence stack (Integration Services, Analysis Services, Reporting Services …), Power BI, the traditional relational database environment (database development and administration) and the Azure AI and Big Data stack (Azure Data Factory, Machine Learning, Synapse Analytics,…)

Koen Verbeeck

Twitter: - Ko_Ver

LinkedIn: Koen Verbeeck

Contact: http://sqlkover.com/

Koen Verbeeck is a Business Intelligence professional working at AE. He helps clients to get insight in their data and to improve their business intelligence solutions. Koen has a decade of experience in developing data warehouses, cubes and reports using the Microsoft Data Platform. Koen has a blog at sqlkover.com and writes articles for MSSQLTips.com. He has been awarded the Microsoft Data Platform MVP award in 2017.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page