AGENDA

We reserver the right to change speakers/sessions

07:30 am – 09:00 am

REGISTRATION & BREAKFAST

09:00 am – 10:45 am

WELCOME & KEYNOTES

KEYNOTE
VISUALIZATION: A TRUTHFUL ART
by 
Alberto Cairo, Visualization Expert

Abstract

In the past two decades, software tools to design visualizations of data have improved at an accelerating pace, and they’ve become both more affordable —free, in many cases,— and easier to use. Unfortunately, that growth hasn’t been accompanied by an increased understanding of the principles and rules of thumb that we should apply to choose which kind of graphic is more appropriate for each kind of message, or to arrange several graphics into data narratives. This session will provide an introduction to these techniques.

KEYNOTE
vNext overview

by Joe Sack, Principal Program Manager, Microsoft Engineering

KEYNOTE
AI @ Microsoft: Engineering the Future

by Matthew Johnson, Principal Lead, Microsoft Research

Abstract

Microsoft Research has been at the frontier of artificial intelligence research throughout its history, with a particular focus on natural language, images and speech. Our goal has always been to empower everyone to do more, and in this talk I will outline some of the more exciting technologies we have recently made available to developers, describe how they went from dream to delivery, and share some insights into the future role AI will play in every developer’s toolkit.

10:45 am – 11:00 am

REFRESHMENT BREAK

11:00 am – 12:00 am

TRACK KEYNOTES

BI Platform Architecture, Development & Administration

TRACK KEYNOTE
What is new and exciting with Microsoft BI
by Kasper de Jonge / 300
Community Zone: After session

Abstract

In this session we will take a look at the flight Power BI has taken in the last year and what is on the horizon for Power BI, Analysis Services and Reporting services. You won’t want to miss this!

BI Information Delivery

TRACK KEYNOTE
BI Information Delivery keynote
by Alberto Cairo / 300

Application & Database Development

TRACK KEYNOTE
Model thinking meets database tools
by Kennie Pontoppidan
Community Zone: After session

AI & Data Science

TRACK KEYNOTE
AI: past, present, but what is the future?
by Rafal Lukawiecki / 400

Abstract

AI: from academic past, through machine learning, towards autonomous intelligence.
Machine learning enables Artificial Intelligence, but what is beyond?

IoT, Hybrid and Open Source

TRACK KEYNOTE
From Data to Insight to Action – The value of pairing IoT and advanced analytics solutions
by Andrew Shannon

Abstract

In this session, we will take a look at the Microsoft’s POV on the internet of things, observe how many businesses miss out on opportunities to leverage their data, and explore how pairing  IoT and analytics together can add significant value to your organization.  Additionally, we’ll announce some new services and features that Azure IoT is launching.

Database Administration & Deployment

TRACK KEYNOTE
Deep dive on four vNext features
by Joe Sack

12:00 am – 01:00 pm

LUNCH & EXHIBIT

01:00 pm – 02:00 pm

BI Platform Architecture, Development & Administration

PowerShell ♥ SSIS
by Joost Van Rossum / 400
Community Zone: After session

Abstract

This sessions shows you all the benefits when using PowerShell with(in) SSIS. Use it for deploying environments and projects, for maintenance or for example as a source within an SSIS package. And what about analyzing your packages for best practices. Lot’s of demo’s and just a few slides. Contact me via my blog or twitter if you have an SSIS PowerShell challenge for me to show during this presentation.

BI Information Delivery

Tweet! Tweet! Let’s take a deep dive into the Power BI Twitter Brand Campaign Solution!
by Sam Lester / 300
Community Zone: After session

Abstract

With the introduction of Microsoft Solution Templates, you can create an amazing Power BI Brand and Campaign Management dashboard leveraging Twitter data IN JUST MINUTES! The solution includes several components, including a pre-built impressive Power BI Dashboard, backed by Azure Cognitive Services, Azure Logic Apps, App Service Plan, Azure Functions running C# code, and several other components.

In this talk, we’ll explore the Power BI reports, getting started with the setup, and a deep dive into the technical components that power this solution. We’ll also cover the pricing model and suggestions for right-sizing the components that I’ve used to help several customers with this amazing solution.

Additional solution details can be found here: https://powerbi.microsoft.com/en-us/solution-templates/brand-management-twitter/

Application & Database Development

Database DevOps Anti-patterns
by Alex Yates / 200
Community Zone: After session

Abstract

DevOps has revolutionised our ability to deliver customer value.

Updates aren’t held up in 6-month release cycles. We’ve automated tests and deployments collaboratively so we know updates work. A virtuous cycle of innovation and testing allows us to build better, more reliable products faster and cheaper.

