Difinity 2018 Conference Sessions

[vc_row][vc_column][themeum_title title=”Difinity 2018 Conference Sessions for 13th and 14th of Feb 2018″][vc_row_inner][vc_column_inner][vc_column_text]List of sessions will be complete shortly. Please Stay Tuned![/vc_column_text][vc_separator][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row el_id=”evaluationcontetxt”][vc_column width=”1/2″][vc_column_text]Evaluation Contexts in DAX[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Evaluation contexts is one of the hardest things to master in DAX. It is not uncommon to think you know how evaluation contexts works only to find that you are completely stumped by a formula that is not doing what you expect. In this session Matt Allington will clearly explain the concepts of row context, filter context and context transition using on screen examples that anyone can understand. A working knowledge of the fundamentals of Power Pivot will be assumed but will be briefly covered in the session as well. Anyone with a working knowledge of DAX can learn from this session.[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”DAXasaQueryLanguage”][vc_column width=”1/2″][vc_column_text]DAX as a Query Language[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In 2011, Microsoft released the Vertipaq (also called xVelocity) database technology on the world. Vertipaq is the database technology that is better known as Power Pivot, Power BI and SSAS Tabular Edition. Many people (business and IT) already use Power Pivot, Power BI and SSAS Tabular to produce reporting and analytics tools. But did you know that these tools also have their own query language?   In traditional databases such as SQL server, it is possible to extract data into a new table. The same is possible using DAX as a query language with a tabular data model. In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model to write queries that interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report). The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”ThingsYouShouldNeverDoinMicrosoftSQLServer”][vc_column width=”1/2″][vc_column_text]

Things You Should Never Do In Microsoft SQL Server

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

In this fun session we’ll review a bunch of problem implementations that have been seen in the real world. Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes again.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”TableIndexingforthe.NETDeveloper”][vc_column width=”1/2″][vc_column_text]

Table Indexing for the .NET Developer

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Intermediate[/vc_column_text][vc_column_text]

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2000-2017 databases. We will also be looking into the new indexing features that are available in SQL Server 2012/2014/2016/2017 (and SQL Server 2005/2008) and how you the .NET developer can make the best use of them to get your code running its best.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”PowerBIGatewaysasasolution”][vc_column width=”1/2″][vc_column_text]

Power BI Gateways as a solution

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

There are number of blog posts, technical deep dive(s) and how-to articles on Power BI desktop and service but very few on Gateways for Power BI. Gateways form a major part of Power BI enterprise deployment and so in this introductory session we will go through ways of managing, configuring and administering Gateways for Power BI within an organisation. We will also discuss real-world scenarios for the application of Gateways and how you can benefit from Gateways being in different job functions.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”Whatarechat botsandwhydoweneedtheminBusinessintelligence?”][vc_column width=”1/2″][vc_column_text]

What are chat bots and why do we need them in Business Intelligence?

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In this session you will get to learn a) What are chat bots? b) How to develop a chat bot using Microsoft Bot Framework? c) How bots can be useful in Business Intelligence? d) Enabling Data driven conversations using bots

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”AnalysisServicesDataDNA”][vc_column width=”1/2″][vc_column_text]

Analysis Services Data DNA

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Intermediate[/vc_column_text][vc_column_text]

Have you ever wanted an overview of your cubes and their dimensions, attributes and measures? This session will show you how you can use Analysis Services DMVs to extract information about your cubes and collect it for later use. We will then see how you can report on top of it thus documenting your SSAS cubes. We will then hear about different scenarios where this data might be useful. The attendees will learn how to extract, transform and load the data into a database using SSIS. They will learn how to reports that show the relevant information for different scenarios and how my company is making use of these information for different purposes. Some of the use cases for this data can be aligning dimensions across cubes or creating a bus matrix for documentation purposes. At the end of the session the attendees leave with all the code needed to start on their own as well as the knowledge on how to extend and further the solution for their own purposes

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”impactofweather”][vc_column width=”1/2″][vc_column_text]

Impact of weather on English Premier League matches – Power BI analysis

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening at bet265 stadium? This session shows how you can use open data sources and web pages to gather data. How you can then manipulate and extend it and finally report on it. We will look into how you can use open weather data and combine it with data from web pages to create the dataset you need. 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 with them all the obstacles and learning I got when creating this report

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”ssrsandpowerbi”][vc_column width=”1/2″][vc_column_text]

