Difinity 2018 Sessions Recording
Watch all videos from Difinity 2018. 55 technical sessions plus a keynote. more than 60 hours of content about Power BI, Microsoft SQL Server, AI, Analytics, Machine Learning, Azure and IOT.
WHAT IS DIFINITY CONFERENCE 2018
Microsoft Data Platform, Business Intelligence, and Analytics Conference
Difinity is the largest Microsoft Data Platform, Business Intelligence, and Analytics Conference in New Zealand. IT Decision Makers, Developers, Analysts, IT Professionals, BI Managers, BI Professionals, Database Administrators, Architects, Digital & Big Data business leaders, and Consultants will gather for three consecutive days of learning.
There will be 55 technical sessions delivered by 40 speakers from all around the world, including Microsoft Most Valuable Professionals, Microsoft Certified Masters, and Microsoft Corporate’s product teams. Sessions will be split into tracks for Data Platform, Business Intelligence, and Analytics.
40 Speakers; 10+ from Microsoft, 20+ Microsoft Most Valuable Professionals (MVP), MCMs and Microsoft Certified Architects (MCA). 8 pre-conference workshops at 12th of Feb. and 55 sessions at 13th and 14th of Feb.
More details about the conference here: http://difinity.co.nz/
Lessons
Azure SQL Data Warehouse, Data Lake, Polybase, SSAS and Power BI
Kenneth Nielsen – Analytics 200 Level Intermediate This session will show you how to make the most of the Azure Data Platform, when it comes to massive amounts of data, how…
DAX as a Query Language
Matt Allington – Power BI 200 Level – Intermediate “In 2011, Microsoft released the Vertipaq (also called xVelocity) database technology on the world. Vertipaq is the database technology that is better…
Building Fast and Reliable Reporting with Power BI
Siva Harinath and Sergei Gundorov – Power BI 300 Level – Advanced Fast reports are a delight to use. Slow reports languish into obscurity. How do we build reports that are fast…
Azure IoT – Opportunities are Endless
Samuel Denton- Giles Analytics 200 Level – Intermediate How Microsoft is trying to simplify deliver of the IoT, examples of how it’s been used for business transformation and how Microsoft is…
SSRS and Power BI Report Server – What’s new
Craig Bryden – Power BI 100 Level – Basic “In SQL 2016, SQL Server Reporting Services (SSRS) underwent massive changes with the addition of many new reporting features. Since that release,…
SSIS in Azure Data Factory v2 – a game changer?
Regis Baccaro – BI 300 Level – Advanced “SQL Server Integration Services in Azure Data Factory v2 is a solution for ETL/ELT workflows. Using SSIS in ADFv2, we will show you…
Deep Learning with TensorFlow and the Data Science Virtual Machine
Chimene Bonhomme – BI 300 Level – Advanced “The Data Science Virtual Machine is designed and configured for working with a broad range of usage scenarios and can be utilised as…
Performance Tuning for the BI Professional
Jonathan Stewart – BI 200 Level – Intermediate Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important…
Dynamic charts for browser and mobile with Excel
Ingeborg Hawighorst – Power BI 200 Level – Intermediate 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…
Analysis Services Data DNA
Ásgeir Gunnarsson – BI 200 Level – Intermediate “Have you ever wanted an overview of your cubes and their dimensions, attributes and measures? This session will show you how you can…
Endless Possibilities: R and Power BI
Leila Etaati – Analytics 300 Level – Advanced R integration with Power BI provides more flexibility for users. People are able to have more visualizations which not exist currently in Power BI…
Power BI Gateways as a solution
Philip Seamark – Power BI 200 Level – Intermediate 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…
Kerberos for BI
Regis Baccaro – BI 300 Level – Advanced “Have you ever seen this message “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON” Have you ever witnessed Kerberos mentioned in a conversation – or…
Data Lake Analytics – R, Python and Cognitive Services
Kenneth Nielsen – Analytics 200 Level – Intermediate In this session we take a look and a deep dive into Aure Data Lake, a new feature on Azure that will enable amost…
Data Privacy and the Data Professional
Martin Catherall – SQL Server Admin 200 Level – Intermediate “It’s almost a daily occurrence to hear about some sort of data breach. But what are the consequences of a data breach…
SQL Server in a multi-platform world – Windows/Linux/Mac
David Lyth – SQL Server Admin 200 Level – Intermediate “SQL Server is moving to a multi-platform world; in this session, we look at – SQL Server running on Windows and Linux;…
Split, Merge and Eliminate – An Introduction to Partitioning
Martin Cairney – SQL Server Admin 200 Level – Intermediate In my life as a Consultant, partitioning is one of the least used or even inefficiently used components of SQL Server that…
Test Driven Development in SQL Server – it will make your database deployments better
Hamish Watson – SQL DEV 100 Level – Basic “Test Driven Development (TDD) is a practice that has for years enabled application developers to write code that is less-buggy. It is extremely…
SQL Server 2016 Query Store
Dharmendra Keshari – SQL Server Admin 300 Level – Advanced “The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. It provides the ability to natively…
Designing a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity
Edwin Sarmiento – SQL Server Admin 300 Level – Advanced So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different…
Azure Cosmos DB
Satya Jayanty – SQL DEV 200 Level – Intermediate In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which…
Performance in 60 Seconds – SQL Tricks Everybody MUST Know
Pinal Dave – SQL Server Admin 100 Level – Basic Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a…
Datawarehouse Lightning Performance with Columnstore!
Stijn Wynants – SQL Server Admin 200 Level – Intermediate “During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips &…
Database Monitoring and Reporting in 2018
Patrick Flynn – SQL Server Admin 200 Level – Intermediate “In this Session we will look at how Powershell, PowerBI, SSRS, Flow and PoweApps can be used to provided a modern reporting…
Power BI Visualization Best Practices
Reza Rad – Power BI 200 Level – Intermediate Data Visualization is the front end of every BI system, and getting it right is one of the most important tasks in a…
Secure your data at rest – on demand, now!
Tobiasz Koprowski – SQL Server Admin 200 Level – Intermediate “The new releases of Microsoft SQL Server: SQL Server 2016 & 2017 brings new functionality for Data Security Professionals. Now you can protect…
What are chat bots and why do we need them in Business Intelligence?
Anupama Natarajan – Analytics 200 Level – Intermediate “In this session you will get to learn a) What are chat bots? b) How to develop a chat bot using Microsoft Bot Framework?…
SQL Server Graph Database
Dave Dustin – SQL DEV 200 Level – Intermediate A new feature introduced in SQL Server 2017 and Azure SQL DB is the ability to describe a graph, store data in form…
Super Charge Power BI and What is new with Analysis Services
Siva Harinath – Power BI 200 Level – Intermediate Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as…
Correctly Architecting Availability Group Solutions
Victor Isakov – SQL Server Admin 300 Level – Advanced “With the release of SQL Server 2017, Microsoft has further enhanced the capabilities of Availability Groups. Clearly Microsoft is investing more in…
AD 2018. 2 AM. A New Disaster just began.
Tobiasz Koprowski – SQL Server Admin 200 Level – Intermediate “2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we will NOT talk about…
Secrets of SQL Server – Database Worst Practices
Pinal Dave – SQL Server Admin 200 Level – Intermediate “Oh! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples…
2,4,8 & 16 – Journey of upgrading your data platform with SQL Server
Satya Jayanty – SQL Server Admin 300 Level – Advanced “2,4,8 & 16 – these aren’t just numbers to count or calculate. These are years that how SQL Server evolved as number…
Evaluation Contexts in DAX
Matt Allington – Power BI 200 Level – Intermediate Evaluation contexts is one of the hardest things to master in DAX. It is not uncommon to think you know how evaluation contexts…
Performance Tuning with SQLSentry for SQL Server
Warwick Rudd – SQL Server Admin 200 Level – Intermediate As a Database professional, we are responsible for ensuring our data is accessible for the business in an optimal manner. However sometimes…
Azure Database Migration – Choosing the Right Tier
Manohar Punna – SQL Server Admin 200 Level – Intermediate “Microsoft has two different types of SQL Server services available in Azure. The SQL Server on an Azure VM is the IaaS…
Are you ready for Artificial Intelligence? – Bots and Cognitive Services
Julian Lee – Analytics 200 Level – Intermediate 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…
Adaptive Query Processing and Automatic Tuning
Nagaraj Venkatesan – SQL Server Admin 300 Level- Advanced Automatic Tuning and Adaptive Query Processing are perhaps the two key features of SQL Server 2017 and Azure SQL Database which would influence…
What SQL Server DBAs Need To Know About Distributed Availability Groups
Edwin Sarmiento – SQL Server Admin 300 Level – Advanced With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate…
Power BI Row Level Security Made Easy
Gilbert Quevauvilliers – Power BI 200 Level – Intermediate In this session I plan to go over the basics of what is Row Level Security for people in the audience who have…
Realtime Analytics: OLAP & OLTP in the mix!
Stijn Wynants – BI 300 Level – Advanced “Since SQL Server 2016 it is possible to have an OLTP & OLAP workload together. This can be achieved using columnstore indexes. We will…
The last mile – Operationalization of Maching Learning
Julian Lee – Analytics 200 Level – Intermediate 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?…
Why MDX cubes aren’t dead yet
Philip Seamark – BI 200 Level – Intermediate Lets have a look at the pros and cons of the two SSAS offerings and see why Multi-Dimensional cubes still have a place
Data Integration – preparing for the data challenges of tomorrow
Robert Blaas – BI 200 Level – Intermediate “With the ever increasing demand of data and information from the business, data professionals are increasingly feeling the pressure to deliver. This often results…
Impact of weather on English Premier League matches – Power BI analysis
Ásgeir Gunnarsson – Power BI 200 Level – Intermediate “Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening…
Microsoft IoT Central – Enterprise IOT as-a-Service
Samuel Denton-Giles Analytics – 200 Level – Intermediate 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…
Scalable Data Science with SparkR on HDInsight
Lace Lofranco – Analytics 200 Level – Intermediate R, a powerful statistical programming language, is unfortunately single threaded and therefore, natively limited to a single node. What happens when data scientists…
An introduction to the magical world of BIML!
Jonathan Stewart – BI 100 Level – Basic Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over…
Big Data Ingestion and Analytics with Microsoft Azure
Regan Murphy – Analytics 200 Level – Intermediate Azure is built to handle big data workloads. From ingesting millions of events per second, to visualizing those events in a dashboard in real…
Genesis Energy Implementation: Technical reference and Design patterns for enterprise BI and reporting supporting data science teams
Myles Matheson – BI 300 Level – Advanced “In this session we walk through the recently announce the technical reference implementation for BI and reporting solution to augment your data science and…
Power BI Embedded; Developers Guide
Sergei Gundorov – Power BI 300 Level – Advanced Power BI is not just a self-service tool for business analysts. Power BI has many features that helps developers to build their reporting…
Introducing Power BI Premium
Siva Harinath – Power BI 200 Level – Intermediate Extend your Power BI solution to everyone on your team with Power BI Premium! Learn how our latest offering can bring you dedicated…
2,4,8 & 16 – Journey of upgrading your data platform with SQL Server Part 2
Satya Jayanty – SQL Server Admin 300 Level – Advanced “2,4,8 & 16 – these aren’t just numbers to count or calculate. These are years that how SQL Server evolved as number…
What SQL Server DBAs Need To Know About Distributed Availability Groups
Edwin Sarmiento – SQL Server Admin 300 Level – Advanced With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate…