SQLSaturday #505 - Belgium 2016
Advanced SQL Server execution plans - level 400
Event Date: 19-03-2016 - Session time: 10:00:00 - Track: DBA
Speaker: Fabiano Amorim
Title: Advanced SQL Server execution plans - level 400
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.
Polybase in SQL Server 2016
Event Date: 19-03-2016 - Session time: 10:00:00 - Track: BI
Speaker: Nico Jacobs
Title: Polybase in SQL Server 2016
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.
No more waiting – an introduction to SQL Server wait statistics
Event Date: 19-03-2016 - Session time: 11:20:00 - Track: DBA
Speaker: Enrico van de Laar
Title: No more waiting – an introduction to SQL Server wait statistics
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.
Event Date: 19-03-2016 - Session time: 11:20:00 - Track: BI
Speaker: Peter ter Braake
Title: DAX unraveled
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.
Mastering indexing maintenance with DMO like a PRO
Event Date: 19-03-2016 - Session time: 13:20:00 - Track: DBA
Speaker: Uwe Ricken
Title: Mastering indexing maintenance with DMO like a PRO
What's New in Integration Services 2016
Event Date: 19-03-2016 - Session time: 13:20:00 - Track: BI
Speaker: Koen Verbeeck
Title: What's New in Integration Services 2016
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.
It's time to refresh your data in Power BI!
Event Date: 19-03-2016 - Session time: 14:40:00 - Track: BI
Speaker: Cédric Charlier
Title: It's time to refresh your data in Power BI!
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!
Run Your DBA Morning Checklist with Policy-Based Management
Event Date: 19-03-2016 - Session time: 14:40:00 - Track: DBA
Speaker: Pieter Vanhove
Title: Run Your DBA Morning Checklist with Policy-Based Management
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!