However, while that’s great in theory, I’ve seen people screw up spectacularly when applying DevOps to relational databases.
In this light-hearted session I’ll present the 15 most popular ways to screw up, resulting in painful, fragile deployments and expensive legacy databases that no-one likes to maintain.

A session for developers *and* DBAs.

AI & Data Science

Advanced Analytics with Microsoft R Server
by Marcin Szeliga / 300
Community Zone: After session

Abstract

Advanced big data analytics using Microsoft tools on premises? With Microsoft R Server (available in all SQL Server 2016 SP1 editions plus on Hadoop/Spark/Teradata/Linux platforms) it’s definitely possible.

First, MRS (Microsoft R Server) is 100% compatible with existing Open R scripts, functions and packages. That means huge range of freely-available R algorithms and functions. Second, it’s just run faster due to high-performance math library to speed up linear algebra functions.

What’s more, you can easily change execution context from single-threaded local machine to multi-threaded or to remote server. Finally, MRS uses ready-to-use, high-performance big data big analytics ScaleR library. This library allows data chunking and efficient parallelization of “external memory” algorithms.

During this session you will see how efficiently use MRS to explore data, prepare data in chunks ad build predictive models.

IoT, Hybrid and Open Source

SQL Server on Linux–A Brave New World
by Joseph D’Antoni / 200

Abstract

If you are new to Linux and want to come up to speed in anticipation of SQL Server’s release, this session is perfect for you. You will learn about the Linux operating system, how to interact with it, and the nuances of implementing SQL Server on the platform. Additionally, you will learn about the complexities of configuring high availability and disaster recovery on the Linux platform.

Database Administration & Deployment

SQL Server 2016 and availability groups: what’s new?
by David Barbarin / 300
Community Zone: After session

Abstract

AlwaysOn availability groups feature is continuously improved by the SQL Server team since SQL Server 2012.

02:00 pm – 02:15 pm

BREAK

02:15 pm – 03:15 pm

BI Platform Architecture, Development & Administration

Automating your development process with Biml
by Martin Andersson / 300
Community Zone: After session

Abstract

It’s time to stop doing manual grunt work and speed up your day to day work. With Biml you can achieve automation of your BI development process by using predefined templates.

This session will cover examples on:
How you can create a staging data layer. What kind of metadata you should be collecting. Design principles for doing automated development.

BI Information Delivery

Tabular Next Top Model
by Edgar Walther / 200
Community Zone: After session

Abstract

Creating a proper Tabular Model is essential for the success of your modern BI solution. If you set up the foundations properly, you will benefit when building the relationships, formulas and visualizations. Also your Self-Service BI users will understand and use the data model better. This talk guides you through the process of creating a Tabular Model. The session will be packed with very practical tips and tricks and the steps you should do to create a proper model. The session is based on “real life” projects, and will be backed with some theory. After this hour you will understand how to create a proper model, how to optimize for memory usage and speed, enhance the user experience, use some DAX expressions and to use the right tools for the job. You will go home with a very useful step-by-step-guide.

Application & Database Development

SQL Storage Fundamentals for Azure IaaS
by Bob Duffy / 100
Community Zone: After session

Abstract

SQL disk configuration and planning can really hurt you if you get it wrong in azure. There is a lot more to getting SQL right on Azure VMs than next-next-next. Come along and dive deeper into azure storage for SQL.

Topics covered include:
– SQL storage Capacity Planning concepts
• Understanding Storage Accounts, VM limits, and disk types
• Understanding and planning around throttling.
• Benchmarking

Optimizing SQL configuration to match Azure disk layout:
• Optimal Drive configuration
• TempDB
• File and Filegroup layout concepts – Hitting “max” disk throughput

AI & Data Science

Using R in SQL Server, Power BI, and Azure ML
by Dejan Sarka / 200
Community Zone: After session

Abstract

In SQL Server, Azure ML, and Power BI suites, you can find nearly anything you need for analyzing your data. SQL Server 2016 closes one of the last gaps – support for statistics beyond basic aggregate functions and support for other mathematical calculations.

This is done with support for the R code inside SQL Server Database Engine. This session goes beyond showing the basics, i.e. how to use R in the Database Engine, Power BI and Reporting Services reports, and to enhance Azure ML; it shows and explains also some advanced statistical and matrix calculations.

Prerequisites: Familiarity with SQL Server tools

IoT, Hybrid and Open Source

SQL Server inside a Docker container
by Christophe Laporte / 200
Community Zone: After session

Abstract

Still unthinkable a few years ago, Microsoft’s strategy toward the Open Source world is shaking the computer sphere.

