| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | William Durkin | Data Platform Administration, Performance Tuning Optimisation | Automation for the DBA: Embrace your inner sloth |
| 10:00:00 | Ben Weissman | Strategy, Architecture, Application Database Development | Introducing SQL Server 2019 Big Data Clusters |
| 10:00:00 | Yana Berkovich | Data Platform Administration, Performance Tuning Optimisation | How to use DAX SQL in PowerBI? |
| 10:00:00 | Martin Catherall | Strategy, Architecture, Application Database Development | Data Privacy, Security, Ethics and Compliance in a Data-Driven World |
| 10:00:00 | Ginger Grant | AI, Data Science, Machine Learning IoT | Revealing the many Azure ML development and release processes |
| 10:00:00 | Warwick Rudd | Data Platform Administration, Performance Tuning Optimisation | Azure Data Studio - The New Frontier |
| 11:15:00 | Raju RH | AI, Data Science, Machine Learning IoT | Azure Cognitive Services using containers |
| 11:15:00 | Uwe Ricken | Data Platform Administration, Performance Tuning Optimisation | Analyze and solve common wait stats scenarios |
| 11:15:00 | Shane Welgama | Data Platform Administration, Performance Tuning Optimisation | Indexes: Under the Hood |
| 11:15:00 | Indira Bandari | AI, Data Science, Machine Learning IoT | Empower your Business Apps with Artificial Intelligence (Azure Cognitive Services) |
| 11:15:00 | Manohar Punna | Strategy, Architecture, Application Database Development | PowerApps and Flow Best Practices – Working with Data |
| 11:15:00 | Akanksha Malik | Business Intelligence, Analytics Visualization | From AI to BI, how to do it all in Azure Synapse Analytics |
| 13:00:00 | Sandy Winarko | Business Intelligence, Analytics Visualization | Back to the Future: Accelerating the Cloud Migration of Legacy SSIS with Azure Data Factory |
| 13:00:00 | Pio Balistoy | Data Platform Administration, Performance Tuning Optimisation | Azure SQL Database Serveless Hyperscale |
| 13:00:00 | Hamish Watson | DevOps, PowerShell, Containers, Infrastructure, Security Deployment | How to Deploy SQL Server Containers on Kubernetes in Azure |
| 13:00:00 | Ken Puls | Business Intelligence, Analytics Visualization | Introduction to Dimensional Modeling for the Excel/Power BI Pro |
| 14:15:00 | Phillip Seamark | Business Intelligence, Analytics Visualization | Troubleshooting DAX |
| 14:15:00 | Mohammad Asif Waquar | Strategy, Architecture, Application Database Development | Manage data to the ledger using Azure Blockchain as Service |
| 14:15:00 | Tejaswi Datla | Strategy, Architecture, Application Database Development | Survival Techniques for Lone DBA |
| 14:15:00 | Abhishek Narain | Strategy, Architecture, Application Database Development | ETL best practices on Azure using Data Factory |
| 14:15:00 | Asanka Padmakumara | Business Intelligence, Analytics Visualization | Composites models and Aggregations in Power BI. What, When and How? |
| 14:15:00 | Craig Bryden | Business Intelligence, Analytics Visualization | Modern Enterprise BI in Azure |
| 15:30:00 | Will Velida | Strategy, Architecture, Application Database Development | Developing Cosmos DB for the Enterprise |
| 15:30:00 | Ondrej Aubrecht | AI, Data Science, Machine Learning IoT | Can you trust the intelligence of Application tracking systems with your CV? |
| 15:30:00 | Mian Zahid Yaqub | Strategy, Architecture, Application Database Development | Security considerations for Azure SQL |
| 15:30:00 | Patrick Flynn | Data Platform Administration, Performance Tuning Optimisation | Get Comfortable with Query tuning and Execution Plans |
| 15:30:00 | Emily Dinsdale | Business Intelligence, Analytics Visualization | Visualising Complex Customer Journeys |
Event Date: 22-02-2020 - Session time: 10:00:00 - Track: Data Platform Administration, Performance Tuning Optimisation
In this session we will learn to embrace the power of automation to allow us to sit back and relax..... or rather focus on the real work of designing better, faster systems instead of fighting for short time slots when we can do actual work. Along the way we will see that we can benefit from the wide world of automation expertise already available to us and avoid re-inventing the wheel, again!
Event Date: 22-02-2020 - Session time: 10:00:00 - Track: Strategy, Architecture, Application Database Development
This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS, further scale out capabilities and Spark!
In this session, you'll get an overview of the architecture as well as the capabilities of this amazing new featureset!
Event Date: 22-02-2020 - Session time: 10:00:00 - Track: Data Platform Administration, Performance Tuning Optimisation
PowerBI world. Detailed explanation for what goes where, how to connect, what is important to consider and which options are there to choose from when creating your PowerBI solutions. We will focus on the desktop and server abilities within the Pro license. DAX and SQL examples will be discussed and the connection to AZUE SQL DW.
Event Date: 22-02-2020 - Session time: 10:00:00 - Track: Strategy, Architecture, Application Database Development
But what are the issues that individual data professionals should be aware of to avoid reputational damage to their companies and themselves? And what are the tools that can help them in their endeavors?
This session will take a close look at some of these challenges and the tools that are available to help mitigate these issues and risks.
Event Date: 22-02-2020 - Session time: 10:00:00 - Track: AI, Data Science, Machine Learning IoT
AML Studio, Workspace and Pipelines are different products which you can use to create or deploy a solution and they all start with AML. Understanding the differences between these products provides the information needed to be able to architect the appropriate solution in your environment. These session demos show how to create an end-to-end AML workflow to prepare data, create ML models, deploy models, and use data contained within SQL Server by integrating a number of tools including Databricks, Python, and Jupyter notebooks. Learn why you want to use AML Workspace for ML development collaboration, scaling, and management.
Event Date: 22-02-2020 - Session time: 10:00:00 - Track: Data Platform Administration, Performance Tuning Optimisation
In this demo heavy, introductory session we will introduce you to ADS, discuss its origins, and explain why this tool is not just for SQL Server. We will even show you some useful tips and tricks to make your life easier as a data professional!
Event Date: 22-02-2020 - Session time: 11:15:00 - Track: AI, Data Science, Machine Learning IoT
However, there might be cases in which our customers need a non-cloud AI solution (because of limited Internet access or data compliance).Container support in Azure Cognitive Services allows developers to use the same rich APIs that are available in Azure, and enables flexibility in where to deploy and host the services that come with Docker containers. Using containers, we can still deliver ML-driven solutions while keeping the data in-house.
In this talk, we’ll explore what it takes to configure and use containers support in Azure Cognitive Services. Demos will be
Event Date: 22-02-2020 - Session time: 11:15:00 - Track: Data Platform Administration, Performance Tuning Optimisation
Event Date: 22-02-2020 - Session time: 11:15:00 - Track: Data Platform Administration, Performance Tuning Optimisation
Event Date: 22-02-2020 - Session time: 11:15:00 - Track: AI, Data Science, Machine Learning IoT
Make your Business Apps more intelligent by using the APIs provided by Microsoft Cognitive Services.
In this session I will go through the following:
What are Microsoft Cognitive Services ? How to use Cognitive Services APIs ?
Event Date: 22-02-2020 - Session time: 11:15:00 - Track: Strategy, Architecture, Application Database Development
Key Learning: The attendees will learn design best practices in PowerApps and Flow while working with data layer. Demos:
Event Date: 22-02-2020 - Session time: 11:15:00 - Track: Business Intelligence, Analytics Visualization
Join me in a session to walk through what an end to end solution might look like for you in this brand new product. We will go through how Synapse enables you to prep the data, train models and generate reports without having to leave the workspace. You will leave with a better understanding of the product, it's capabilities and guiding principles on using it.
Event Date: 22-02-2020 - Session time: 13:00:00 - Track: Business Intelligence, Analytics Visualization
Event Date: 22-02-2020 - Session time: 13:00:00 - Track: Data Platform Administration, Performance Tuning Optimisation
Event Date: 22-02-2020 - Session time: 13:00:00 - Track: DevOps, PowerShell, Containers, Infrastructure, Security Deployment
This session will demonstrate how containers are a game changer for deploying and managing SQL Server. It will also showcase how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server running in containers.
Demonstrations will show how easy it is to create containers, deploy SQL Server in them, and how to automate and manage your SQL Server containers using Kubernetes on the Azure platform.
This session will show you the exciting future of SQL Server and you will walk away with knowledge of practical scenarios where SQL Server running in containers on Kubernetes may be the right deployment model for you.
Event Date: 22-02-2020 - Session time: 13:00:00 - Track: Business Intelligence, Analytics Visualization
In this session we will look at understanding the benefits of dimensional modeling. We will define and review key terms and best practices, and show you how to use Power Query to reshape, split and combine tables into their proper tabular formats for a model.
Event Date: 22-02-2020 - Session time: 14:15:00 - Track: Business Intelligence, Analytics Visualization
Event Date: 22-02-2020 - Session time: 14:15:00 - Track: Strategy, Architecture, Application Database Development
Event Date: 22-02-2020 - Session time: 14:15:00 - Track: Strategy, Architecture, Application Database Development
Event Date: 22-02-2020 - Session time: 14:15:00 - Track: Strategy, Architecture, Application Database Development
In this session, we will talk about design patterns for building scalable data pipelines for Big Data workloads! We will not cover ADF basics in this talk so having background knowledge about ADF would be recommended.
Event Date: 22-02-2020 - Session time: 14:15:00 - Track: Business Intelligence, Analytics Visualization
Event Date: 22-02-2020 - Session time: 14:15:00 - Track: Business Intelligence, Analytics Visualization
Event Date: 22-02-2020 - Session time: 15:30:00 - Track: Strategy, Architecture, Application Database Development
In this session, I'll cover important topics that you'll want to consider when developing and administrating Cosmos DB for Enterprise use, including security considerations, partitioning, provisioning throughput for your databases and collections, distributing your data and much more.
By the end of this session, you should be able to take these learnings and apply them when developing Cosmos DB applications for your business.
Event Date: 22-02-2020 - Session time: 15:30:00 - Track: AI, Data Science, Machine Learning IoT
This session will answer some of the unspoken questions: - Can you trust ATS with your CV ? - Can ATS analyse your Resume correctly (with Real examples) ? - How ATS works?
Come along to this session and find out more about REAL DATA analysis and scanning mechanism by multiple ATS used in the NZ job market and to find out if you can trust AI with your own CV.
Event Date: 22-02-2020 - Session time: 15:30:00 - Track: Strategy, Architecture, Application Database Development
• Defense in Depth Approch for SQL • Protect Your SQL Identities • Protect your Azure SQL Infrastructure • Encryption Options • Application Security
Event Date: 22-02-2020 - Session time: 15:30:00 - Track: Data Platform Administration, Performance Tuning Optimisation
Central to ability to tune queries is an ability to use information provided from Execution plans, DMVs, Query Store and Extended Events.
In this demo based session we will look into:
Attendees will leave with an understanding of possibilities of turning queries and a roadmap for further learning.
This session will assume a basic knowledge of T-SQL and execution plans.
Event Date: 22-02-2020 - Session time: 15:30:00 - Track: Business Intelligence, Analytics Visualization
This presentation uses python libraries and Sankey diagrams to visualise and gain insight from complex customer journies.