|Start Time (24h)||Speaker||Track||Title|
|10:00:00||Dave Dustin||Strategy and Architecture||Back to Basics – An overview of the internals of SQL Server|
|10:00:00||Gogula Aryalingam||BI Platform Architecture, Development Administration||Azure Data Lake Analytics: Leveraging the Modern Data Warehouse|
|10:00:00||Vanessa Larsen||Other||Deciphering the Black Box - Why productivity projects crash and burn|
|10:00:00||Leila Etaati||Analytics and Visualization||Create Custom Visual using JSON and R|
|11:15:00||Phillip Seamark||BI Platform Architecture, Development Administration||Advanced DAX for the SQL Professional|
|11:15:00||Ginger Grant||Advanced Analysis Techniques||Implementing Python in SQL Server 2017|
|11:15:00||Sudeep Ghatak||Other||Cloning the human brain - Cognitive Services|
|11:15:00||Amit R S Bansal||Enterprise Database Administration Deployment||Troubleshooting SQL Server Memory Issues|
|13:15:00||Craig Bryden||BI Information Delivery||SSRS and Power BI Report Server - What's New|
|13:15:00||Warwick Rudd||Application Database Development||SQLOpsStudio Vs SSMS - There can be only one|
|13:15:00||Reza Rad||Analytics and Visualization||Take Power BI Visualization to the Next Level|
|14:30:00||Patrick Flynn||Enterprise Database Administration Deployment||DBATools! The reason to finally start learning and using Powershell|
|14:30:00||Anupama Natarajan||Cloud Application Development Deployment||Modern Data Warehouse using Lambda Architecture and Azure|
|14:30:00||Simon Peck||BI Platform Architecture, Development Administration||Orchestration and data movement with Azure Data Factory v2|
|15:45:00||Manohar Punna||Advanced Analysis Techniques||Real-Time Analytics with Power BI|
|15:45:00||Martin Catherall||Strategy and Architecture||Data Privacy and the Data Professional.|
|15:45:00||Indira Bandari||BI Information Delivery||Google Forms meet Power BI via Reporting Services (SSRS)|
Event Date: 26-05-2018 - Session time: 10:00:00 - Track: Strategy and Architecture
This session drills down into how SQL Server and other relational database systems work behind the scenes. We’ll look at the interpreter, optimizer, estimator, storage, memory, locking, blocking, indexes, statistics and everything else that makes it all work.
Event Date: 26-05-2018 - Session time: 10:00: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: 26-05-2018 - Session time: 10:00:00 - Track: Other
In this session, we will share our stories from our time in the field experiencing the twists and turns that productivity projects take; how to have success in your internal project; and if you choose to bring in external parties, how to make the most of them.
Event Date: 26-05-2018 - Session time: 10:00:00 - Track: Analytics and Visualization
Event Date: 26-05-2018 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration
We will create data from thin air and show how you can shape your data model using DAX.
Event Date: 26-05-2018 - Session time: 11:15:00 - Track: Advanced Analysis Techniques
Event Date: 26-05-2018 - Session time: 11:15:00 - Track: Other
Event Date: 26-05-2018 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 26-05-2018 - Session time: 13:15:00 - Track: BI Information Delivery
Event Date: 26-05-2018 - Session time: 13:15: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: 26-05-2018 - Session time: 13:15:00 - Track: Analytics and Visualization
Event Date: 26-05-2018 - Session time: 14: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: 26-05-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
In this session you will learn about
Event Date: 26-05-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
For the SSIS developer, we’ll translate some ADF terminology to help get you started as well as demonstrate some real-life examples from our customer engagements. And of course, being automation experts with Biml, we’ll demonstrate how we can automate the creation of ADF v2 assets.
Event Date: 26-05-2018 - Session time: 15:45:00 - Track: Advanced Analysis Techniques
In this session
Event Date: 26-05-2018 - Session time: 15:45:00 - Track: Strategy and Architecture
But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.
Event Date: 26-05-2018 - Session time: 15:45:00 - Track: BI Information Delivery
In this session I will show you how to • Initiate customer feedback surveys using Google Forms. • Send the survey emails to the database contacts through data driven subscriptions of Reporting Services (SSRS) • And finally analyse the customer feedback using Power BI