|Start Time (24h)||Speaker||Track||Title|
|09:00:00||Ginger Grant||Advanced Analysis Techniques||Machine Learning with SQL Server|
|09:00:00||Amit R S Bansal||Enterprise Database Administration Deployment||Practical SQL Server Performance Tuning|
|09:40:00||Gilbert Quevauvilliers||BI Information Delivery||Intro into Power BI|
|09:40:00||Martin Catherall||Strategy and Architecture||Data Privacy and the Data Professional.|
|09:40:00||Greg Low||Application Database Development||Tips and Tricks for Using SQL Server Management Studio Effectively|
|11:00:00||Manohar Punna||Advanced Analysis Techniques||Real-Time Analytics with Power BI|
|11:00:00||Henry Rooney||Strategy and Architecture||SQL Server Managed Instance, the PaaS Instance Offering|
|11:00:00||Michael van Halderen||Enterprise Database Administration Deployment||Configuring AlwaysOn Availability Groups exclusively in Azure, using IaaS.|
|13:30:00||Phillip Seamark||BI Platform Architecture, Development Administration||Advanced DAX for the SQL Professional|
|13:30:00||Anupama Natarajan||Cloud Application Development Deployment||Modern Data Warehouse using Lambda Architecture and Azure|
|13:30:00||Amit R S Bansal||Enterprise Database Administration Deployment||Troubleshooting SQL Server Memory Issues|
|14:50:00||Martin Cairney||Cloud Application Development Deployment||Hybrid Distributed Architecture with Azure Data Sync 2.0|
|14:50:00||Gogula Aryalingam||BI Platform Architecture, Development Administration||BI is a Journey, Not a Destination|
|14:50:00||Hamish Watson||Application Database Development||Test Driven Development in SQL Server – how to deploy code safer|
|14:50:00||Ginger Grant||Advanced Analysis Techniques||Implementing Python in SQL Server 2017|
|16:00:00||Patrick Flynn||Enterprise Database Administration Deployment||DBATools! The reason to finally start learning and using Powershell|
|16:00:00||Benjamin Nevarez||Application Database Development||Dive into the Query Optimizer - Undocumented Insight|
|16:00:00||Craig Bryden||BI Information Delivery||SSRS and Power BI Report Server - What's New|
Event Date: 02-06-2018 - Session time: 09:00:00 - Track: Advanced Analysis Techniques
Session Goals • Understand the Machine Learning development process including data analytics and algorithm selection • Learn why to use either R or Python given the task being performed • Know how to implement a machine learning solution as part of database solution in SQL Server .
Event Date: 02-06-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting. Basic to Intermediate level, covering important aspects.
Topics Include: Module 1: CPU Troubleshooting (Scheduling), IO Troubleshooting, Memory Trou
Event Date: 02-06-2018 - Session time: 09:40:00 - Track: BI Information Delivery
It will an interactive demo based session, where the goal will be for the user to walk away with a better understanding of what Power BI is capable of
Event Date: 02-06-2018 - Session time: 09:40: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: 02-06-2018 - Session time: 09:40:00 - Track: Application Database Development
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Advanced Analysis Techniques
In this session
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Strategy and Architecture
Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-06-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 02-06-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
In this session you will learn about
Event Date: 02-06-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-06-2018 - Session time: 14:50:00 - Track: Cloud Application Development Deployment
This session will show how one organisation has used Azure Data Sync to allow for centralised management of point-of-sales terminals across multiple retail groups. The session will discuss the SaaS based component built on Azure SQL Database to segregate different retail groups into dedicated databases. From this design the retail group's dedicated management database can then use Data Sync to gather sales and stock metrics from each terminal and push down price changes to selected groups of stores.
Event Date: 02-06-2018 - Session time: 14:50:00 - Track: BI Platform Architecture, Development Administration
This session will focus on how you could develop a business intelligence solution by taking the organization on an evolving journey, using the various Microsoft tools and technologies at different stages.
Event Date: 02-06-2018 - Session time: 14:50: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: 02-06-2018 - Session time: 14:50:00 - Track: Advanced Analysis Techniques
Event Date: 02-06-2018 - Session time: 16:00: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: 02-06-2018 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 02-06-2018 - Session time: 16:00:00 - Track: BI Information Delivery