SSRS and Power BI Report Server – What’s new

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

In SQL 2016, SQL Server Reporting Services (SSRS) underwent massive changes with the addition of many new reporting features. Since that release, there have been many further developments, including the release of Power BI Report Server and SSRS 2017. In this demo laden session, Craig will recap the changes that SSRS has undergone from SSRS 2016 onwards, as well as look at and discuss Power BI Report Server.This session will be valuable for anyone new to SSRS, or anyone who has not had an opportunity to work with the latest versions of SSRS.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”sqlserverinamultiplatform”][vc_column width=”1/2″][vc_column_text]

SQL Server in a multi-platform world – Windows/Linux/Mac

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

SQL Server is moving to a multi-platform world; in this session, we look at- SQL Server running on Windows and Linux; what’s included, what’s different, what’s the same – Co-existence / Migration options – Management and development tools across Windows/Linux/Mac

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”sqlserverquerystore”][vc_column width=”1/2″][vc_column_text]

SQL Server 2016 Query Store

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. It provides the ability to natively capture baseline data within SQL Server. Using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query.During this session we will take a thorough look at the Query Store, its architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”troubleshootingissues”][vc_column width=”1/2″][vc_column_text]

Troubleshooting Issues with Extended Events in real time

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 400 – Expert[/vc_column_text][vc_column_text]

Extended events to aid in performance tuning and in day to day administration specially when you don’t have any benchmarking data for troubleshooting issues. In this session, we will see how the Extended Events streaming API can be used to process events in a near real-time. We will demonstrate how this feature enables new possibilities to capture real time problems without enabling any third party tools or inbuilt SQL Server features to capture issues like blocking,  deadlocks, high CPU and many more.Extended Events were introduced in SQL Server 2008 but by SQL Server 2016, it has enhanced significantly. After this session, hopefully you will start using extended event, if you haven’t started using till now.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”designingasqlserveralwayson”][vc_column width=”1/2″][vc_column_text]

Designing a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements. You will learn: – Common design patterns and guidelines that you need to consider when building your architecture – Proper selection of quorum configuration – Network configuration for local and geographically dispersed replicas – Combining SQL Server Failover Clustering with AlwaysOn Availability Groups

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”whatsqlserverdbas”][vc_column width=”1/2″][vc_column_text]

What SQL Server DBAs Need To Know About Distributed Availability Groups

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate high availability and disaster recovery architecture to implement. In this session, we will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario and how you can combine them with the other high availability and disaster recovery features to meet your database recovery objectives and service level agreements.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”powerbirls”][vc_column width=”1/2″][vc_column_text]

Power BI Row Level Security Made Easy

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In this session I plan to go over the basics of what is Row Level Security for people in the audience who have not used Row Level Security before.I then plan to show how easy it can be to implement Row Level Security in your Power BI Model by leveraging the built in functionality, as well as leveraging Active Directory.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”testdrivendev”][vc_column width=”1/2″][vc_column_text]Test Driven Development in SQL Server – it will make your database deployments better[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]Test Driven Development (TDD) is a practice that has for years enabled application developers to write code that is less-buggy.
It is extremely relevant for database development, as it ensures that the code produced using TDD will be of higher quality, which means interactions with data and code are safer.
In this session we will go through how to setup some simple unit tests using various industry tools such as the open-source framework – tSQLt, the SQL Cop testing utility and Redgate’s SQL Test tool which brings it all together.
The advantage of these tools is that we can run them within our familiar SQL Server Management Studio, whereas other testing frameworks rely on the Visual Studio IDE.
It will be shown in a comprehensive DEMO how to bring TDD to your database development and result in higher quality deployments to your databases when incorporated into Continuous Integration processes.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”dynamicchartsfor”][vc_column width=”1/2″][vc_column_text]

Dynamic charts for browser and mobile with Excel

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Let’s face it, Excel is still the number one tool for data analysis and visualisation, because it is on everyone’s desk. Charts are the core of dashboards and reports and often require user choices and inputs. In this eye-opening session, you’ll discover different techniques to make Excel charts dynamic, including worksheet layout, tables, named ranges, and formulas. The best thing? All techniques covered in the session work without code and run perfectly in Excel online and Excel for mobile.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”introductiontobiml”][vc_column width=”1/2″][vc_column_text]

