| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Callum Green | Business Intelligence Data Science | Embedding PowerApps into a Power BI Dashboard |
| 08:30:00 | Satya Jayanty | Azure Cloud Data Services | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 08:30:00 | Joanna Wolthuis | Database Administration Development | Be a dynamic SQL dynamo! |
| 08:30:00 | Kevan Riley | Database Administration Development | Tune the query, not the plan |
| 08:30:00 | Rob Sewell | Database Administration Development | dbachecks - The PowerShell Module to validate your SQL Estate |
| 09:45:00 | Jose Mendes | Business Intelligence Data Science | Chatbots for Dummies |
| 09:45:00 | Hugo Kornelis | Database Administration Development | Deep dive into Adaptive Query Processing |
| 09:45:00 | Alex Whittles | Business Intelligence Data Science | Cubes in the Cloud - Analysis Services in Azure |
| 09:45:00 | Martin Croft | Database Administration Development | The productive SQL Server Professional |
| 09:45:00 | Mark Allison | Database Development Continuous Integration | Harnessing Database Monitoring in a DevOps pipeline |
| 11:00:00 | Andrew Pruski | Database Administration Development | SQL Server Containers |
| 11:00:00 | Terry McCann | Business Intelligence Data Science | An Introduction to Machine Learning with Python |
| 11:00:00 | Sam Cogan | Azure Cloud Data Services | Azure Functions and Automation: The SQL Agent in the Cloud |
| 11:00:00 | Mark Pryce-Maher | Database Administration Development | Data Classification in SQL Server and Azure SQL Database |
| 11:00:00 | Neil Hambly | Azure Cloud Data Services | Lessons learned implementing real-world Data Analytic projects |
| 13:30:00 | Paul Andrew | Business Intelligence Data Science | Azure Data Factory v2 – SSIS Data Flows Custom Extensibility |
| 13:30:00 | Alex Yates | Database Administration Development | DevOps, Dev Data and the GDPR: 5 Solutions |
| 13:30:00 | Jen Stirrup | Business Intelligence Data Science | Blockchain Demystified for Business Intelligence Professionals |
| 13:30:00 | Mark Broadbent | Database Administration Development | Persistence is Futile - Implementing Delayed Durability in SQL Server |
| 13:30:00 | N. M. | Business Intelligence Data Science | SQL 2017 Graph Databases PowerBI Visualisations |
| 14:45:00 | Rudi Bruchez | Database Administration Development | What can you do with SQL Server on Linux? |
| 14:45:00 | Greg Moore | Development and PowerShell | Who's flying the plane? What IT can learn from plane crashes |
| 14:45:00 | Alexander Arvidsson | Database Development Continuous Integration | SQL Server hates you(?) |
| 14:45:00 | Bob Duffy | Business Intelligence Data Science | Planning and Deploying PowerBI Report Server – On Premise! |
| 16:00:00 | David Morrison | Development and PowerShell | PowerApps - An introduction |
| 16:00:00 | Rich Benner | Database Administration Development | Making your Emergency DBA Toolkit |
| 16:00:00 | Simon Whiteley | Business Intelligence Data Science | Modern Data Warehousing - The Lambda Approach to Azure BI |
| 16:00:00 | Steve Powell | Business Intelligence Data Science | Documenting the data models in your SSAS and PowerBI Solutions |
| 16:00:00 | Kamil Nowinski | Database Development Continuous Integration | Maintenance a database project and Continuous Delivery using Microsoft Data Tools in practical terms |
Event Date: 14-07-2018 - Session time: 08:30:00 - Track: Business Intelligence Data Science
What if we could use PowerApps and Power BI together? Can we embed a PowerApp into a Dashboard and give the end user the ability to write back data to a visual? Come along to my session to find out.
The 1-hour session includes other technologies such as Azure SQL Database, Common Data Service (CDS) and Flow. In particular, I will demonstrate how you integrate these technologies with PowerApps and Power BI. Whilst all levels of expertise are welcome, users require prior knowledge of Power BI Dashboards and PowerApps.
Event Date: 14-07-2018 - Session time: 08:30:00 - Track: Azure Cloud Data Services
Event Date: 14-07-2018 - Session time: 08:30:00 - Track: Database Administration Development
Event Date: 14-07-2018 - Session time: 08:30:00 - Track: Database Administration Development
Event Date: 14-07-2018 - Session time: 08:30:00 - Track: Database Administration Development
How long since your last backup? How long since your last DBCC Check? Are your Agent Operators Correct? Is AutoClose, AutoShrink, Auto Update Stats set up correctly? Is DAC Allowed? Are your file growth settings correct, what about the number of VLFs? Is your latency, TCP Port, PS remoting as you expect? Is Page Verify, Data Purity, Compression correctly set up?
and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it
Event Date: 14-07-2018 - Session time: 09:45:00 - Track: Business Intelligence Data Science
In this session, we will learn how to build, debug and deploy a chatbot using the Azure Bot Service. We will enrich it using the Microsoft Cognitive suite to achieve human like interactions.
Will it pass the Turing test, no, but we can extend the bot service using Machine Learning (LUIS), APIs (Web Apps) and Worflows (Logic Apps).
Event Date: 14-07-2018 - Session time: 09:45:00 - Track: Database Administration Development
SQL Server 2017 changes this! Three new features now allow execution plans to adapt to reality. Memory Grant Feedback increases or decreases assigned memory based on past experience. The Adaptive Join operator allows the optimizer to create two alternative plans, the best of which will be decided at execution time. And with Interleaved Execution, parts of the plan are even completely recompiled mid-execution, with much better cardinality estimates.
If you are more interested in how all this ACTUALLY works than in shiny marketing slides, come to this session. We will spend the full 60 minutes knee-deep in execution plan internals!
Event Date: 14-07-2018 - Session time: 09:45:00 - Track: Business Intelligence Data Science
Event Date: 14-07-2018 - Session time: 09:45:00 - Track: Database Administration Development
An enhanced set of development/DBA tools, to analysis your SQL Server, and find out the pain points, aid quicker easier development, oh and how to teach your colleagues they should never leave their machines unlocked. This is a filled 60 minutes of things you can use daily.
Event Date: 14-07-2018 - Session time: 09:45:00 - Track: Database Development Continuous Integration
Use data captured from Database Monitoring tool to validate performance testing
Use a Database Monitoring tool as an input to release gates, to only release when defined performance metrics have been met.
Use VSTS extensions to visualise performance test failures
This allows us to automatically fail releases based on poor performance as captured by a baseline in downstream environments, and surface that information in the release tool so that a release manager can understand why a release in the pipeline was marked as failed. This will typically be things like, high CPU, logical IO, missing indexes, or deadlocks.
Event Date: 14-07-2018 - Session time: 11:00:00 - Track: Database Administration Development
After this demo based session, attendees will be able to go back to their respective companies and be able to evaluate container technology to determine whether or not it will be of benefit.
Attendees will be taken through the following: - The definition of containers Virtual Machines vs Containers Container networking fundamentals Installing the docker engine Pulling SQL images from the docker repository Running SQL Server containers Creating custom container images Persisting data in SQL Server containers A real world implementation of containers
Event Date: 14-07-2018 - Session time: 11:00:00 - Track: Business Intelligence Data Science
Event Date: 14-07-2018 - Session time: 11:00:00 - Track: Azure Cloud Data Services
Event Date: 14-07-2018 - Session time: 11:00:00 - Track: Database Administration Development
I run through the need for data classification in general and why its important for GDPR. We will run though classifying your data and how to report on it.
Event Date: 14-07-2018 - Session time: 11:00:00 - Track: Azure Cloud Data Services
(AZURE SQL, Datawarehouse, Data Lake, Data Factory, PowerBI) and more is complex. Managing the teams that can deliver the complex architecture designs can quickly become a challenge, learn the key lessons from a real-world project that was delivered, avoiding problem areas that can derail such projects.
Event Date: 14-07-2018 - Session time: 13:30:00 - Track: Business Intelligence Data Science
Event Date: 14-07-2018 - Session time: 13:30:00 - Track: Database Administration Development
It helps them to write better code and to test it effectively. Self-service access to usable test-data aligns well with DevOps principles that encourage teams to adopt a shift-left mentality to testing.
Unfortunately, in the age of data breaches and the GDPR it’s simply illegal to give developers access to some types of sensitive production data.
So what do you do?
In this session I’ll talk about the GDPR, anonymisation, pseudonymisation and 5 techniques you can use to provide appropriate data that is as “production-like” as possible (within the legal and technical constraints). I’ll demo these techniques both in raw T-SQL and using some of the Microsoft and third party tools that are available to make the task easier.
After this session you’ll be equipped to discuss the problem with your colleagues in an informed manner and you’ll be able to suggest several solutions and their relative pros and cons.
Event Date: 14-07-2018 - Session time: 13:30:00 - Track: Business Intelligence Data Science
What is blockchain? What can it do for my organization? How can your organisation manage a blockchain implementation? How does it work in Azure? Join this session to learn about blockchain and see it in action. We will also discuss the use cases for blockchain, and whether it is here to stay.
Event Date: 14-07-2018 - Session time: 13:30:00 - Track: Database Administration Development
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things.
Attend this session and you will be assimilated!
Event Date: 14-07-2018 - Session time: 13:30:00 - Track: Business Intelligence Data Science
There will be a GitHub folder for your to download the session content also: https://github.com/neilmillingtonmicrosoft/SQL_Graph_with_PowerBI
You will need:
Event Date: 14-07-2018 - Session time: 14:45:00 - Track: Database Administration Development
Event Date: 14-07-2018 - Session time: 14:45:00 - Track: Development and PowerShell
Every company will eventually have a disaster. It's just a matter of size and scope. This talk is a general overview of how to respond to an incident and talks about the roles of management and IT.
This is not your typical discussion of disasters focusing on how to make a backup plan or enable high availability.
I'll touch upon what we can learn from plane crashes and how those lessons can be applied to the IT environment in general.
Event Date: 14-07-2018 - Session time: 14:45:00 - Track: Database Development Continuous Integration
This session will start with a walkthrough of some of the basic settings in SQL Server and how they affect you as a developer. It follows with key tips on what settings to change, why some code will wreak havoc on your performance and how isolation levels matter (and why NOLOCK can be an exceptionally bad idea!) The session is led by a 20-year DBA veteran who decided to try to help developers understand performance issues by seeing things from his perspective. If you want to explore how default settings kill your performance, investigate why harmless SQL might not be quite so harmless and gain insight into how isolation levels affect function and performance, then this session will provide you with the tools to think outside the box and incorporate database engine knowledge into your developer prowess!
Event Date: 14-07-2018 - Session time: 14:45:00 - Track: Business Intelligence Data Science
Topic covered are:
Event Date: 14-07-2018 - Session time: 16:00:00 - Track: Development and PowerShell
We'll look at how we get started and the kind of things we can do in the platform and how easy it is to connect to and work with the data sets available.
We'll look at some of the syntax in the code and how to solve various common problems
Event Date: 14-07-2018 - Session time: 16:00:00 - Track: Database Administration Development
What’s on fire? – These scripts will help you diagnose what’s happening right now Specs – What hardware are you dealing with here (you’ll need to know this to make the appropriate decisions)? Settings – are the most important settings correct for your workload? Bottlenecks – We’ll see if there are any areas of the system that are throttling us. By the end of this session you should have the knowledge of what you need to do in order to start on your own kit. This kit is designed to be your lifeline to fix servers quickly and get them working.
All code we’ll go through is either provided as part of this presentation or are open source/community.
Event Date: 14-07-2018 - Session time: 16:00:00 - Track: Business Intelligence Data Science
This session will take you through the pattern known as the Lambda architecture, a reference pattern for building data analytics systems that can handle any combination of data velocity, variety and volume. The session will outline the set of tools and integration points that can underpin the approach. Do you design real-time reporting systems? Or crunch petabytes of data? Perhaps you are adopting a cloud architecture and just want to handle anything the future throws at you? This session is for you.
We will follow the movement of data through batch and speed layers via Azure Data Lake Store Analytics and Streaming Analytics before considering the serving layer with Azure SQL DataWarehouse and downstream reporting tools.
Event Date: 14-07-2018 - Session time: 16:00:00 - Track: Business Intelligence Data Science
Event Date: 14-07-2018 - Session time: 16:00:00 - Track: Database Development Continuous Integration
All these topics I will explain on the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.