| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Uwe Ricken | Application Database Development | Daily indexing problems and its - possible - solution |
| 09:00:00 | Jeanne Combrinck | Application Database Development | Master Data Services From Start To Finish |
| 09:00:00 | Arohan Naidoo | BI Platform Architecture, Development Administration | Get your head start on IoT with Azure IoT Hub and stream Analytics to Power Bi |
| 09:00:00 | Michael Johnson | Analytics and Visualization | Getting started with PowerBI |
| 10:00:00 | Alex Yates | Application Database Development | DevOps 101 for Data People |
| 10:00:00 | Steve Simon | BI Information Delivery | SQL Server Reporting Services 2017 on Steroids!! |
| 10:00:00 | Andrew Collier | Analytics and Visualization | Wading into Stream Analytics |
| 10:00:00 | Gail Shaw | Application Database Development | An introduction to Azure SQLDatawarehouse |
| 10:00:00 | Niels Berglund | Cloud Application Development Deployment | Azure Machine Learning |
| 13:00:00 | Allan Pead | Cloud Application Development Deployment | Getting Started with Azure IoT Edge |
| 13:00:00 | Sean Cremer | Application Database Development | SQL Server Temporal Tables |
| 13:00:00 | Michael Johnson | BI Information Delivery | Power BI data preparation with Dataflows |
| 13:00:00 | Niels Berglund | Advanced Analysis Techniques | The Ins and Outs of sp_execute_external_script |
| 13:00:00 | Jodi Craig | Application Database Development | Deadlocks: What they are and how to resolve them |
| 14:00:00 | Alex Yates | Application Database Development | DevOps, Dev Data and Data Breaches: 5 Solutions |
| 14:00:00 | James McGillivray | BI Information Delivery | Working with complicated data models in DAX |
| 14:00:00 | Gail Shaw | Application Database Development | Graphs in SQL Server and Cosmos DB |
| 14:00:00 | Luis de Sousa | Analytics and Visualization | Machine Learning with R in Power BI |
| 14:00:00 | Warren Rocchi | Professional Development | Top tips on cracking a new database (and impressing your new employer) |
| 15:00:00 | Uwe Ricken | Enterprise Database Administration Deployment | Investigate, analyze and solve common wait stats scenarios |
| 15:00:00 | Steve Simon | Analytics and Visualization | Business Analytics with SQL Server Power Map:Everything you want to know but were afraid to ask |
| 15:00:00 | Allan Pead | Professional Development | Cross Platform Mobile Development with Xamarin |
| 15:00:00 | Toufiq Abrahams | Analytics and Visualization | Python integration in Power BI |
| 15:00:00 | Adnan Hendricks | Strategy and Architecture | Castles in the Sky: Achieving A secure Cloud infrastructure |
Event Date: 08-09-2018 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 08-09-2018 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 08-09-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-09-2018 - Session time: 09:00:00 - Track: Analytics and Visualization
In this session, you will see how easily great looking reports can be created using multiple data sources and easily shared within your organisation. We will also discuss licensing options available ranging from free through to Premium licencing.
Event Date: 08-09-2018 - Session time: 10:00:00 - Track: Application Database Development
In 2013 Kenny Gorman declared "The DBA is Dead".
For the record, I don't believe that, but a lot of people do. What is certain is that the world of IT is changing and traditional roles are changing with it. We all need to adapt.
In this interactive talk I'll explain what DevOps is, where it came from, and its implications for SQL Server. I'll demo example solutions to some of the foundational technical challenges (source control and test/deployment automation) and will leave plenty of time at the end to answer your questions.
Event Date: 08-09-2018 - Session time: 10:00:00 - Track: BI Information Delivery
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 08-09-2018 - Session time: 10:00:00 - Track: Analytics and Visualization
Processing that in many instances never happens...
Wouldn't it be more efficient and effective to process the data stream as it arrives?
Azure Stream Analytics is an event-processing engine which enables processing of streaming data in real time. It can handle up to 1 Gb of data per second, which should suffice for most applications.
In this tutorial I'll take you through the processing of setting up a job on Azure Stream Analytics. I'll look specifically at the following:
To illustrate these concepts we'll build a real time sentiment analysis system for streaming data from Twitter.
Event Date: 08-09-2018 - Session time: 10:00:00 - Track: Application Database Development
In this session, I’ll take you through the architecture of Azure SQL Datawarehouse, how it differs from a regular SQL Server and what those differences mean for database design, query design and usage patterns.
Event Date: 08-09-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
Event Date: 08-09-2018 - Session time: 13:00:00 - Track: Cloud Application Development Deployment
Use the same programming models you use in the cloud to create and test your IoT applications and then push them to your edge devices. This session is an introduction to Azure Iot Edge and what it can do for you.
Event Date: 08-09-2018 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 08-09-2018 - Session time: 13:00:00 - Track: BI Information Delivery
Dataflows is an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can be easily consumed by business analysts, thereby improving the speed at which business value can be delivered. Dataflows provides a single-version-of-the-truth which was traditionally attained by building a data warehouse. You will learn -How Dataflows can be used to create rich, vetted datasets -How Dataflows can be created with the click of a button, ingesting data from many well knows SAAS solution such as Dynamics and Salesforce -How to manage Dataflows using advanced data preparation tools such as Databricks
Event Date: 08-09-2018 - Session time: 13:00:00 - Track: Advanced Analysis Techniques
Event Date: 08-09-2018 - Session time: 13:00:00 - Track: Application Database Development
So when your DBA tells you that you need to fix a deadlock: what is it and how should you go about resolving it?
Event Date: 08-09-2018 - Session time: 14:00:00 - Track: Application Database 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 tighter regulation it's unwise 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: 08-09-2018 - Session time: 14:00:00 - Track: BI Information Delivery
In this session, we'll look at 4 common problems which occur when you're using more complicated data modelling techniques, and design and implement a simple solution to overcome these complications.
From role-playing dimensions and bi-directional filters to advanced filter context and overriding the default blank behaviour, we'll learn to solve a variety of problems and add value to our data models.
Event Date: 08-09-2018 - Session time: 14:00:00 - Track: Application Database Development
In this session, I’ll take you through the design process for graph tables, and then implement and query some graphs in both SQL Server 2017 and Cosmos DB using its graph model.
Event Date: 08-09-2018 - Session time: 14:00:00 - Track: Analytics and Visualization
We'll cover:
Event Date: 08-09-2018 - Session time: 14:00:00 - Track: Professional Development
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Analytics and Visualization
In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Professional Development
During this session we cover the Xamarin platform and how to create native iOS, Android, and Windows apps in C#. See what's new and next for Xamarin development inside of Visual Studio.
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Analytics and Visualization
Between demos we will chat a bit about the importance of Python integration and why it is a significant step for Power BI. Python is widely used and runs across platforms and applications. Any investment you have made in learning Python (or are planning to make), means that you are on the road to build skills considered to be the universal data science and utility language ... often referred to as the Swiss army knife of programming.
When you wrap your Python script in the best business analytics tool on the market (no prizes for guessing its Power BI ... and yes I am biased), you are well on your way to become a "Power Py" guru!
Event Date: 08-09-2018 - Session time: 15:00:00 - Track: Strategy and Architecture
This session will highlight the issues with cloud architectures and discuss ways to achieve visibility, compliance, and security. We will examine solution stacks that enable trusted computing and illustrate several usages that demonstrate policy enforcement, compliance, and end-to-end trust in the cloud. The session will also examine how organizations can monitor and enforce geolocation restrictions, ensuring that their workloads in the cloud are deployed on trusted hardware in known locations to meet security policy compliance. Trusted geolocation allows organizations to establish security and physical boundaries that limit which systems process and store sensitive information and applications in th