An introduction to the magical world of BIML!

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”performancetunningbi”][vc_column width=”1/2″][vc_column_text]

Performance Tuning for the BI Professional

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

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.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”azuresqldw”][vc_column width=”1/2″][vc_column_text]

Azure SQL Data Warehouse, Data Lake, Polybase, SSAS and Powerbi

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

This session will show you how to make the most of the Azure Data Platform, when it comes to massive amounts of data, how we can easily process and move this data using Data Lake, Polybase and SQL Data warehouse. Data is then moved to an Tabular SSAS instance and viewed in a PowerBI dashboard with lightning fast performance.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”datalake”][vc_column width=”1/2″][vc_column_text]

Data Lake Analytics – R, Python and Cognitive Services

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In this session we take a look and a deep dive into Aure Data Lake, a new feature on Azure that will enable amost anyone to work with BIG DATA. It combines C# and SQL to a language that is way more intuitive than what we are used to. Azure Data Lake Store, our new repository for data of various origins – we can collect, store and share data from this lake as we see fit. Azure Data Lake Analytics, a new way to scale and use your analytics on AZURE and BIG Data, it introduces U-SQL a new language combined of C# and T-SQL to make the task of analyzing BIG Data easier and more comprehendible. Azure Data Lake Tools for Visual Studio, provide an integrated development environment that spans the Azure Data Lake, dramatically simplifying authoring, debugging and optimization for processing and analytics at any scale. The newest addition to Data Lake Analytics is execution of R, Python and Cognitive Services, parts that this session will focus on.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”azuredbmigration”][vc_column width=”1/2″][vc_column_text]

Azure Database Migration – Choosing the Right Tier

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Microsoft has two different types of SQL Server services available in Azure. The SQL Server on an Azure VM is the IaaS (Infrastructure as a Service), which is easier to understand and migrate to. Microsoft offers two types of PaaS (Platform as a Service) or DBaaS (Database as a Service) for SQL Server Database native to could – Single Database and Elastic Pool. Choosing the right tier for your database gets harder with the complexity in calculating the resource utilization for your Azure SQL Database. In this session, I will walk you through the steps involved in analyzing the resource utilization and estimating the right tier to choose for your database in Azure.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”HybridArchitecturewithAzureDataSync”][vc_column width=”1/2″][vc_column_text]

Hybrid Distributed Architecture with Azure Data Sync 2.0

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

For a number of years, Azure Data Sync was stuck in “preview” mode in the old classic deployment model and with no updates on functionality over that time many thought that it was destined for the scrap heap. However with the recent revival and port to the Azure Resource Manager model it has become a viable option for organisations looking to deploy applications that are partially SaaS but with a local on-premises component. This session will show to use Azure Data Sync for centralised management of remote systems such as point-of-sales terminals. The session will show how to use Data Sync to gather data from each terminal and push down centralised changes to selected remote systems.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”splitmerge”][vc_column width=”1/2″][vc_column_text]

Split, Merge and Eliminate – An Introduction to Partitioning

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In my life as a Consultant, partitioning is one of the least used or even inefficiently used components of SQL Server that I have seen. Partitioning provides many potential benefits such as easier index maintenance, data loads and archiving using partition switching and improved query performance through partition elimination.. In this session we’ll cover the basics of partitioning – from getting started with partition switching to partition elimination to make your queries go faster – with plenty of demos for you to take away.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”reallifessis”][vc_column width=”1/2″][vc_column_text]

Real life SSIS for Port

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

This is the real life example on how to extract, transform, and load around 3 million transactions monthly for a shipping port to calculate the incentives for 2000 terminal operators. This session will let you know what are the do and don’t when you use SSIS for your real life day to day tasks. This session will also shows the best practices on deriving the data workflow.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”dbmonitoring”][vc_column width=”1/2″][vc_column_text]

