sqlsathistory

Nr: 505

SQLSaturday #505 - Belgium 2016

Start Time (24h)	Speaker	Track	Title
10:00:00	Fabiano Amorim	DBA	Advanced SQL Server execution plans - level 400
10:00:00	Nico Jacobs	BI	Polybase in SQL Server 2016
11:20:00	Enrico van de Laar	DBA	No more waiting – an introduction to SQL Server wait statistics
11:20:00	Peter ter Braake	BI	DAX unraveled
13:20:00	Uwe Ricken	DBA	Mastering indexing maintenance with DMO like a PRO
13:20:00	Koen Verbeeck	BI	What's New in Integration Services 2016
14:40:00	Cédric Charlier	BI	It's time to refresh your data in Power BI!
14:40:00	Pieter Vanhove	DBA	Run Your DBA Morning Checklist with Policy-Based Management

SessionID: 44884

Advanced SQL Server execution plans - level 400

Back to calendar

Event Date: 19-03-2016 - Session time: 10:00:00 - Track: DBA

Speaker: Fabiano Amorim

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.

SessionID: 44939

Polybase in SQL Server 2016

Back to calendar

Event Date: 19-03-2016 - Session time: 10:00:00 - Track: BI

Speaker: Nico Jacobs

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.

SessionID: 42953

No more waiting – an introduction to SQL Server wait statistics

Back to calendar

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

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.

SessionID: 44545

DAX unraveled

Back to calendar

Event Date: 19-03-2016 - Session time: 11:20:00 - Track: BI

Speaker: Peter ter Braake

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.

SessionID: 42915

Mastering indexing maintenance with DMO like a PRO

Back to calendar

Event Date: 19-03-2016 - Session time: 13:20:00 - Track: DBA

Speaker: Uwe Ricken

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.

SessionID: 45172

What's New in Integration Services 2016

Back to calendar

Event Date: 19-03-2016 - Session time: 13:20:00 - Track: BI

Speaker: Koen Verbeeck

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.

SessionID: 44213

It's time to refresh your data in Power BI!

Back to calendar

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!

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!

SessionID: 45214

Run Your DBA Morning Checklist with Policy-Based Management

Back to calendar

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

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!

This site is open source. Improve this page.