|Start Time (24h)||Speaker||Track||Title|
|09:00:00||John Tunnicliffe||BI/DEV||DevOps, CI and the Data Warehouse [EN]|
|09:00:00||Sander Stad||DBA||dbatools - PowerShell and SQL Server Working Together|
|09:00:00||Prathy Kamasani||BI||Compelling data stories using Power BI|
|09:00:00||Chris Taylor||DEV/DBA||Introduction to Containers|
|09:00:00||Denis Reznik||DEV||Why Should I Care About SQL if I Have ORM?|
|10:15:00||Rob Sewell||DBA||dbachecks - The PowerShell Module to validate your SQL Estate|
|10:15:00||Uwe Ricken||DEV||Daily indexing problems and its - possible - solution|
|10:15:00||John Martin||DEV/DBA||Introduction to Managed Instances|
|10:15:00||Marcin Szeliga||BI||Beyond image classification - object detection with multi-task deep models|
|10:15:00||Stephanie Locke||BI/DEV||Shipping Data Science products with R and Docker|
|11:30:00||Marcelo Fernandes||DBA||How to build solution for High Availability/Disaster Recovery|
|11:30:00||David Postlethwaite||DEV||Graph Data in SQL 2017|
|11:30:00||Gabi Münster||BI||Azure Analysis Services - An important step for BI in the cloud?|
|11:30:00||Wolfgang Strasser||BI/DEV||The Microsoft Power Platform - What is it?|
|11:30:00||Janusz Rokicki||DEV/DBA||AI Index for Sql Server|
|13:30:00||Thomas Hütter||BI/DEV||50 ways to show your data|
|13:30:00||Alex Whittles||BI||Cubes in the Cloud - Analysis Services in Azure|
|13:30:00||Michal Sadowski||DEV/DBA||Encryption in SQL Server|
|13:30:00||Gianluca Sartori||DBA||Benchmarking in the Cloud|
|13:30:00||Frank Geisler||DEV||Azure Data Studio - The new kid in town|
|14:45:00||Rob Volk||DEV||Revenge: The SQL!|
|14:45:00||Kamil Nowinski||BI||Azure Data Factory v2 with Data Flows capabilities|
|14:45:00||Milan Gabor||DBA||SQL server security out of the box!|
|16:00:00||William Durkin||DEV/DBA||Query Store without SQL 2016 = Open Query Store|
|16:00:00||Gašper Kamenšek||BI||One Click Solution in Excel (the refresh idea)|
|16:00:00||Miloš Radivojević||DEV||Intelligent Query Processing in SQL Server 2019 CTP2|
|16:00:00||André Kamman||BI/DEV||ETL with Azure Databricks, The Complete Introduction|
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: BI/DEV
This is a demo heavy session which will introduce you to exactly how powerful DevOps can be in practice and will cover:
Please visit John's blog for practical tips on how to apply DevOps techniques to your Data Warehouse: https://devop
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: DBA
Besides the amount of command there are not enough hours in the day to get everything done as a DBA. We need to automate our repetitive tasks to free up time for the important and more fun tasks. In this session I'll show you a set of commands which will help you start automating your tasks immediately.
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: BI
By the end of session users will understand:
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: DEV/DBA
By the end of the session you will have the know how to go away and create your own bespoke SQL Server development and testing environments.
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: DEV
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: DBA
How long since your last backup? How long since your last DBCC Check? Are your Agent Operators Correct? Is AutoClose, AutoShrink, Auto Update Stats set up correctly? Is DAC Allowed? Are your file growth settings correct, what about the number of VLFs? Is your latency, TCP Port, PS remoting as you expect? Is Page Verify, Data Purity, Compression correctly set up?
and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect i
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: DEV
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: DEV/DBA
The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.
Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases.
But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration including workload analysis, selecting the appropriate migration pathway and then putting it in place.
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: BI
In this session we will take different approach and built state of the art object detection model in easy to understand steps. First, we are going to make sure that everybody understand concepts of convolution networks, the importance of model architecture and loss function. Then we are going to build a model that will classify single object, a model that finds this object on a picture, and a model that combine both and is able to classify and localize the largest object in each image. Finally, we will move to multiple objects detection, discus latest architectures and design appropriate loss function for this task. All this illustrated with examples built using fastai library.
Event Date: 08-12-2018 - Session time: 10:15:00 - Track: BI/DEV
Covering models, dashboards, and other products built in R, you’ll look at how Docker containers can make managing dependencies a breeze, allow your code to be hosted anywhere, and have it work in high-scale systems.
Event Date: 08-12-2018 - Session time: 11:30:00 - Track: DBA
In this session, we will cover all aspects of HA / DR. We will cover all technology options and compare the benefits between them. We will also talk about processes to maintain your RPO and RTO level.
Event Date: 08-12-2018 - Session time: 11:30:00 - Track: DEV
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: 08-12-2018 - Session time: 11:30:00 - Track: BI
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud? This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
Event Date: 08-12-2018 - Session time: 11:30:00 - Track: BI/DEV
This new term was introduced by Satya Nadella and James Philips as the serving foundation for building powerful (cloud-baked) applications. PowerApps as the data manipulation part, Microsoft Flow as the connecting workflow engine and Power BI for analysis and reporting. In addition, the Common Data Service (CDS) and the Common Data Model (CDM) provide a solid framework for data storage and modelling. Join me in this session if you want to get an overview about the involved technologies, how they work together, see them live working together in many demos and how they will definitely change the way of building powerful solutions in the future!
Event Date: 08-12-2018 - Session time: 11:30:00 - Track: DEV/DBA
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: BI/DEV
They may not add up to exactly 50, but in this session I’ll show you lots of compelling visualizations produced with the help of the ggplot2 package and friends - and their usual small effort of coding. We will start beyond the usual bar, line or scatter plots.
Instead our screen will show diagrams that always made you think „How do they do that?“. We will see waterfall diagrams, violins, ridgelines, marginal histograms, maps and more… and you’ll get the code to reproduce everything.
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: BI
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: DEV/DBA
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: DBA
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
Event Date: 08-12-2018 - Session time: 13:30:00 - Track: DEV
Event Date: 08-12-2018 - Session time: 14:45:00 - Track: DEV
Hint: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Event Date: 08-12-2018 - Session time: 14:45:00 - Track: BI
But, has that been only UI introduction? Why and how Databricks does work under the hood? Do you want to know this new (still in private preview) feature of ADF and reveal the power of modern big data processes without knowledge of such languages like Python or Scala? We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Event Date: 08-12-2018 - Session time: 14:45:00 - Track: DBA
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: DEV/DBA
This session will give a short introduction to the Query Store feature in SQL 2016 and then dive into the Open Query Store (OQS) solution. William (co-creator of the OQS project) will explain the design of OQS and demonstrate the features. You will leave this session with an understanding of the features of Query Store and Open Query Store, and a desire to implement OQS in your systems when you return to the office.
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: BI
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: DEV
The intention of these improvements is to fix poor performing queries due to wrong cardinality estimations and other sub-optimal plan decisions, and hereby enhance query performance with almost no code changes.
This session will cover briefly all these features: Batch and Row Mode Memory Grant Feedback, Batch Mode Adaptive Join and Interleaved Execution, Table Variable Deferred Compilation, and Approximate Query Processing.
The session will address questions such as do I need to tune queries anymore, does the IQP solves parameter sniffing issues and so on, and also suggest how much improvements you should expect with this promising set of feautures.
Event Date: 08-12-2018 - Session time: 16:00:00 - Track: BI/DEV