Database Monitoring and Reporting in 2018

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In this Session we will look at how Powershell, PowerBI, SSRS, Flow and PoweApps can be used to provided a modern reporting environment that embraces the cloud and mobile options available in 2018. We will look at how the collection of Database Metrics and Performance Data can be automated via PowerShell and then made available across On_Prem and Mobile Applications by utilising PowerBI, SSRS, PowerApps and Flow. Attendees will leave with the required tools and information to be able to create a monitoring, alerting and reporting solution that is ready for environments of any size and embraces the tolls available in 2018

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”mdx”][vc_column width=”1/2″][vc_column_text]

Why MDX cubes aren’t dead yet

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Lets have a look at the pros and cons of the two SSAS offerings and see why Multi-Dimensional cubes still have a place.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”performancein60″][vc_column width=”1/2″][vc_column_text]

Performance in 60 Seconds – SQL Tricks Everybody MUST Know

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”sercretsofsql”][vc_column width=”1/2″][vc_column_text]

Secrets of SQL Server – Database Worst Practices

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

“Oh! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”datafactory”][vc_column width=”1/2″][vc_column_text]

Data Orchestration with Azure Data Factory

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

One of the biggest impediments to a successful data analytics project is the complexity involved in getting the data required for analysis in a timely and efficient manner. Azure Data Factory is a very powerful orchestration tool that can enable organizations to connect to numerous data sources and automate the process of moving data between various sources at predefined schedule. in this session you will learn the basics of Azure Data Factory, when and how to use it for several common data movement activities. Through an end to end demonstration you will learn how to create data pipelines for data movement and monitor the orchestration.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”catalog”][vc_column width=”1/2″][vc_column_text]

Azure Data Catalog – Do you know what you know

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]We are surrounded with data. Data is scattered across organizations. IOT is driving collection of data in massive scale. Data is available in public domain and can be bought from many sources. The need to manage information assets with metadata will remain a major challenge for data driven organizations. Self-service business intelligence solutions must be complemented with self-service data preparation system so that users can find the data they need, have appropriate access to the data that is in compliance with company policy and regulations and add valuable meta-data to a central repository of all the data assets for easy discovery. Any information governance practice such as Data governance, data quality or master data management will benefit from such a metadata store as well. In this session, you will learn how you can register, enrich, discover, understand, and consume data sources using Azure Data Catalog using the fully managed service offering from Microsoft. The presentation will include an overview of Azure Data Catalog and demonstration of tools and techniques for data discovery and metadata management.[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”bigdata”][vc_column width=”1/2″][vc_column_text]

Big Data Ingestion and Analytics with Microsoft Azure

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Azure is built to handle big data workloads.  From ingesting millions of events per second, to visualizing those events in a dashboard in real time (hot path), to storing for long term query and retrieval (cold path), Azure has the solutions.  In this talk we will take a look at a big data pipeline which includes Azure Event Hubs to ingest telemetry, Azure Stream Analytics and Power BI for real time dashboards, Azure Data Lake plus Azure Data Lake Analytics for big data retention and querying, Azure Data Factory and SQL Azure Data Warehouse for ETL.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”248″][vc_column width=”1/2″][vc_column_text]

2,4,8 & 16 – Journey of upgrading your data platform with SQL Server

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: Double Session – 150 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

2,4,8 & 16 – these aren’t just numbers to count or calculate. These are years that how SQL Server evolved as number of years! Why Upgrade? Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe & India) and SQLbits since 2008. In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading  SQL Server (2000 to  2012),  SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources. What to-do and what not-to-do? Real-world database demos and database upgrade with 40% demos. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why & how such a solution

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”datawarehouselightning”][vc_column width=”1/2″][vc_column_text]

Datawarehouse Lightning Performance with Columnstore!

[/vc_column_text][vc_column_text]Track: SQL Server Performance Tuning
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips & tricks on how to get the performance you want out of Columnstore. We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created, and some dangers with performance you might face when working with Columnstore Indexes as seen in the field!

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”realtimeanalytics”][vc_column width=”1/2″][vc_column_text]

Realtime Analytics: OLAP & OLTP in the mix!

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

Since SQL Server 2016 it is possible to have an OLTP & OLAP workload together. This can be achieved using columnstore indexes. We will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then we will take a deepdive on how the columnstore works, explaining what a delta store is, how delete and update operations work, what batch mode processing is, what the different kind of segments are & how to maintain your columnstore indexes. We will conclude by showing you how to combine OLTP & OLAP workload on a database as seen in the field. Showing you issues you might face & how to make it fit for your environment

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”cosmosdb”][vc_column width=”1/2″][vc_column_text]

