| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Jones | Professional Development | Branding Yourself for a Dream Job |
| 09:00:00 | Martin Cairney | Enterprise Database Administration Deployment | Smart Alerts in SQL DB using Automation and Logic Apps |
| 09:00:00 | David Alzamendi | BI Platform Architecture, Development Administration | Your Modern Data Warehouse Journey with Azure |
| 10:20:00 | Greg Low | Professional Development | Technologies to Watch: A Gaze into Greg's Crystal Ball |
| 10:20:00 | Gilbert Quevauvilliers | Analytics and Visualization | Power BI Infographic related on the Power BI Eco System |
| 10:20:00 | Martin Catherall | Cloud Application Development Deployment | Looking at the Cosmos(DB) |
| 11:30:00 | Manohar Punna | Strategy and Architecture | Bridging the gap between SSRS and Power BI |
| 11:30:00 | Kevin Kline | Enterprise Database Administration Deployment | Performance Baselining and Alerting |
| 11:30:00 | Victor Isakov | Enterprise Database Administration Deployment | Understanding Big Data Clusters |
| 13:30:00 | Rob Volk | Enterprise Database Administration Deployment | Revenge: The SQL! |
| 13:30:00 | Vikas Rajput | BI Platform Architecture, Development Administration | (Humble) Azure Cloud Shell CLI : Demo |
| 13:30:00 | Patrick Flynn | Enterprise Database Administration Deployment | Introduction to SQL Server Managed Instances |
| 14:50:00 | Steve Jones | Application Database Development | Always Encrypted in SQL Server |
| 14:50:00 | Kevin Kline | Application Database Development | 5 Critical Considerations When Moving to the Cloud |
| 14:50:00 | Anupama Natarajan | Analytics and Visualization | Enterprise Big Data Analytics using Azure Data Lake Storage Gen2 |
| 16:00:00 | Pio Balistoy | Enterprise Database Administration Deployment | SQL Server Deployment Options and When to Use Them (Full Instance vs Managed Instance vs PAAS) |
| 16:00:00 | Craig Bryden | BI Platform Architecture, Development Administration | Modern Enterprise BI in Azure |
| 16:00:00 | Hamish Watson | Application Database Development | Test Driven Development in SQL Server – how to deploy code safer |
Event Date: 01-06-2019 - Session time: 09:00:00 - Track: Professional Development
Event Date: 01-06-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Fortunately there's options available to get over this hurdle such as Azure Automation which can be used as a scheduling engine to run PowerShell or Python scripts to perform your tasks. However, Azure Automation Runbooks can also be triggered from Azure SQL DB alerts.
This session will introduce Azure Automation, from a basic manually executed Runbook to an alert-driven responsive utility that can save you considerable effort.
We'll then take our Alert responses a step further and use them to trigger an Azure Logic App workflow. Azure Logic Apps provide a robust workspace with built-in scalability and retry logic for your workflow along with many connectors which can expand the response to your alert.
Imagine capturing an Alert, performing remedial action, logging the issue response in your ticketing system and switching on the kettle for a cuppa while Azure does all the work.
Event Date: 01-06-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Azure offers an endless list of services that will be a good fit for your data warehouse solution. This session covers the main services and classifies them into the various layers of a data warehouse architecture.
I am also going to show you how easy it is to start developing and delivering within the Azure environment and share some tips that can help you start this journey. Azure Data Warehouse, Databricks, Data Lake and Data Factory are some of the services that will be part of this session.
Event Date: 01-06-2019 - Session time: 10:20:00 - Track: Professional Development
Event Date: 01-06-2019 - Session time: 10:20:00 - Track: Analytics and Visualization
Have you ever wondered what are all the parts that make up the Power BI Eco System and their features?
In this session I will cover the area's which make up the Power BI Eco system. This will include Power BI Desktop, Power BI Service (Free, Pro Premium), Power BI Gateway, Power BI Report Server Power BI Mobile App.
The goal of this session will be to give you a better understanding of all the working parts. And once you have a better understanding it will allow you to have the knowledge to know what to do where.
It will be an insightful journey into how much is actually going on within the world of Power BI in an easy to understand and digest manner.
The most popular blog posts are ones where it is easier concepts and details on how Power BI works.
Event Date: 01-06-2019 - Session time: 10:20:00 - Track: Cloud Application Development Deployment
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: 01-06-2019 - Session time: 11:30:00 - Track: Strategy and Architecture
Event Date: 01-06-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
This session describes techniques and procedures to monitor important performance metrics you can use to define as a baseline for “normal” performance. From there, we will show you how to use these baseline metrics to identify and alert on abnormal circumstances. The session includes detailed demos of how to use the native Microsoft tools, plus open-source tools, to run baseline and b
Event Date: 01-06-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
In this session we will explore the technology and business/use cases for using SQL Server Big Data Clusters within your organisation. Welcome to the future of SQL Server.
Event Date: 01-06-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Hint: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Event Date: 01-06-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-06-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
In this session we will explore:
What exactly are Azure Managed Instances The differences between Azure SQL Database, Managed Instances, and SQL Server on an Azure VM What's good and what could be improved.
We'll investigate:
We will also discuss some of the future directions, in particular the new Hyperscale service tier
Event Date: 01-06-2019 - Session time: 14:50:00 - Track: Application Database Development
Event Date: 01-06-2019 - Session time: 14:50:00 - Track: Application Database Development
The session takes you on a dive deep into the most critical considerations for moving your data and databases into the cloud, whether you use Microsoft Azure, Amazon, or another cloud provider. We will cover: • The importance of cleansing your data before a major migration • Fully documenting your data sources and metadata • Choosing from many different tools and techniques to move the actual data • How to test data for fidelity • Forecasting how much migration will cost • How to maintain parallel systems during transitional phases You also see demos and overviews of native features within SQL Server that enable you to move data, as well as show powerful tools from the SentryOne product set that can make
Event Date: 01-06-2019 - Session time: 14:50:00 - Track: Analytics and Visualization
In this session you will learn • How to ingest structured and unstructured data into Azure Data Lake Storage Gen2? • How to access Azure Data Lake Storage Gen2 data with Azure Data Bricks using Spark? • How to secure data in Azure Data Lake Storage Gen2? At the end of the session you will learn how to implement end to end Analytics for a modern Data Warehouse using Azure Data Lake Storage Gen2.
Event Date: 01-06-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 01-06-2019 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 01-06-2019 - Session time: 16:00: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.