Event Date: 09-09-2017 - Session time: 08:30:00 - Track: DBA
In this session we will walk through the techniques required to detect and repair various forms of Corruption Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes. Warning: Hex Editors and DBCC Page dumps will be involved!
Event Date: 09-09-2017 - Session time: 08:30:00 - Track: BI
In this session, Prathy will show top features of Power BI Report Server. Various ways of designing and publishing reports to SSRS web portal/Power BI Report Server using SQL Server Data Tools (SSDT), Report Builder, SQL Server Mobile Report Publisher and Power BI Desktop (Technical Preview of Power BI reports in SQL Server Reporting Services).
Event Date: 09-09-2017 - Session time: 08:30:00 - Track: DEV
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: BI
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.
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: Cloud
Come along and dive deeper into azure storage for SQL. Topics covered include:
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: DEV
You will se how queries are run, how indexes are used and get an insight into what query plans tell you. Further on you'll be introduced to In-Memory and Column Store indexing to get a fair chance of selecting appropriate indexing for your query load.
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: DBA
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: BA
Magic is just sufficiently advanced technology, and most of a data scientist's magic is a good process, a robust understanding of data, and the ability to sensibly apply some recipes.
Let's go behind the curtains and see the process and the fundamentals employed in making any prediction. Learn enough to start adding magic to your own work.
Event Date: 09-09-2017 - Session time: 10:00:00 - Track: BI
Azure Data Factory. This is not SSIS in Azure. But it’s a start for our control flows. Let’s update our terminology and understand how to invoke our Azure data services with this new controller/conductor who wants to understand our structured datasets. Learn to create the perfect dependency driven pipeline with Azure Data Factory and allow your data to flow. What’s an activity and how do we work with time slices? Is a pipeline a pipeline? Who is this JSon person? All the answers to these questions and more in this introduction to working with Azure Data Factory. Plus, insights from a real-world case study where ADF has been used in production for a big data business intelligence solution handling log files for 1.5 billion users.
Event Date: 09-09-2017 - Session time: 11:15:00 - Track: BI
Did you ever wonder, how to deploy a cube, with minimum impact to query performance? Or how to optimize processing performance? Are you really ready to deploy when its required? Or do you get nervous every time? Attend this session to build and improve your SSAS Developer skills, by exploring: Partitioning Unit Testing Synchronization Custom Assemblies PowerShell to tie all the ends together.
Event Date: 09-09-2017 - Session time: 11:15:00 - Track: BA
Event Date: 09-09-2017 - Session time: 11:15:00 - Track: Other
What most resources usually cover is, at best, some step by step configuration instructions for a particular architecture. Such instructions often lack explanation of why it has to be done that way in terms of the role of every step in the authentication process.
I would like to present easy to follow principles of Kerberos constrained delegation and protocol transition with handy tips and templates to get this right the first time for your particular environment. The goal is to explain the meaning of the settings in terms of the role in the Kerberos constrained delegation authentication.
This presentation covers some very useful resources to help you tame your three-headed monster. I will also do a demo of configuration and troubleshooting
Event Date: 09-09-2017 - Session time: 11:15:00 - Track: Cloud
We will cover:
Event Date: 09-09-2017 - Session time: 11:15:00 - Track: DEV
This session introduces the temporal problems, deals with solutions that go beyond SQL Server 2016 support, and shows out-of-the-box solution in SQL Server 2016, including: • Defining temporal data • Application versioned tables in SQL Server • System versioned tables in SQL Server 2016 • What kind of temporal support is still missing
Event Date: 09-09-2017 - Session time: 11:15:00 - Track: BI
Having covered the basics in part 1 we’ll now go beyond the Azure Data Factory basic activity types and Azure Portal wizard. Extract and load are never the hard parts of the pipeline. It is the ability to transform, manipulate and clean our data that normally requires more effort. Sadly, this task doesn’t come so naturally to Azure Data Factory, as an orchestration tool so we need to rely on its custom activities to break out the C# to perform such tasks. Using Visual Studio, we’ll look at how to do exactly that and see what’s involved in Azure to utilise this pipeline extensibility feature. What handles the compute for the compiled .Net code and how can does this get deployed by ADF? Let’s learn how to fight back against those poorly formed CSV files and what we can do if Excel files are our only data sou
Event Date: 09-09-2017 - Session time: 12:30:00 - Track: Sponsor
Event Date: 09-09-2017 - Session time: 13:10:00 - Track: Sponsor
Event Date: 09-09-2017 - Session time: 13:45:00 - Track: BI
If you are releasing database changes, new reports, cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition. DevOps is a way to bridge the gap between developers and IT professionals and for that we need to address the toolchain to support the practices. 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 Visual Studio Online (tool) Feature/PBI/WI (concept) Team Foundation Server Code Branching (concept) Build Agents (tool) PowerShell Microsoft's "Glue" (tool)
Event Date: 09-09-2017 - Session time: 13:45:00 - Track: Cloud
Event Date: 09-09-2017 - Session time: 13:45:00 - Track: DBA
Attendees will be taken through the following: -
Defining what containers are (benefits and limitations) Configuring Windows Server 2016 to run containers Installing the docker engine Pulling SQL images from the docker respository Running SQL Server containers Committing new SQL Server images Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)
This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of Windows Server administration
Event Date: 09-09-2017 - Session time: 13:45:00 - Track: BI
When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report.
In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share all the obstacles and learning I got when creating this report reveiling both the limitation of Power BI Desktop and open data as well as its strength.
Event Date: 09-09-2017 - Session time: 13:45:00 - Track: Cloud
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: DEV
In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.
This session is for anyone who is new to R and is interested in expanding their skill set beyond their comfort zone in SQL Server.
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: BI
Governance require you to anonymise the PPI data but how do you retain it safely and how do you unlock its value?
We dig into the magical land of "Snakes" and "Ladders" commonly used by fraud prevention agencies to unlock trend and profile analytics.
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: BI
Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
We are analyzing typical scenarios from classical multi-dimensional analysis like YTD calculation, DistinctCount and others in regards to their efficiency with different solution approaches: Classical multi-dimensional databases in ROLAP mode, DirectQuery, T-SQL… And we are going to show how Columnstore indexes are influencing those solutions.
Find out about advantages and disadvantages of the different solutions in regards to the problem. And maybe you will discover new approaches for your own challenges.
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: DBA
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: Cloud
Event Date: 09-09-2017 - Session time: 15:00:00 - Track: BI
If you are releasing database changes, new reports, cubes or SSIS packages on a regular basis, you've probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition. DevOps is a way to bridge the gap between developers and IT professionals and for that we need to address the toolchain to support the practices. 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 Visual Studio Online (tool) Feature/PBI/WI (concept) Team Foundation Server Code Branching (concept) Build Agents (tool) PowerShell Microsoft's "Glue" (tool)
Event Date: 09-09-2017 - Session time: 16:10:00 - Track: BA
since Microsoft is committed to integrate it into their data platform products.
So you installed the R base system and the IDE of your choice. But it's like buying a new car - nobody is content with the standard. You know there are packages to get you started with analysis and visualization, but which ones?
A bundle called The Tidyverse comes in handy, consisting of packages mostly (co-)authored by Hadley Wickham, one of the brightest minds in the R ecosystem.
We will take a look at the most popular Tidyverse ingredients like ggplot2, dplyr and readr, and we'll have lots of code demos on real world examples.
Event Date: 09-09-2017 - Session time: 16:10:00 - Track: DBA
Event Date: 09-09-2017 - Session time: 16:10:00 - Track: BI
During this session I will go through and explain some examples and best practices on generating a SSAS tabular model by using the new TOM. I will spend some time showing and explaining a real world example on pushing measure creation and changes to the key business stakeholders and to ensure quick time to market.
The last thing i will show is how you speed up your development free up up to 50% of the time you spend building tabular models with the simple and advanced features of Tabular Editor 2.0
Event Date: 09-09-2017 - Session time: 16:10:00 - Track: DEV
This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework - and address questions such as
Why is database unit testing difficult? What do I need to test? What do I not need to test? What does a "good" unit test look like? What tests should I be writing anwyay?
This session will incorporate real-life experiences with tSQLt, as well as lessons that can be learned from other testing framworks and other programming languages.
Event Date: 09-09-2017 - Session time: 16:10:00 - Track: Cloud
But how do you start putting a real-time streaming dashboard together? For the first time, it's actually straightforward to achieve. This session will run through an example streaming application, taking live statistics from a dance-mat game through to a live dashboard. We'll go from scanning log files, pushing messages to an Event Hub, through Streaming Analytics into a live PowerBI Streaming Dashboard.
This demo-heavy, practical session will tell you all you need to know to get started with real-time reporting with Microsoft Azure.