Azure Cosmos DB

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”secure”][vc_column width=”1/2″][vc_column_text]

Secure your data at rest – on demand, now!

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Description The new releases of Microsoft SQL Server: SQL Server 2016 & 2017 brings new functionality for Data Security Professionals. Now you can protect your data in your database anywhere (on-premise, in the cloud, even in the hybrid environment) even more simply than before. Transparent Data Encryption with better algorithms and better support for backup, Row-Level Security, Dynamic Data Masking and AlwaysEncrypted for your application are now simple features. We focus on hard theory and of course, on demos. We look a little closer for few specific files that exist in our environment. We work on all three different environments, but our goal is only one: protect your data.Objective New Security Features, SQL Server 2016, Microsoft Azure SQL Database, Encryption, Data Security

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”ad2018″][vc_column width=”1/2″][vc_column_text]

AD 2018. 2 AM. A New Disaster just began.

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Description 2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we will NOT talk about the potential disaster (Business Continuity Management); we talk about: What happened NOW? What tasks should have been finished BEFORE! Is virtual or physical SQL Server matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I’ll show which part of our SQL Server Environment is critical and how to be prepared for the disaster. With some papers, I’ll show you how to be BEST prepared for Early Morning Disaster.Objective SQL Server 2014, SQL Server 2016, Backup, Restore, SQL Azure, Microsoft Azure SQL Database, Best Practices

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”performancetuningsqlsentry”][vc_column width=”1/2″][vc_column_text]

Performance Tuning with SQLSentry for SQL Server

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

As a Database professional, we are responsible for ensuring our data is accessible for the business in an optimal manner. However sometimes performance problems arise with our database that causes the business applications to slow down. Are you equipped with the right tools to quickly identify what has changed and what is going on in your environment that has caused this slowdown? In this Session, Warwick will introduce you to how to quickly identify what you need to look at and how to resolve this with the help of SQLSentry for SQL Server by SentryOne.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”powerquerym”][vc_column width=”1/2″][vc_column_text]

Power Query and M Deep Dive

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. This session is full of live demos. Prepare to be amazed with what Power Query can do with heaps of demos in this session.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”graph”][vc_column width=”1/2″][vc_column_text]

SQL Server Graph Database

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

A new feature introduced in SQL Server 2017 and Azure SQL DB is the ability to describe a graph, store data in form of nodes and edges making up a graph. This allows real-world scenarios such as recommendation systems, fraud detection, and basket analysis to be implemented more efficiently with SQL technologies.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”pbisharingsecurity”][vc_column width=”1/2″][vc_column_text]Building Fast and Reliable Reporting with Power BI[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Fast reports are a delight to use. Slow reports languish into obscurity. How do we build reports that are fast and reliable? Join us for a deep dive into Power BI performance tuning and optimization. We’ll cover the basic patterns for Power BI usage, performance implications and best practices, including security, workspaces, apps and content packs, as well as RLS and more.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”pbiembedded”][vc_column width=”1/2″][vc_column_text]

Power BI Embedded; Developers Guide

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Power BI is not just a self-service tool for business analysts. Power BI has many features that helps developers to build their reporting solution. Power BI Embedded, real-time streaming with Power BI, along with all powerful analytical engine of Power BI, helps developers to take their reporting to the next level. Come to this session to learn about all features that Power BI provides for developers.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”azureml”][vc_column width=”1/2″][vc_column_text]

Azure Machine Learning algorithm accuracy enhancement, tips, and tricks

[/vc_column_text][vc_column_text]Track: Data Science
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

Azure ML is the Microsoft cloud based Machine Learning tool. It provides a variety of algorithms for performing descriptive, predictive, and prescriptive analysis. Moreover, it supports a variety of data science techniques for data wrangling, feature selection, cross validation, and so forth for enhancing the algorithm accuracy. In this session, I will talk about how to do feature selection in Azure ML to find proper attributes. Also, I will demo how to do data sampling and cross validation using existing components in Azure ML which will help to enhance machine learning accuracy. Moreover, I will show some of the main components that we can use for data cleaning like normalization, clip values and so forth.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”pbiviz”][vc_column width=”1/2″][vc_column_text]

