| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:40:00 | Martin Catherall | Cloud Application Development Deployment | Diving into data - Swimming in the Lake. A look at Data Lake. |
| 09:40:00 | Manohar Punna | Strategy and Architecture | Bridging the gap between SSRS and Power BI |
| 09:40:00 | Hamish Watson | Application Database Development | Test Driven Development in SQL Server – how to deploy code safer |
| 09:40:00 | Warwick Rudd | Application Database Development | Azure Data Studio – The New Frontier |
| 09:40:00 | David Alzamendi | Advanced Analysis Techniques | Starting with Azure Cognitive Services |
| 10:50:00 | Phillip Seamark | BI Platform Architecture, Development Administration | Learning DAX? Five things to get you started fast |
| 10:50:00 | Geoff Black | BI Platform Architecture, Development Administration | Introduction to Azure Analysis Services |
| 10:50:00 | Leila Etaati | Advanced Analysis Techniques | AI Builder: AI in Power Apps and Microsoft Flow |
| 10:50:00 | Robert Blaas | BI Platform Architecture, Development Administration | A Generic ETL Framework |
| 10:50:00 | Heidi Hasting | Advanced Analysis Techniques | Things I've learned from working with Data Scientists |
| 10:50:00 | Tariq Younas | Lightning Talk (15 and 30 minutes Talk) | Lightning Talks: PowerShell Azure SQLDB, and Azure Data Bricks |
| 12:40:00 | Leo Miller | Enterprise Database Administration Deployment | Read Committed Snapshot Isolation - The Real Implications |
| 12:40:00 | Patrick Flynn | Application Database Development | GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects |
| 12:40:00 | Will Velida | Cloud Application Development Deployment | Developing Cosmos DB for the Enterprise |
| 12:40:00 | Tariq Younas | Lightning Talk (15 and 30 minutes Talk) | 4 Reasons to love Azure Databricks (₳ G₳MË CH₳NGËR) |
| 12:40:00 | Daniel Marsh-Patrick | Analytics and Visualization | Bespoke Visual Layouts with Charticulator |
| 12:40:00 | Chimène Bonhomme | Advanced Analysis Techniques | MLOps - a DevOps ext for building enterprise machine learning pipelines |
| 13:50:00 | Rob Douglas | Enterprise Database Administration Deployment | Demystifying Encryption |
| 13:50:00 | Adrian Sullivan | Other | Building your own million dollar SQL Practice |
| 13:50:00 | Indira Bandari | Analytics and Visualization | Top 10 tips every Power BI developer should know |
| 13:50:00 | Anupama Natarajan | Advanced Analysis Techniques | Build your first notebook using Azure Notebooks |
| 13:50:00 | Owen Auger | Analytics and Visualization | Essential financial calculations in Power BI |
| 15:00:00 | Bernard Spence | Application Database Development | Never get lost again with SQL Server spatial technology |
| 15:00:00 | Martin Cairney | Enterprise Database Administration Deployment | SQL Server Upgrades and Migrations - The Right Way |
| 15:00:00 | Edwin M Sarmiento | Enterprise Database Administration Deployment | The Transaction Log and How It Affects HA/DR |
| 15:00:00 | Reza Rad | BI Information Delivery | Power BI Design Patterns |
| 15:00:00 | Dave Dustin | Enterprise Database Administration Deployment | Beyond Devops - Introducing Data Reliability Engineering |
Event Date: 10-08-2019 - Session time: 09:40:00 - Track: Cloud Application Development Deployment
Azure data lake provides a way for a whole range of different data to be stored, analysed and manipulated – all form a single place – so that developers, data scientists and data analysists can access it. Forming part of what is often termed ‘a modern data warehouse’ this technology is something that is becoming more common. In this session we’ll take a look at these two technologies and how they might be useful – either now or in the future.
Event Date: 10-08-2019 - Session time: 09:40:00 - Track: Strategy and Architecture
Event Date: 10-08-2019 - Session time: 09:40:00 - Track: Application Database Development
It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer. 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: 10-08-2019 - Session time: 09:40:00 - Track: Application 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: 10-08-2019 - Session time: 09:40:00 - Track: Advanced Analysis Techniques
This session is for you and will provide the answers to each of these questions. Using Azure Cognitive Services, you will learn how to empower your business with AIaaS (Artificial Intelligence as a Service) models that are ready for consumption. I will also include some demos using some of these services.
Event Date: 10-08-2019 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-08-2019 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration
Event Date: 10-08-2019 - Session time: 10:50:00 - Track: Advanced Analysis Techniques
Event Date: 10-08-2019 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration
There are many tasks that need to be performed, ranging from data profiling, data quality assessments, master data management, testing, to the standard ETL processes. We often wind up reinventing the wheel, especially because most of these projects are one-off throw aways. These make our lives that much harder as we are often pressed for time by the business to get on with the job. In this session, I would like to show you how a generic ETL framework can help save us time by leveraging off some standard processes that can easily be developed and reutilised. I will show you how with a few simple SSIS tasks and lines of code we can create an efficient ETL process that we can keep using again and again. Because it's extendable, we can easily add additional components for DQS, MDM and reconciliation testing.
Event Date: 10-08-2019 - Session time: 10:50:00 - Track: Advanced Analysis Techniques
They work their magic and create a solution in a Jupyter notebook which they run through and execute on their machine. My first thought is, wow how cool, followed closely by what's a notebook? And how do we operationalize this and have it automated to run on a server and not needing a human to run. In this session, I'll take you through my journey from the notebook to running on a server via ML services in DB and all the parts in between.
Event Date: 10-08-2019 - Session time: 10:50:00 - Track: Lightning Talk (15 and 30 minutes Talk)
Title: Use PowerShell to deploy and configure Azure SQL Database (PaaS) with good resilience to outages and with integrated Azure SQL Analytics monitoring solution. Duration: 30 Minutes Speaker: Zoran Barac Abstract: Use one single PowerShell script to deploy cloud service with Azure SQL Database with good resilience to outages (GEO Replication, Fail-over Group) and to enable diagnostics for Azure SQL database and configure Azure SQL Analytics monitoring solution for monitoring performance of Azure SQL Databases.
4 Reasons to love Azure Databricks (₳ G₳MË CH₳NGËR) Speaker: Tariq Younas Duration: 15 minutes Accelerate big data analytics with Azure Databricks. Native integration with (Azure AD) and other Azure services enables you to build your modern data warehouse and machine learning and real-time analytics solutions. This talk will show the importance and justification with 4 reasons for the new offering [Azure Databricks] which i
Event Date: 10-08-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment
This session demonstrates the impact of RCSI on Transaction Control, TempDB and database performance. It demonstrates what happens under certain error conditions and how to identify and resolve problems arising from RCSI related issues.
This is for the DBA who wants to gain an extra level of understanding and the tools to identify and resolve RCSI related issues. Not for the faint of heart.
Event Date: 10-08-2019 - Session time: 12:40:00 - Track: Application Database Development
With the move into Open Source and community involvement even Microsoft has embraced the use of GitHub!
In this session we will investigate the setup and use of GitHub and Git for source control. Using the highly popular DBATools open source project we will also investigate getting involved in an Open Source project and the process of Pull and Push requests!
Based around personal experience of learning not to hate Source control, this session assume no experience with Git or Github
Event Date: 10-08-2019 - Session time: 12:40:00 - Track: Cloud Application Development Deployment
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: 10-08-2019 - Session time: 12:40:00 - Track: Lightning Talk (15 and 30 minutes Talk)
This talk will show the importance and justification with 4 reasons for the new offering [Azure Databricks] which is, in fact, a game changer in the industry.
Event Date: 10-08-2019 - Session time: 12:40:00 - Track: Analytics and Visualization
Charticulator comes from Microsoft Research and is used to create reusable, web-based bespoke data visualisations for use on the web. The icing on the cake is that you can use these templates to generate Power BI custom visuals as well!
In this session, we'll go through the concepts of the tool and build on these to create our own chart.
Event Date: 10-08-2019 - Session time: 12:40:00 - Track: Advanced Analysis Techniques
In this session, we will cover how MLOps is different to DevOps, MLOps workflow and best practices, and a demo of orchestrating pipelines in R and Python.
Event Date: 10-08-2019 - Session time: 13:50:00 - Track: Enterprise Database Administration Deployment
In this session we'll talk about the various ways you can implement Encryptian natively within SQL Server - with Backup Encryption, Transparent Data Encryption(TDE), AlwaysEncrypted, and connection encryption
Event Date: 10-08-2019 - Session time: 13:50:00 - Track: Other
Or, do you simply want to go from barely sustainable to profitable?
In this session I will touch on the 5 steps I considered when building and growing out a SQL Data Platform practice.
I'll also touch on how long it took me to achieve each of these, and how I measure success.
Event Date: 10-08-2019 - Session time: 13:50:00 - Track: Analytics and Visualization
Event Date: 10-08-2019 - Session time: 13:50:00 - Track: Advanced Analysis Techniques
With Azure Notebooks the information can also be presented to non-technical stakeholders in an easier way. In this session you will learn • What are Azure Notebooks? • How to create your first notebook in Azure Notebooks? • How to use code snippets and visualisations in a notebook? • Create a slideshow of your notebook • How to share your notebook with your team? By the end of the session you will get a good understanding about Azure Notebooks and how to use them for real world problems.
Event Date: 10-08-2019 - Session time: 13:50:00 - Track: Analytics and Visualization
Financial calculations in Power BI are useful for individuals and businesses who want to better understand their past and future financial performance, and quickly and easily visualize the results.
I will include practical examples and a take-away Power BI model covering:
Event Date: 10-08-2019 - Session time: 15:00:00 - Track: Application Database Development
Event Date: 10-08-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
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: 10-08-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 10-08-2019 - Session time: 15:00:00 - Track: BI Information Delivery
Event Date: 10-08-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
We build things. We create things. As engineers practicing devops, we are all in this together, and nothing is someone else’s problem. As engineers, we apply repeatable processes, established knowledge, and expert judgment to design, build, and operate production data stores and the data structures within. As database reliability engineers, we must take the operational principles and the depth of database expertise that we possess one step further. Guiding Principles of the DBRE