| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Hamish Watson | Application Database Development | Test Driven Development in SQL Server – how to deploy code safer |
| 09:00:00 | David Alzamendi | BI Platform Architecture, Development Administration | Business Intelligence Solutions in Azure |
| 09:00:00 | Jim McLeod | BI Platform Architecture, Development Administration | Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud |
| 09:00:00 | Grant Paisley | BI Information Delivery | Data modelling fundamentals for Power BI and SSAS Tabular |
| 10:10:00 | Warwick Rudd | Application Database Development | SQLOpsStudio Vs SSMS - There can be only one |
| 10:10:00 | Reza Rad | BI Platform Architecture, Development Administration | M and Power Query Beyond Limits |
| 10:10:00 | Rolf Tesmer | Analytics and Visualization | Building Streaming Data Pipelines Using Azure Cloud Services |
| 10:10:00 | Matt Allington | BI Information Delivery | DAX as a Query Language |
| 11:30:00 | Gilbert Quevauvilliers | BI Information Delivery | Power BI Writeback with Power Apps |
| 11:30:00 | Martin Cairney | Application Database Development | The Why and How of Partitioned Tables |
| 11:30:00 | Leila Etaati | Advanced Analysis Techniques | End To End Data Science Solution: Azure ML Workbench |
| 11:30:00 | Martin Catherall | Strategy and Architecture | What is DevOps? - and why should I care? |
| 13:30:00 | Andreas Wolter | Enterprise Database Administration Deployment | Troubleshooting Always On Availability Groups Performance |
| 13:30:00 | Patrick Flynn | Enterprise Database Administration Deployment | DBATools! The reason to finally start learning and using Powershell |
| 13:30:00 | Manohar Punna | Advanced Analysis Techniques | Data Science for DBA - Get Started Now |
| 13:30:00 | Daniil Maslyuk | Analytics and Visualization | DAX best practices |
| 14:50:00 | Gogula Aryalingam | BI Platform Architecture, Development Administration | Azure Data Lake Analytics: Leveraging the Modern Data Warehouse |
| 14:50:00 | Iman Eftekhari | Strategy and Architecture | Power BI Adoption Framework |
| 14:50:00 | Victor Isakov | Application Database Development | Mastering Temporary Objects |
| 14:50:00 | Greg Low | Application Database Development | Tips and Tricks for Using SQL Server Management Studio Effectively |
Event Date: 07-07-2018 - Session time: 09:00:00 - Track: Application 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 safer.
Event Date: 07-07-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
I will go over the characteristics of the main services that can be implemented in a Business Intelligence solution in the cloud. The demo will include 5 of these services.
Event Date: 07-07-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 07-07-2018 - Session time: 09:00:00 - Track: BI Information Delivery
Event Date: 07-07-2018 - Session time: 10:10:00 - Track: Application Database Development
In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
Event Date: 07-07-2018 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 07-07-2018 - Session time: 10:10:00 - Track: Analytics and Visualization
Event Date: 07-07-2018 - Session time: 10:10:00 - Track: BI Information Delivery
In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model. Once connected, DAX studio can be used to write queries over the tabular data model to start to 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.
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: BI Information Delivery
In this session I will demonstrate how to integrate write back using Power Apps, within a Power BI report.
The session will be almost entirely demo based, in which I will demonstrate how to integrate the Power App with the Power BI report. And then show by updating a record, that the data is almost instantly updated within the Power BI report.
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Application Database Development
This session will demonstrate some of the common pitfalls with implementing partitioning: • how excessive data movement can kill performance • how poor maintenance can negate the performance gains We’ll then look at how to plan and implement partitioning appropriately and some of the corresponding benefits that can be realised from a well implemented and managed partition scheme: • how to automatically maintain a partition scheme • how to implement a sliding window for data loading and archiving • how to plan and implement partitioning to limit data movement Finally, we will consider the additional options open to us with partitioned tables from both the maintenance perspective, and the coding and tuning perspective.
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Strategy and Architecture
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 - and we'll see Visual Studio Team Services (VSTS) and the cloud in action. 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 kn
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.
With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.
In this session we will look how to download, install and begin using the power within both this module and Powershell.
No prior experience with Powershell required!
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
You will learn the basics of R programming language, Machine Learning, real-world analytics and visualisations that businesses need today. In this session you will get a head start about each component and the possibilities that can be achieved with them.
Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Analytics and Visualization
Event Date: 07-07-2018 - Session time: 14:50:00 - Track: BI Platform Architecture, Development Administration
Fear not, all you need to do is look to the heavens; with Azure Data Lake and Azure Data Lake Analytics, you could get started quite fast. After an introduction to Azure Data Lake, we will dive into how you could perform simple yet power analytics using methods that are familiar with Azure Data Lake Analytics.
Event Date: 07-07-2018 - Session time: 14:50:00 - Track: Strategy and Architecture
Many Business Users started using Power BI with minimum / no IT collaboration that started causing concerns especially within larger organisations regarding security, governance, change management, etc. With the risk of facing another spreadsheet hell in a different form, organisations have become increasingly aware of the need to put a governance and control process in place.
In this presentation Iman will use his extensive experience in implementing and rolling out Power BI for many organisations to share some tips from his adoption framework for mid to large size organisations.
Event Date: 07-07-2018 - Session time: 14:50:00 - Track: Application Database Development
Event Date: 07-07-2018 - Session time: 14:50:00 - Track: Application Database Development
Join Greg to see his favourite tips and tricks for working with SSMS.