Power BI Visualization Best Practices

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Data Visualization is the front end of every BI system, and getting it right is one of the most important tasks in a BI application. Good visualization will benefit the decision making process, while bad visualization can lead to wrong decisions. In this session, you will learn how to create the right chart or visual, with examples ranging from line charts, bar/column charts, and some other useful chart styles in Power BI. You will also learn some tips and tricks to control interactivity of visuals in Power BI. Session is full of demos, and through that you will learn tips and tricks for choosing best colors and best visuals for your solution.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”casestudy”][vc_column width=”1/2″][vc_column_text]Genesis Energy Implementation: Technical reference and Design patterns for enterprise BI and reporting supporting data science teams[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

In this session we walk through the recently announce the technical reference implementation for BI and reporting solution to augment your data science and analytics platform on Azure.   This reference implementation enables you to fast track your infrastructure deployment, so that you can focus on the main goal of building a BI and reporting application that addresses your ever changing business needs.   We will cover the following : pre-built with components like Blob, SQL Data Warehouse, SQL Database, and Analysis Services in highly scalable configurations that have been proven in the field to meet enterprise requirements. configuration of software for virtual network configuration, job orchestration for data ingestion and flow, system management, monitoring, and other operational essentials for a production system. Also we will Chris Lowe from Genesis Energy’s implementation of this architecture and share their experience with design and deployment.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”rpowerbi”][vc_column width=”1/2″][vc_column_text]

Endless Possibilities: R and Power BI

[/vc_column_text][vc_column_text]Track:  Data Science
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]R integration with Power BI provides more flexibility for users. People are able to have more visualizations which not exist currently in Power BI such as: normal distribution chart, column width chart, different type of subplots in a map, five dimensions’ chart with facet chart and so forth. Moreover, writing R scripts inside power query and Power BI Visualization enable users to do machine learning using R cods. The other possibilities that recently added, people able to create custom R visual with plotly package to make their visualization much more interactive, accessible and more flexible. In this session, first I will show how to create some interesting charts using ggplot2 package inside Power BI. Then, I will show how to do Machine Learning inside Power query by following machine learning process: data gathering, data cleansing, feature selection, model creation, data sampling and finally prediction. Also, I will show the main process to create a custom R visual (pbiviz) file through the installing Power BI tools. Finally, a brief demo in current available R visual produces by Microsoft team will be presented.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”customconnector”][vc_column width=”1/2″][vc_column_text]

Custom Connectors in Power Query

[/vc_column_text][vc_column_text]Track:Business Intelligence
Length: 75 minutes
Level: 400 – Expert[/vc_column_text][vc_column_text]Custom connectors is a new features in Power Query and Power BI. You can now create connections to all new sources yourself. This session is all about creating custom connectors and things you need to know about it.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”pbiarchitecture”][vc_column width=”1/2″][vc_column_text]

Power BI Solution Architecture; DirectQuery, LiveQuery, or Import Data

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Choosing the right method is an important step for your Power BI Solution Architecture, which you need to decide about it usually in early phases before starting implementation. In this session, I’m going to explain in details what every method is, and the answer to all questions below;

• What is Import Data/Schedule Refresh?
• What is DirectQuery?
• What is Live Connection?
• What is Difference between Live Connection and DirectQuery?
• Pros and Cons of Each Method
• Which method is performing best and fastest?
• Which method is more flexible?
• Which method is more scalable?
• What are Architecture Scenarios to use Each Method?
• What is the Gateway Role?

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”integration”][vc_column width=”1/2″][vc_column_text]

Data Integration – preparing for the data challenges of tomorrow

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]With the ever increasing demand of data and information from the business, data professionals are increasingly feeling the pressure to deliver. This often results in us not being able to see the forest through the trees and we struggle making all those data streams come together in well tuned governed process. Many of us see understand the separate technology pieces that make up Data Integration architecure but we often loose the overview and how to make it all work together.

In this session I would like to share some pearls of wisdom on how to make the various tools work for your Data Integration projects. Show the common pittfalls and failures of big Data Integration projects and how to avoid them. Data Profiling, Performance tuning, Baseline measurements, master data management, data quality assesment, integration services are all cogs in the large machine called data integration. I hope to show you how you can oil that machine to make it work seamlesly for your organization.[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”letsstartcognitive”][vc_column width=”1/2″][vc_column_text]

