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
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).
Sessions
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.
Speaker(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.
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- Pieter Vanhove
Track and Room: DBA - Room 2
Speakers
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.
Sponsors
The following is a list of sponsors that helped fund the event: