| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Christopher Adkin | Application Database Development | Problem Solving With The In-Memory Engine |
| 08:30:00 | Kevin Chant | Enterprise Database Administration Deployment | Choose your own Database Adventure |
| 08:30:00 | Satya Jayanty | Cloud Application Development Deployment | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 08:30:00 | Andrew Pruski | Cloud Application Development Deployment | SQL Server Containers in Azure |
| 08:30:00 | Kenneth Nielsen | Dynamics 365 | Who will be Denmark's next Primeminister? |
| 10:00:00 | Satya Jayanty | Analytics and Visualization | Big Data with Azure: where to begin? Concepts and best practices |
| 10:00:00 | Hugo Kornelis | Application Database Development | Now Where Did THAT Estimate Come From? |
| 10:00:00 | Mihail Mateev | Cloud Application Development Deployment | Dealing with CosmosDB |
| 10:00:00 | Daniel Otykier | BI Platform Architecture, Development Administration | Boosting SSAS productivity with Tabular Editor |
| 10:00:00 | Bent Pedersen | Analytics and Visualization | Dataflows for Power BI |
| 12:30:00 | Christopher Adkin | Application Database Development | Continuous Integration Pipelines With Jenkins, Docker and SQL Server |
| 12:30:00 | Andrea Martorana Tusa | Application Database Development | The language of graph databases and SQL Server |
| 12:30:00 | Bartosz Ratajczyk | Application Database Development | Start testing your SSIS packages with ssisUnit |
| 12:30:00 | David Postlethwaite | Application Database Development | Shard Attack - Horizontal Scaling in Azure SQL Database |
| 12:30:00 | Jens Vestergaard | BI Platform Architecture, Development Administration | Continuous Delivery for BI projects |
| 13:45:00 | Mihail Mateev | Cloud Application Development Deployment | Device provisioning with Azure IoT in a Nutshell |
| 13:45:00 | James McGillivray | BI Information Delivery | Working with complicated data models in DAX |
| 13:45:00 | Erland Sommarskog | Application Database Development | Don't Use Cursors or Why You Maybe Should Use a Cursor After All |
| 13:45:00 | Jens Vestergaard | Analytics and Visualization | Data Ingestion Tricks w/ M |
| 13:45:00 | Martin Hansen | Application Database Development | SQL server window functions |
| 15:15:00 | Alexander Klein | BI Platform Architecture, Development Administration | Build your next BI solution in azure |
| 15:15:00 | Nico Jacobs | Cloud Application Development Deployment | Azure stream analytics |
| 15:15:00 | Bob Duffy | Cloud Application Development Deployment | Automate your SSIS Deployments with VSTS |
| 15:15:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Collecting Performance Metrics |
| 15:15:00 | Bent Pedersen | BI Platform Architecture, Development Administration | Automation and best practices for ADFv2 |
| 16:30:00 | Alexander Klein | Cloud Application Development Deployment | Azure Cognitive Services - AI for everyone |
| 16:30:00 | Michal Sadowski | Enterprise Database Administration Deployment | Database corruption |
| 16:30:00 | David Postlethwaite | Application Database Development | Graph Data in SQL 2017 |
| 16:30:00 | Just Blindbaek | BI Platform Architecture, Development Administration | End-to-end Business Intelligence solution in Azure |
| 16:30:00 | Amit R S Bansal | Application Database Development | SQL Server Memory Internals Troubleshooting |
Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Each selection will have a different outcome, and along the way you will probably learn some new things.
Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
However, running standalone Docker containers presents challenges so other technologies are need to support them. This session will provide an introduction to the various options for running SQL Server containers in Azure.
I'll cover the following different topics:- The Azure Container Registry Azure Container Instances Azure Container Services
This session is aimed at SQL Server DBAs and Developers who have some experience with Docker and want to know the different options that are available in Azure.
Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies
Event Date: 06-10-2018 - Session time: 08:30:00 - Track: Dynamics 365
Heavy usage of R in this session
Speaker is NOT Kenneth, but will be MIkkel Freltoft Krogsholm
Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Analytics and Visualization
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Application Database Development
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.
Event Date: 06-10-2018 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 10:00:00 - Track: Analytics and Visualization
Before diving into details we will go through the architecture and demonstrate the bigger picture for Dataflows in Power BI.
We will go through how you can create, customize and manage data within the Power BI experience in a simpler way. Part of this will also be to go through Common Data Models which contains the business entities across your organisation.
This will help your organisation simplifying modeling and is intended to prevent multiple definition for the same data.
Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development
But, what to expect exactly from a graph database? How to query it? Is SQL Server fully featured compared to other products? In this session we answer these questions. We start illustrating the concepts behind the model; how relationships are handled and what are the common patterns and issues for a graph. What are the data connections a graph can easily represent. Then we compare the semantic model with SQL Server to discover how to apply it to real world. We analyze some case study: pattern matching, path finding, aggregation, ranking … For each of them we show how to use standard T-SQL and how to rewrite the query using graph objects. What is the benefit of reformulate our queries in terms of clearness and performances, what is already available in order to consider SQL Server a valuable player.
Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development
On this session, I will show you why you should and how to start with automated testing of the packages and the whole projects using ssisUnit – the free SSIS testing library. I will start with some basics and move forward to the real-life examples of the unit and integration testing of the SSIS packages/ projects/solutions. You will see the benefits of automated testing and that testing is hard only at the beginning.
Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Application Database Development
However there comes a point, especially in the cloud, where it is no longer possible to add more resources to a single database. Here we need a different solution. Instead of scaling up we must scale out, sometimes called horizontal scaling or sharding.
In this talk we will look at how to scale out in Microsoft Azure SQL database using the Azure Elastic Database tools We will look at the requirements and options for horizontal scaling in Azure and then we will have a go at sharding an Azure SQL database and then querying and updating the different shards We will be using t-sql, PowerShell and c# so come prepared for some serious coding
Event Date: 06-10-2018 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that'll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.
We will in detail be looking at:
Agile Development Frame of Mind The Path Ahead (direction) Visual Studio Online (tool) Feature/User Story/Work Item (concept) Team Services Code Branching (concept) Build Agents (tool) Releases (tool)
Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
of devices deployed in the field is not trivial. In the IoT device life cycle, provisioning is key for scaling securely. This talk is about main concepts and implementation when we need to provision IoT devices for modern Azure IoT Solutions. During this session, you'll get a sneak peek into how Azure IoT enables seamless, zero-touch registration of devices to IoT Hub with security that begins at the device and ends with our cloud.
Event Date: 06-10-2018 - Session time: 13:45:00 - Track: BI Information Delivery
In this session, we'll look at 4 common problems which occur when you're using more complicated data modelling techniques, and design and implement a simple solution to overcome these complications.
From role-playing dimensions and bi-directional filters to advanced filter context and overriding the default blank behaviour, we'll learn to solve a variety of problems and add value to our data models.
Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Application Database Development
Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Analytics and Visualization
complex multi-file scenarios and tricks to get your data mashed up. While at entry level we would be spending most time in the GUI we will be spending most of the time in this session in the Advanced Editor. In detail we will be looking at these topics: Variable number of columns in multiple files for same source Multiple File Formats (think historical changes in format) Binding Multiple Imports into a single table Error handling Dynamic File Format Handling General Tips ’n Tricks for M
Attending this session, you'll learn the basics of Power BI Desktop, get to see M code in action, as well as learn some neat tricks to get your daily chores done more efficiently. Additionally, I will demonstrate how to deploy your home-grown model into Azure Analysis Services
Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Application Database Development
The main advantage of using Window functions over regular aggregate functions is: Window functions do not cause rows to become grouped into a single output row, the rows retain their separate identities and an aggregated value will be added to each row.
In this session I will walk through the syntax of window functions as well as demonstrate common use cases for where window functions.
Event Date: 06-10-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Azure Stream Analytics allows you to analyze streams of data while they arrive. In this session you will see how to get started with Stream Analytics. We build and use a real-time application in this session. First we get started with Azure event hubs to collect data, then dive deeper into the temporal queries for analyzing the data.
Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
While SSIS is not officially supported we will walk you through the process of setting up VSTS for automated build of your BI projects, leading onto automated release and deployment.
Topics include:
Event Date: 06-10-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
In this session, we will be combining three open source tools - Telegraf, InfluxDB, and Grafana - into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we'll put it all together in an interactive dashboard for easy visualization.
Event Date: 06-10-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
As part of this session we will be looking into the automation functionality for ADFv2 and how you get started with data extraction and best practices using PowerShell for automation.
Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Cloud Application Development Deployment
This is a large playground for young and old. Here you can try out to your heart's content what will be in use tomorrow. With the various building blocks such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to name but a few, impressive applications can be assembled in a short time.
Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Application Database Development
This presentation is the culmination of my investigations. If you design complex OLTP relational databases or have data that doesn't fit the rigid hierarchy of a relational database then this talk is for you. You may be in for a surprise!
Some of the questions we will look at: What is Graph Data? Who uses it? What is it used for? How does it compare to traditional relational database design? What other companies support graph databases? How does it work in SQL 2017? Is there a new language to learn? What is the so-called Kevin Bacon problem?
And finally. Will it replace traditional relational database design within the next 10 years?
Event Date: 06-10-2018 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
Extracting, transforming and loading with the help from Functions, Data Factory, Data Lake Store, Polybase, SQL Data Warehouse, SQL Database, Automation Runbooks, Analysis Services and Power BI Embedded.
A look into the overall architecture and the different components and how they work together.
Event Date: 06-10-2018 - Session time: 16:30:00 - Track: Application Database Development