Let’s start using Cognitive Services in our business apps!

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

Our business application started to be more and more intelligent. And we can use a lot of data that we never had a chance to use in our application. To do that we can easily use API provided by Microsoft Cognitive Services. There are 30-ish API’s that are really clever and can provide object recognition, face detection and identification, emotion recognition, computer vision, video services, speech and speaker recognition, language understanding, text analytics, sentiment analysis, knowledge exploration, search services, and more. If you want to add to your application more intelligent futures, come to this session to more understand what Cognitive Services are and get some ideas how you can use in your business today.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”powerbissas”][vc_column width=”1/2″][vc_column_text]Super Charge Power BI and What is new with Analysis Services[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session introduces Azure Analysis Services as a fully-managed platform as a service (PaaS) in Azure. We will discuss where Analysis Services fits into Microsoft’s BI platform and strategy, reference architectures and cloud efficiencies. Modeling and analytics features covered by the last two compatibility levels will be reviewed and demonstrated, including Power Query connectivity, object-level security, and Detail Rows for non-technical users to drill through to transactional records.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”premium”][vc_column width=”1/2″][vc_column_text]Introducing Power BI Premium[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Extend your Power BI solution to everyone on your team with Power BI Premium! Learn how our latest offering can bring you dedicated capacity for your organization.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”thelastmile”][vc_column width=”1/2″][vc_column_text]The last mile – Operationalization of Maching Learning[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]So you’ve built your AI/Machine Learning model. What next? How do you extract value out of your model and integrate them into you business? In this session, we show you different options available in the Microsoft stack; from both on-prem and cloud or a fully hybrid one.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”botsandcogs”][vc_column width=”1/2″][vc_column_text]Are you ready for Artificial Intelligence? – Bots and Cognitive Services[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]It’s 2018 and AI is definitely here to stay! Learn all about Microsoft’s BotFramework and the various Cognitive Services that support it! In this short session, we will learn about the concepts behind the Botframework, from what’s inside and how one could build and deploy bots. We’ll also cover some of the ‘brains’ behind a bot, such as LUIS, a service which powers how phrases are quickly matched to an intent.  Concepts such as utterances, entities, intents and training LUIS are covered in this session.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”whatdevops”][vc_column width=”1/2″][vc_column_text]What is DevOps and why do I care?[/vc_column_text][vc_column_text]Track: Database Development
Length: 75 minutes
Level: 100 – Intermediate[/vc_column_text][vc_column_text]If you like an interactive and lively sessions them this is the place for you.
We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional.
We’ll take a peak at what it means for the technology professional as well as what it means for the business professional.
We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up.
We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption.
We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these.
Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates knowledge.
At the very least, you’ll make some new friends.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”privandprof”][vc_column width=”1/2″][vc_column_text]Data Privacy and the Data Professional[/vc_column_text][vc_column_text]Track: Database Development
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]It’s almost a daily occurrence to hear about some sort of data breach.
But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional.
As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex.
Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world.
We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking – to help with this sort of thing – but is there a better answer?
Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”correctlyaa”][vc_column width=”1/2″][vc_column_text]Correctly Architecting Availability Group Solutions[/vc_column_text][vc_column_text]Track: Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]With the release of SQL Server 2017, Microsoft has further enhanced the capabilities of Availability Groups. Clearly Microsoft is investing more in Availability Groups compared to Failover Clustering. However, this does not mean that you should automatically architect Availability Groups over Failover Cluster Instances.
In this session we will have a look at how to correctly architect and deploy Availability Groups. We will cover areas including: new features in SQL Server 2017 (and 2016), Availability Group internals, potential performance overhead of Availability Groups, licensing considerations and where to deploy Failover Clustering instead. We will look at the pros and cons of deploying Availability Groups over Failover Clustering.
If you are considering implementing Availability Groups in your new SQL Server high availability deployment this practical session should prove to be invaluable.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”azureiot”][vc_column width=”1/2″][vc_column_text]Azure IoT – Opportunities are Endless[/vc_column_text][vc_column_text]Track: Azure
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]How Microsoft is trying to simplify deliver of the IoT, examples of how it’s been used for business transformation and how Microsoft is investing to create new value with the Intelligent Edge + Intelligent Cloud.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”microsoftiot”][vc_column width=”1/2″][vc_column_text]Microsoft IoT Central – Enterprise IOT as-a-Service[/vc_column_text][vc_column_text]Track: Azure
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Microsoft IoT Central is a fully managed IoT SaaS (software-as-a-service) solution that makes it easy to connect, monitor and manage your IoT assets at scale, so you can create deep insights from your IoT data and take informed action.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”sparkr”][vc_column width=”1/2″][vc_column_text]Scalable Data Science with SparkR on HDInsight[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]R, a powerful statistical programming language, is unfortunately single threaded and therefore, natively limited to a single node. What happens when data scientists need more resources that can fit in single server? Enter Apache Spark – a leading distributed in-memory analytics platform for data analysis, with interfaces in Scala, Python and of course, R. In this demo heavy session, we’ll take a look at using SparkR for scalable data analytics on an HDInsight cluster. First, we start with a technical and architectural overview of Apache Spark, SparkR and HDInsight. Then we’ll cover the basics of performing distributed data manipulation, cleansing, and machine learning using SparkR utilizing HDInsight, as well as how to parallelize existing R scripts and R packages using SparkR’s UDFs.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”adaptivequery”][vc_column width=”1/2″][vc_column_text]Adaptive Query Processing and Automatic Tuning[/vc_column_text][vc_column_text]Track: Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Automatic Tuning and Adaptive Query Processing are perhaps the two key features of SQL Server 2017 and Azure SQL Database which would influence query optimizer’s plan choices. The following session will provide an overview of the features and explain how it can help to address performance issues like parameter sniffing, plan regressions, lack of indexes or too many indexes without any manual intervention and change of code.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row][vc_row el_id=”ssisdf”][vc_column width=”1/2″][vc_column_text]SSIS in Azure Data Factory v2 – a game changer?[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]SQL Server Integration Services in Azure Data Factory v2 is a solution for ETL/ELT workflows. Using SSIS in ADFv2, we will show you how to move all/parts of your on-premises ETL workloads and just “lift & shift” many existing SSIS packages to Azure, lowering your operational costs and gaining scalability + high availability. We will guide you end-to-end from provisioning Azure-SSIS Integration Runtime (IR) as the managed, dedicated, scaled up/out compute resource for SSIS to scheduling parallel package executions on it. But is it useful, is it fast, is it easy and powerful to use ? And most of all is ADF a replacement for SSIS or is it complementing it for hybrid ETL scenarios?

