| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:25:00 | Wyn Hopkins | Analytics and Big Data | Making the leap from Excel formulas to DAX |
| 09:25:00 | Martin Cairney | Application, DBA and Database Development | Smart Alerts for Azure SQL Database using Automation Logic Apps |
| 09:25:00 | Hamish Watson | Application, DBA and Database Development | How to Deploy SQL Server Containers on Kubernetes in Azure |
| 09:25:00 | Heidi Hasting | Application, DBA and Database Development | Bringing source control to BI world! |
| 11:00:00 | Martin Catherall | Application, DBA and Database Development | Looking at the Cosmos(DB) |
| 11:00:00 | Craig Bryden | BI Platform Architecture, Development Administration | Creating and Managing a Power BI Enterprise Deployment |
| 11:00:00 | Nirmal Thewarathanthri | Application, DBA and Database Development | Best Practices for Running SQL Server on Azure |
| 11:00:00 | Scott Holden | Application, DBA and Database Development | A touch of AI with Cognitive Services |
| 12:50:00 | Jason Aw | Application, DBA and Database Development | High Availability and Disaster Recovery for SQL Server in Azure IaaS |
| 12:50:00 | Patrick Flynn | Application, DBA and Database Development | Get Comfortable with Query tuning and Execution Plans |
| 12:50:00 | Warwick Rudd | Application, DBA and Database Development | Azure Data Studio – The New Frontier |
| 12:50:00 | Lee Moran | Analytics and Big Data | PBI ❤ AI |
| 13:55:00 | Craig Bryden | BI Platform Architecture, Development Administration | Paginated Reporting with Power BI |
| 13:55:00 | Martin Cairney | Application, DBA and Database Development | SQL Server Upgrades and Migrations - The Right Way |
| 13:55:00 | Deepak Maheshwari | Strategy, Governance and Professional Development | Governance in Azure |
| 13:55:00 | Hamish Watson | Application, DBA and Database Development | Test Driven Development in SQL Server – how to deploy code safer |
| 15:35:00 | Wyn Hopkins | Analytics and Big Data | Power BI, Excel and Teams. Unlocking the Value of your Enterprise Data |
| 15:35:00 | Scott Holden | Application, DBA and Database Development | Serverless and SQL, risk or reward? |
| 15:35:00 | Nicholas Schafer | Analytics and Big Data | Get your data flowing with Data Flows! and...umm...dataflows |
| 15:35:00 | Neil Hambly | Analytics and Big Data | Introduction to SQL Server 2019 Big Data Clusters |
Event Date: 07-09-2019 - Session time: 09:25:00 - Track: Analytics and Big Data
DAX formulas are written in isolation with the author having to "picture" the context of where that calculation will be used. This session compares and contrasts calculations in Excel formulas and DAX formulas to give you a better comprehension on how to tackle DAX. Tips, tricks and best practice ideas will set you up for more powerful Excel and Power BI reporting.
Event Date: 07-09-2019 - Session time: 09:25:00 - Track: Application, DBA and Database Development
Event Date: 07-09-2019 - Session time: 09:25:00 - Track: Application, DBA and Database Development
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: 07-09-2019 - Session time: 09:25:00 - Track: Application, DBA and Database Development
If you answered yes to any of these questions then this session is for you! We will go through
Let's bring order to your chaos!
Event Date: 07-09-2019 - Session time: 11:00:00 - Track: Application, DBA and Database Development
In this session we’ll take a look at this technology and learn how it might be useful – either now or in the future.
Event Date: 07-09-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
• The different data storage and connectivity modes. • Power BI Pro vs Power BI Premium. • Efficient use of workspaces and apps. • Security Considerations. • Content Governance. • How all of the above (and other) topics impact your implementation. Craig will bring his extensive real-world experience to this presentation, in which the audience is encouraged to participate in the discussion.
Event Date: 07-09-2019 - Session time: 11:00:00 - Track: Application, DBA and Database Development
Event Date: 07-09-2019 - Session time: 11:00:00 - Track: Application, DBA and Database Development
Event Date: 07-09-2019 - Session time: 12:50:00 - Track: Application, DBA and Database Development
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me?
HA and DR professional Jason Aw with 20 years of experience explains all this and more in
Event Date: 07-09-2019 - Session time: 12:50:00 - Track: Application, DBA and Database Development
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: 07-09-2019 - Session time: 12:50:00 - Track: Application, DBA and Database Development
In this session we will take you on a journey introducing you to Azure Data Studio so that you can understand the ins and outs and when you should consider using Azure Data Studio in place of SQL Server Management Studio. In this idemo heavy session we will look at how productive you can be with Azure Data studio and some of the features that are not available in SQL Server Management Studio.
Event Date: 07-09-2019 - Session time: 12:50:00 - Track: Analytics and Big Data
Come and join Lee Moran, organiser of the Perth Modern Excel and Power BI User Group, as he walks you through the many ways you can tap into this great capability and understand how Microsoft’s goal of “democratising AI” can really take the insights surfaced in your Power BI report to the next level.
In this demo-heavy session, Lee will cover everything from the Analytics pane on line charts through to some of the newly released capabilities around a simple mechanism to interface with published, enterprise-scale Azure ML models.
Event Date: 07-09-2019 - Session time: 13:55:00 - Track: BI Platform Architecture, Development Administration
In this session, Craig will discuss the various options available for implementing paginated reports in the cloud and/or on-premises using Power BI. We will explore this in depth from all angles so that you can come away understanding these options and implications.
Event Date: 07-09-2019 - Session time: 13:55:00 - Track: Application, DBA and Database Development
With so many critical databases running on these older versions, how do you ensure that you achieve a successful and safe transition to your new platform? Fortunately there are some fantastic tools and defined processes that can lead you through each stage.
There are tools to test different versions and infrastructures, processes to track query regressions and provide a way to remediate them.
This session will walk through the upgrade process from end-to-end and show what tools can help you at each step.
Event Date: 07-09-2019 - Session time: 13:55:00 - Track: Strategy, Governance and Professional Development
Event Date: 07-09-2019 - Session time: 13:55:00 - Track: Application, DBA and Database Development
TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.
In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery.
A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code
Event Date: 07-09-2019 - Session time: 15:35:00 - Track: Analytics and Big Data
To finish off we'll go from raw data to a voice generated Power BI mobile visual in under 10 minutes!
Event Date: 07-09-2019 - Session time: 15:35:00 - Track: Application, DBA and Database Development
Event Date: 07-09-2019 - Session time: 15:35:00 - Track: Analytics and Big Data
Event Date: 07-09-2019 - Session time: 15:35:00 - Track: Analytics and Big Data
We will be asking pertinent questions such as
“Why is Big Data Clusters needed… ” “What challenges will it solve... “ “How can this be integrated with my existing SQL Servers…” “What are its components...”