Bare metal or virtual machine, SQL Server can now be installed on a Windows OS or… on Linux. In parallel, DevOps culture and micro services seem to be the architecture model for the decade. Docker containers offers IT Pros or Developers interesting scenarios.

During this discovery session and with a few lines of code, let’s install Docker, create a SQL Server container and walk through some use cases.

Database Administration & Deployment

Benchmarking like a Pro
by Gianluca Sartori / 300
Community Zone: After session

Abstract

Exciting times ahead! You bought a license for SQL Server 2016 and you are going to upgrade to the new shiny version of SQL Server on a beefy new machine!

Fantastic! Except that you have no idea how your application will work on the new version. There’s a new cardinality estimator starting from SQL Server 2014: how will it affect performance? The new features in In-Memory OLTP and Columnstore Indexes look really promising, but how will your workload take advantage of these features?

The best way to know for sure is to run a benchmark and compare it to your current performance.

In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system. You will also learn which performance metrics to capture and compare, and which tools can help you in the task.

03:15 pm – 03:45 pm

REFRESHMENT BREAK

03:45 pm – 04:45 pm

BI Platform Architecture, Development & Administration

Pipeline for the new oil: Azure Data Factory, Hybrid Data Movement
by Jean-Pierre Riehl & Fabien Adato / 200
Community Zone: After session

Abstract

Data is the new oil ? So you need pipelines.

Azure Data Factory is the solution to move Data between your data assets, wherever they are, in the cloud or on-prem. In that session, you’ll see Azure Data Factory (ADF) in action and learn how to build your first pipeline. You will understand basic concepts of ADF and see how to implement advanced activities. Also, you’ll learn how to get data from on-prem data assets with hybrid pipelines.

BI Information Delivery

Power BI and SharePoint 2016 – Can they work together now?
by Aaron Bator / 200
Community Zone: After session

Abstract

When Power BI and SharePoint 2016 launched in 2016, there was a lot of interest in using SharePoint to display Power BI reports. Unfortunately, the options for doing so were very limited. But after a year of Power BI releases, this story has changed. In this session, we’ll discuss whether SharePoint 2016 and Power BI are ready to work together.

This session will highlight some of the current options for integrating Power BI data with SharePoint 2016, including the current limitations. We’ll also look at other technologies like SSRS and the built-in Business Intelligence capabilities in SharePoint 2016 — either of which might be a better fit for your data display needs, depending on your requirements.

Application & Database Development

Diving into your Azure Data Lake with U-SQL
by Helge Gårdsvoll / 200
Community Zone: After session

Abstract

Microsoft introduced a new SQL dialect with Azure Data Lake Analytics and U-SQL. This session will introduce the core concepts of U-SQL and how it fits in a ELT pattern. With the familiarity of SQL and extensibility of C#, and a scalability to hundreds or thousands of Analytics Units U-SQL has great abilties. But using a script based transformation language has several pitfalls, and this session will cover some of the dos and don’ts based on practical experience with using the language.

AI & Data Science

Playground of cognitive services – Even big kids play here
by Alexander Klein / 100
Community Zone: After session

Abstract

Microsoft offers a large playground for young and old with the cognitive services. Here can be tested according to your heart’s content which will be maybe tomorrow all in use. With the various building kits such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to put together in a short time Impressive applications. Come on a little trip with on this playground.

IoT, Hybrid and Open Source

Cortana Analytics : Transform Data into Intelligence using Raspberry PI and Weather Sensor
by Leila Etaati / 200
Community Zone: After session

Abstract

Cortana Analytics delivers an end-to-end platform with an integrated and comprehensive set of tools and services to help users to build intelligent applications. This session will show how Cortana can be used for monitoring live data collected from devices like weather sensors and how we can use Cortana intelligence suit to monitor the live data and apply some machine learning process on them. In this Demo I will show how to set up an IoT device like Raspberry PI, how to use different components of Cortana Intelligence suite for transferring data (Azure service bus and azure stream analytics), storing data in a azure SQL database, getting insights from collected data using azure ML, and finally showing the results through automatically in Power BI.

Database Administration & Deployment

SQL Server Myths and Misconceptions
by Miroslav Dimitrov / 200
Community Zone: After session

Abstract

SQL Server is full of misunderstood features and misnomers that could affect how it is operating and respectively our applications. If you do not want to be surprised in a bad way by some intended, but not widely known SQL functionalities, join me in this session where we will, in an entertaining way, examine some of the most common behaviors that you probably have not expected.

04:45 pm – 05:00 pm

BREAK

05:00 pm – 06:00 pm

BI Platform Architecture, Development & Administration

Agile BI from the cloud with Team Foundation Services
by Sander Hoeff / 100
Community Zone: After session

Abstract

gile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have?

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.

BI Information Delivery

12 Rough Days in December – The good, the bad, and the cheery of creating a 12-part Power BI Blog Series that goes viral
by Sam Lester / 200
Community Zone: After session

Abstract

Over the holiday season, I created a 12-day MSDN blog series titled “Power BI – 12 Days of Dashboards” where I created a new Power BI Dashboard each day for 12 days. The blogs are based on fun data sources, such as Amazon.com order history, Pinterest, Twitter, Goodreads, LinkedIn, Meetup, Fitbit, & more. The goal was to highlight the magic of Power BI & get people to think about new ways to leverage data… and it worked!

It was a LOT of effort, but the results were definitely worth it. The Microsoft Power BI product team advertised the series broadly. I discovered product bugs in Power BI custom visuals that have since been fixed. Page views & downloads were in the thousands, my blog subscribers & Twitter followers soared, and I’ve shared my experiences in presentations to several audiences since then.

In this talk, I’ll give an overview of the 12 topics, how I selected & created the content, my strategy for evangelizing in social media, & if I’m crazy enough to try this again (OF COURSE!).

Application & Database Development

Designing for High Availability and Performance in Azure IaaS
by Jesper Jensen / 300
Community Zone: After session

Abstract

Building a simple Azure infrastructure is easy and quick. Building a complex infrastructure with High Availability, and need for good performance is not. Join this session to learn what not to do – and what to do instead. We will cover the different ways to build a fully redundant, and supported, SQL Server environment in Azure. While doing this we will ensure great storage performance, all while take costs into consideration.

AI & Data Science

Machine Learning Meets Image Analysis: From looking inside ourselves to gazing at the stars
by Christian Igel

Abstract

Machine learning (ML) plays an increasing role in image analysis. This talk presents recent examples from medical imaging and astronomy, ranging from applying standard ML algorithms to hand-crafted image features, over supervised feature learning using deep neural networks, to unsupervised image categorization.

IoT, Hybrid and Open Source

SQL Server on Linux – It’s time to dive into the black screen
by Murilo Miranda / 200
Community Zone: After session

Abstract

First announced in March 2016, SQL Server on Linux is a milestone of Microsoft’s history. Are you ready for SQL Server’s future?

During this session we are going to understand how SQL Server works on Linux, exploring some implementation details, as well as how to perform basic management tasks to keep SQL Server running in a different operating system than Windows.

Let’s dive into the “”black screen”” and play with Penguin together 🙂

Database Administration & Deployment

Flash Storage For The SQL Server Professional
by Christopher Adkin / 300

Abstract

We are at a major inflection point in terms of storage as the industry makes the transition from spinning disk to flash. This vendor neutral session will cover how the SQL professional will have to look at storage in this brave new world, specifically around things such as:

  • Testing for performance and how sqlio and diskspd do not cut it in the new world
  • What encryption and page/row compression do to a flash storage devices ability to carry out its own compression and de-duplication
  • Whether compression is still worth while from a performance perspective – How copy on redirect can be used to accelerate everyday DBA tasks
  • Whether the practise of putting different components, tempdb, the transaction log etc is still relevant

06:00 pm – 22:00 pm

FOOD & FUN

08:00 am – 09:00 am

BREAKFAST

09:00 pm – 10:00 pm

BI Platform Architecture, Development & Administration

DAX unraveled
by Peter ter Braake / 200
Community Zone: After session

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.

BI Information Delivery

Big Data – Big Quality?  A governance round-trip through the possibilities of the MS data platform
by Oliver Engels / 200
Community Zone: After session

Abstract

In the times of data explosion, a dazzling array of information streams and unbelievable possibilities of different techniques to manage data via the Microsoft Data Platform, this session asks the question: what about data curation?

We dive into the requirements of modern data governance and curation and show in examples, what the Microsoft Data Platform has to offer: Can SQL Server Master Data Service (MDS), Data Quality Services (DQS) and Integration Service (SSIS) help? Which options offers the Azure Data Catalog and how does the Microsoft Common Data Service come into play? We also look at the potential of the new integrated languages in the Data Platform like R or U-SQL. At the end of this session you will have an overview and understanding of the possibilities, that Microsoft Data Platform offers you to address your data curation requirements.

Application & Database Development

Latches, Spinlocks, and Lock Free Data Structures
by Klaus Aschenbrenner  / 400

Abstract

You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect! Join me in this session to make a further deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks. We will cover the differences between both, and their use-cases in SQL Server. You will learn about best practices how to analyze and resolve Latch- and Spinlock contentation for your performance critical workload. At the end we will talk about lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server 2014.

AI & Data Science

Populating the Galaxy Zoo: Real-time Image Classification with SQL Server R Services
by David Smith
Community Zone: After session

Abstract

The World Wide Telescope is a collaborative science project, hosted by Sloan University, with 12Tb images and data about the universe. This is the database behind the “Galaxy Zoo” project, which encourages volunteers to classify images of galaxies into categories like “globular” and “spiral”. In this talk, I’ll demonstrate how we built a predictive model using SQL Server R Services to use the volunteer-based classifications to automatically classify millions of other galaxies in the database, and demonstrate an app to classify newly-captured images in real time.

IoT, Hybrid and Open Source

TBA
TBA

Database Administration & Deployment

Introducing Adaptive Query Processing in SQL Server vNext
by Margarita Naumova / 400
Community Zone: After session

Abstract

An improvement of cardinality estimation is something we try to achieve in every next version of SQL Server QP either by relying on the QP to do the work or by using different techniques in our queries. There is a huge amount of work that has been done in SQL Server 2014 but even with all the improvements, there is no single approach that works for all queries. That is why we are so existed to find the new wave of adaptive query processing improvements to handle the more intractable cardinality estimation issues that often result in poor query performance. The session will explore the Batch mode adaptive memory grant feedback as the first improvement under the adaptive query processing family of features in SQL Server vNext.

10:00 am – 10:15 am

REFRESHMENT BREAK

10:15 am – 11:15 am

BI Platform Architecture, Development & Administration

What is Microsoft planning for SSIS vNext?
by Wolfgang Strasser / 100
Community Zone: After session

Abstract

SQL Server Integration Services (SSIS) serve as a base foundation for data integration since SQL Server 2005. In some versions no new features had been added but beginning with SQL Server 2016, SSIS got love again.

SQL Server codename vNext – which will be released in mid-2017 – again adds some new features in SSIS. If you need to scale out your package executions, SSIS vNext is the right thing for you.. but that’s now all.. let’s see what Microsoft is adding to the tool in the next version.

If you are an SSIS developer, this is the right session for you to get an overview about the new features coming to SSIS town in SQL vNext!

BI Information Delivery

Deep dive on modelling in Power BI and SSAS 2016
by Kasper de Jonge / 300
Community Zone: After session

Abstract

The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many and RLS using the latest version of Power BI desktop and Analysis Services

Application & Database Development

When things go wrong – error handling in SQL Server
by Erland Sommarskog / 200
Community Zone: After session

Abstract

In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand.

This presentation will start with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this – what we should do and what we should not. We will learn how we should use TRY-CATCH and why we should use SET XACT_ABORT ON, and why it pays off to be simple-minded to survive in this maze.

AI & Data Science

Don’t cross the streams! (A closer look at Stream Analytics.)
by Johan Brattås / 200
Community Zone: After session

Abstract

So you’ve decided to get into the Internet of Things and stream data from your devices into Azure. And now you want to use Azure Stream Analytics (ASA) to analyze and aggregate your data. Join me in this session to learn how to develop and debug your ASA queries and the possibilities and limitations of the language.

We will look at the different input and output choices and when to use which one.

IoT, Hybrid and Open Source

Linux for the SQL Server Administrator
by David Klee / 200
Community Zone: After session

Abstract

I bet never in your career you thought SQL Server would run on anything other than Windows. Times are changing, and are you ready? SQL Server on Linux is right around the corner! What is Linux – really? Why run your mission-critical databases on an unfamiliar operating system? This introductory session will help seasoned SQL Server DBA understand the basics of Linux and how it is different from Windows, all the way from basic management to performance monitoring. By the end of this session, you will be able to launch your own Linux-based SQL Server instance and get hands-on with this paradigm shift to see if this new platform is right for your organization.

Database Administration & Deployment

Investigate, analyze and solve Wait Stat scenarios
by Uwe Ricken / 300
Community Zone: After session

Abstract

SQL Server is a high frequently used piece of software which need to serve single requests and/or hundreds of thousands of requests in a minute. Within these different kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks in a fashion manner. This demo driven session shows different scenarios where Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and solve different wait stats due to their performance impact:

  • CXPACKET: when a query goes parallel
  • ASYNC_IO_COMPLETION: speed up IO operations (Growth / Backup / Restore)
  • ASYNC_NETWORK_IO: What happens if your application refuses data?
  • THREADPOOL starvation: crush of requests for Microsoft SQL Server
  • PAGELATCH_xx: How does Microsoft SQL Server protects data?

11:15 am – 11:30 pm

BREAK

11:30 pm – 12:30 pm

BI Platform Architecture, Development & Administration

BI DevOps
by Jens Vestergaard / 200
Community Zone: After session

Abstract

How can you adopt DevOps into your BI project?

In this session we will goo through the different tools, tricks and processes needed, in order to jump DevOps-train in your organization.

Focus will mainly be delivered on processes around SSAS, SSIS and SSRS but we will also briefly touch on Continuous Delivery for the underlying Data Warehouse.

Come join this session, if you are ready to take the first few steps towards automation of your deployment processes.

BI Information Delivery

Making maps in Power BI
by Andrea Martorana Tusa / 200
Community Zone: After session

Abstract

How many ways do you know for making maps in Power BI? Maybe two? Anything else but bubble maps and choropleth?

Are you aware of the new Shape maps visual embedded in Power BI?
And what about the wonderful custom visuals available for every user? 3D GlobeMap and Synoptic Panel an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map.

How not to mention the new ArcGIS Maps for Power BI feature announced recently? It offers enhanced mapping capability, demographic data, and even more compelling map visualizations. And that’s not all.

Support for R open doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment.

Do you want to draw multi-layered interactive maps? Want to geocode your data with direct calls? With R in Power BI, now you can.

Amazing visualizations, interactive charts and deep data analysis: with Power BI custom tools everything is possible!

Application & Database Development

Multi-tenant architectures – from small scale to hyper-scale
by Kennie Pontoppidan / 200
Community Zone: After session

Abstract

Need to design the database backend for a cloud application? Come and hear about different choices of multi-tenant architectures,  from small scale covering tenants in the hundreds all the way up to hyper-scale supporting hundreds of thousands of tenants.  We will cover the three main architectures “Separate Databases” , “Shared Database, Separate Schemas” and “Shared Database, Shared Schemas”  and how they can be implemented on Azure SQL database and elastic pools.  Pros and cons for security, performance and administration will be discussed in each of these architectures.

AI & Data Science

Create Stunning Visualizations with The Help of R
by Markus Ehrenmüller-Jensen / 200
Community Zone: After session

Abstract

R is the first choice for data scientists for a good reason: besides accessing and transforming data and applying statistical methods and models to it, it has a wide variety of possibilities to visualize data. As visual perception of data is the key to understanding data, this capability is crucial. This session will give you a broad overview over available packages and diagram types you can build with them on the one hand and a deep dive into common visualizations and their possibilities on the other hand. Impress yourself and your peers with stunning visualizations which will give you insights into data you could not achieve with other tools of Microsoft’s BI stack.

BI Information Delivery

Introduction to NoSQL
by Nabeel Derhem / 200

Abstract

Understanding when and how to use NoSQL is already becoming essential, even for database professionals currently focusing only on the RDBMS world. This session will explain NoSQL for the SQL Server professional, discussing the history and needs that led to NoSQL solutions and the strengths and weaknesses in comparison with RDBMSs. We’ll also explore the several NoSQL data models available in the market today (Key-Value, Column-Family, Document, and Graph) and cover the current solutions that implement them (Cassandra, HBase, MongoDB, Redis, Neo4j, etc.).

Database Administration & Deployment

5 things to consider:
Stretching SQL Server
Failover Clustered
Instances and Availability
by Edwin Sarmiento

12:30 Pm – 13:30 pm

LUNCH & EXHIBIT

01:30 pm – 02:30 pm

BI Platform Architecture, Development & Administration

Azure SQL DWH: Tips and Tricks for developers
by Sergiy Lunyakin / 300
Community Zone: After session

Abstract

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can’t use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching and so on. In this session, I’m going to cover several tips and tricks how we can handle with this limitations using available possibilities.

BI Information Delivery

Analysing your corporate online presence using Power BI
by Ásgeir Gunnarsson / 200
Community Zone: After session

Abstract

In this session we will look at how you can use Power BI to analyse you company’s online presence.

We will look at how you can source data from Google Analytics, Facebook, Twitter, LinkedIn and finally from web pages. We will discuss different ways to get the data and what the difficulties/hindrances are when working with API’s in Power BI.

We will then show how you can work with the data to get some meaningful analysis from it and ask the question: Can you get a holistic view of your online presence?

This is a demo rich session where we will go through getting the data in and looking through how we can extend the model before visualizing the results.

The participants will leave the session with ideas on how they can use Power BI (or indeed some other BI tool) to start analysing their company’s online presence.

Application & Database Development

SQL Server Memory-optimized Data Exchange / SQL Server Extreme Transaction Processing
by Matija Lah / 300
Community Zone: After session

Abstract

SQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules – either within the database, or between client applications and databases:
– Memory-optimized Table Variables; and
– Memory-optimized Table-valued Parameters.

AI & Data Science

What can database administrators gain from SQL Server 2016 R Integration?
by Tomaž Kaštrun / 400
Community Zone: After session

Abstract

SQL Server 2016 came equipped with R Microsoft Server and native integration of R Language. R is a powerful language and environment for statistical computing, data mining, predictive analytics and visualizations.

This session will explore possibilities how daily, weekly or monthly tasks and R integration into SQL Server 2016 can work in advantage for DBA. Extending the possibilities of statistical analysis and predictions beyond customer related world into administrative SQL Server world.

Demos will be shown based for monitoring SQL Server system, database, RAM consumption, Disk growth, monitoring extended events and using the statistics from query store as well as information available in DMV. Data will be analyzed using R with the possibilities of additional data visualizations (in SSRS, Power BI, Shiny).

IoT, Hybrid and Open Source

Cognitive Internet of Things for new business scenarios
by Anders Lybecker / 300

Abstract

IoT is an overloaded buzzword fueled by the new capabilities of cloud, connectivity and abundance of cheap microcontrollers. But bringing all these components together will make a big impact on every industry. Artificial Intelligence, in particular the use of Cognitive Services together with IoT, are generating new scenarios that generate exciting business opportunities.

Database Administration & Deployment

Troubleshoot performance problems like a Microsoft Engineer with SQLDiag, SQLNexus, PAL, and BPCheck
by David Peter Hansen / 300

Abstract

You are a DBA and have a few years’ experience, but you are having performance problems in your SQL Server environment.

In this demo-heavy session, you will learn how Premier Field Engineers at Microsoft troubleshoot performance problems and what tool and scripts they use. We will take a look at tools and scripts like SQLDiag, SQLNexus, PAL, and BPCheck.

02:30 pm – 02:45 pm

BREAK

02:45 pm – 03:45 pm

BI Platform Architecture, Development & Administration

Analysis Services in times of Continuous Integration – How to keep up with modern standards
by Gabi Münster / 200
Community Zone: After session

Abstract

Continuous Integration attracts more and more attention throughout all areas of development. But not every area is provided with a satisfactory amount of tools and support for this topic. Especially in BI there is still a gap to close.

During this session we will look into ways to start on your own Continuous Integration approach for your SSAS tabular solution. After a short review of what aspects Continuous Integration actually consists of we’ll focus on automated deployment. Let’s have a look at the Tabular Object Model (TOM) in C# as well as the JSON based Tabular Model Scripting Language (TMSL) available since SQL Server 2016 as possible approaches to build your own automated deployment process. And what about BIML?

BI Information Delivery

Power BI on Azure Analysis Services
by Reeves Smith / 100
Community Zone: After session

Abstract

The level of effort to integrate a tabular SQL Server Analysis Services (SSAS) cube with Power BI became significantly easier with the release of Azure Analysis Services. Setup, configuration and maintenance of an On-Premise gateway for direct query and scheduled data refreshes is no longer required. Leveraging the default Azure Analysis Services integration with Power BI, developers can focus on modeling cubes and creating beautiful dashboards and reports. In this session, we will explore the setup of an Azure Analysis Services as compared to the use of as an On-Premise Analysis Services data source for Power BI.

This session will discuss modeling & security patterns in Analysis Services in conjunction with Power BI. There will also be a demo of the direct query connection of On-Premise and Azure Analysis Services cubes to Power BI. The level of effort to integrate a tabular SQL Server Analysis Services (SSAS) cube with Power BI became significantly easier with the release of Azure Analysis Services. Setup, configuration and maintenance of an On-Premise gateway for direct query and scheduled data refreshes is no longer required. Leveraging the default Azure Analysis Services integration with Power BI, developers can focus on modeling cubes and creating beautiful dashboards and reports. In this session, we will explore the setup of an Azure Analysis Services as compared to the use of as an On-Premise Analysis Services data source for Power BI.

This session will discuss modeling & security patterns in Analysis Services in conjunction with Power BI. There will also be a demo of the direct query connection of On-Premise and Azure Analysis Services cubes to Power BI.

Application & Database Development

Time Travelling with Temporal Tables
by Johan Åhlén

Community Zone: After session

Abstract

Have you ever wanted to be able to travel back in time in your databases? One of the new features in Azure SQL databases and SQL Server 2016  is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.

This demo-intensive session explains how to get started with Temporal Tables in Azure SQL databases and SQL Server 2016. You will learn about:

  • Change Data Capture with temporal tables
  • Undoing changes to a table
  • Can it be combined with other features such as stretch-databases and In-Memory OLTP tables?

Don’t miss this exciting new feature if you are working with Business Intelligence development, or database development in general, on Azure or SQL Server 2016.

AI & Data Science

R shines! The 4th force is coming to visualize your data
by Oliver Engels

Abstract

If you like to visualize data in the Microsoft Data Platform you use the visualization power of Excel, Power BI or Reporting Services. With the integration of R a 4th force is approaching to help you achieving great visualization results in new ways. This session will help you with the basics of the R language, the integration and of course, applying visualization best practices to it. Base on live demos, we show how to start, what R libraries are useful, how to integrate R in your favorite reporting tools like SSRS or Power BI and what you need to apply corporate identity, manage code and a proper development life cycle. When you walk out of the session, you will think the 4th force is with you and gives you additional visualization super power for your job.

IoT, Hybrid and Open Source

Hello Bot! Programming intelligent bots
by Mads Damgård / 300
Community Zone: After session

Abstract

Join this session to learn about the platform for building bot applications and for interacting with cognitive services to add contextual understanding. The session will be demo heavy.

Database Administration & Deployment

High Availability in SQL vNext on Linux
by Robert Hartskeerl / 300

Abstract

Most database administrators know how to manage and deploy high availability solutions using SQL Server. Most also know parts of Windows clustering. But with SQL Server vNext there is a old new kid on the block and it is called Linux. The SQL part might be the same, the operating system is certainly not. In this session we will take a look at high availability solutions on Linux and how the fit into SQL Server. How do you manage and deploy availability groups across your organization leveraging Linux.

03:45 pm – 04:00 pm

REFRESHMENT BREAK

04:00 pm – 05:00 pm

BI Platform Architecture, Development & Administration

Performance Tuning for the BI Professional
by Jonathan Stewart / 200
Community Zone: After session

Abstract

Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI as well as some core engine stuff.

BI Information Delivery

DAX Patterns to Rise; Power BI Beyond Limits
by Reza Rad / 300
Community Zone: After session

Abstract

Power BI can be used to implement many complex scenarios with help of DAX. In this session, you will learn some of the most useful DAX patterns that helps in many real-world challenges and turn complex problems to easy solutions. You will learn DAX patterns such as Time Intelligence, Parameter Table, and Customer Retention. All patterns will be demonstrated with real-world live demos.

Application & Database Development

Deploying and Configuring Database Servers to Azure using Templates and DSC
by Scott McCormick / 200

Abstract

In this session, we will cover how to deploy and configure a new server, instance, and databases to Azure using JSON Templates, Desired State Configuration, Azure Resource Manager, and Visual Studio.

With these tools, attendees will learn how to:

  • Build your own server templates.
  • Add the DSC extension for automatic configuration of the server.
  • Automatically configure newly deployed servers with extra drives, Windows permissions, registry edits, etc…
  • Scale and specialize the deployments for Dev, Test, Staging, and Production environments.

AI & Data Science

Weighing the data for high performance
by Fritz Henglein

IoT, Hybrid and Open Source

IoT Circus – Trapeze (In Cloud acrobatics)
by Catalin Gheorghiu
Community Zone: After session

Abstract

If you ask now Microsoft the “Answer to the Ultimate Question of Life, the Universe, and Everything” they will answer Azure not 42. Yet for the IoT (and IIoT) space is pretty much the right answer.

This presentation will try to give you the “Answer to the Ultimate Question of Life, the Universe, and Everything”, if you are in the IoT field. You will see at work, understand what they do and how to use it to maximum effect the Azure cloud part of a IoT solution. Now you will be puzzled when you hear terms like stream analytics, IoT Hub, gateway and so.

Database Administration & Deployment

Analyze SQL Server performance through the Query Store
by Enrico van de Laar  / 300
Community Zone: After session

Abstract

With the introduction of the Query Store feature in SQL Server 2016 analyzing query performance became a whole lot easier for everyone. But where does the Query Store record it’s wealth of query performance metrics, and how can we access it? In this session we will focus on retrieving, interpreting and visualizing the data inside the Query Store.

Not only will we look at the built-in reports the Query Store provides by default for analyzing query performance, we will also explore alternative methods, like custom performance dashboards, the sp_WhatsupQueryStore stored procedure or replaying a query workload through the Query Store Replay script. We will use all these different tools and methods in real-world use cases, for example, to minimize the performance impact of changing database compatibility levels.

After this session you will have all the information you need to leverage the power of the Query Store for analyzing query performance, minimizing the impact of database migrations and develop your own, custom, Query Store solutions.