These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline.[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”kerberos”][vc_column width=”1/2″][vc_column_text]Kerberos for BI[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Have you ever seen this message “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON”

Have you ever witnessed Kerberos mentioned in a conversation – or in a forum – and seen developers shiver, sysadmins crawl back under their rock and project managers fear for the consumed hours ?

Have you ever wondered why it seems so complicated ?

If you answered yes to any of these question then this demo-packed session is for you.

Because Kerberos is something that anyone who must deploy SQL Server wishes they didn’t have to worry about. It truly affects all aspects of SQL Server including the engine, Reporting Services, Analysis Services, SharePoint and PowerPivot. Furthermore we will have a close look at how to diagnose problems and troubleshoot the three-headed beast when it breaks loose.

This session is based on many hours spent sweating in setting up Kerberos in BI and SharePoint environments and explaining support people how to troubleshoot and fix Kerberos issues when they arise.[/vc_column_text][/vc_column][vc_column width=”1/2″]

[/vc_column][/vc_row][vc_row el_id=”DSVM”][vc_column width=”1/2″][vc_column_text]Deep Learning with TensorFlow and the Data Science Virtual Machine[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]The Data Science Virtual Machine is designed and configured for working with a broad range of usage scenarios and can be utilised as a one-stop-shop for a data scientists’ Big Data analytic workloads. You are able to scale your environment up or down as your project needs change, use your preferred language to program data science tasks and install other tools and customise the system for your exact needs.
First, we start with a technical and architectural overview of the Data Science Virtual Machine and TensorFlow. Then, we will demonstrate how to provision the services using a business case scenario and build out an end-to-end solution for Big Data Deep Learning workloads.[/vc_column_text][/vc_column][vc_column width=”1/2″][/vc_column][/vc_row]