| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Simon | BI Information Delivery | An introduction to Data Mining with SQL Server 2017 |
| 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 | Andrew Collier | Orange | Web Scraping |
| 09:00:00 | Tinus Visagie | BI Platform Architecture, Development Administration | Design considerations and patterns for creating a supportable Data Warehouse |
| 09:00:00 | James McGillivray | Orange | Design Strategies and Advanced Data Visualization: The Ingredients for a Delicious Data Story |
| 10:00:00 | Angela Henry | Application Database Development | Data Types Do Matter |
| 10:00:00 | Allan Pead | Application Database Development | Let's create an Azure Sphere, Real-time Secure IoT Solution |
| 10:00:00 | Gail Shaw | Application Database Development | Functions - the good, the bad and the really, really ugly. |
| 10:00:00 | Niel Zeeman | Cloud Application Development Deployment | DevOps for Databases |
| 10:00:00 | Jeanne Combrinck | Cloud Application Development Deployment | Azure ML Studio for Beginners - Exploring, Creating Training Models |
| 13:00:00 | Alain Dormehl | Strategy and Architecture | Learn from the Product Group - Azure SQL DB: Hyperscale |
| 13:00:00 | Jean-Pierre Voogt | Congo | Working with data in Python for Beginners |
| 13:00:00 | Niels Berglund | Application Database Development | What is the PiRate, Snake, and Cup of Coffee Doing in My Database? |
| 13:00:00 | Angela Henry | Application Database Development | Profiling Your Data |
| 13:00:00 | Christiaan Steyn | Enterprise Database Administration Deployment | AWS - Finding the Best Fit: Deploying SQL Server on Amazon RDS Amazon EC2 |
| 14:00:00 | Allan Pead | Application Database Development | Build Cross Platform Mobile Apps with Xamarin |
| 14:00:00 | Arohan Naidoo | Orange | Paginated Reports in Power BI and SSRS |
| 14:00:00 | Gail Shaw | Cloud Application Development Deployment | sThere are Gremlins in my CosmosDB |
| 14:00:00 | Buck Woody | Information Delivery | Machine Learning, Artificial Intelligence and Deep Learning for t |
| 14:00:00 | Anna Hoffman | Application Database Development | SQL in Azure: What to use when |
| 15:00:00 | Niels Berglund | Application Database Development | A Lap Around SQL Server Big Data Cluster |
| 15:00:00 | Michael Johnson | BI Platform Architecture, Development Administration | Modelling like a star: Building effective data models in Power BI |
| 15:00:00 | Nigel de Wet | Professional Development | PowerApps... Introducing quick and easy mobile applications |
| 15:00:00 | David Brooks | Other | Data-Sovereignty and the Public Cloud |
| 15:00:00 | Bhavesh Lala | BI Information Delivery | Advanced Power BI - a combination of DAX And Power Query to help take your model further |
Event Date: 14-09-2019 - Session time: 09:00:00 - Track: BI Information Delivery
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
Defining what questions we want answered and how to go about this in an effective and efficient manner.
Creating the data model.
How to gather the necessary data, discussing the training and testing aspect.
Processing the model.
Extracting information from our finished model, discussing the implications of this information.
Event Date: 14-09-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 09:00:00 - Track: Orange
What would Ragnar do? He'd go out, grab the data and bring it home.
The contemporary Internet Viking uses Web Scraping to systematically extract information from web pages. This is the battle plan:
By the end of the tutorial you'll be ready to pillage and plunder large swathes of the internet.
Come along and make Ragnar proud.
This tutorial will be suitable for Vikings with low to moderate levels of Python experience.
Event Date: 14-09-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Great now what?
Nobody wants to be involved with a project that is constantly failing and difficult to support. This session will take a look at some design considerations and tips to ensure that your mart runs with minimal intervention and is easy to support.
The tools discussed and used in the examples will be SSIS and SQL server but many of the points discussed are valid for all tools.
Event Date: 14-09-2019 - Session time: 09:00:00 - Track: Orange
In this session, we will learn how to design for accessibility, allowing more people to benefit from our work. We’ll learn the difference between designing for users to explore information, and for users to consume insights. This will lead us into the basics of constructing a data story. From choosing the relevant data points, to removing all unnecessary distractions and constructing a cohesive narrative.
Every data story is unique, but the techniques for effective data presentation are universal. Improve your reports, dashboards, and slide decks by learning the art and science of quality data visualization.
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Application Database Development
Azure Sphere is a solution for creating highly-secured, connected Microcontroller (MCU) devices, providing you with the confidence and the power to reimagine your business and create the future.
Let's firstly learn what Azure Sphere is and why it's a good thing for society.
Then let's have some demo fun and learn more with it in action within a mobile enabled real-time IoT solution.
Featuring
Azure Sphere Azure IoT Hubs Xamarin Asp .NET SignalR Cosmos DB
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Application Database Development
I’ll show you how to replace simple scalar functions with an in-line table-valued function that performs far better. We’ll also look at the improvements to functions in sql server 2019.
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
Event Date: 14-09-2019 - Session time: 13:00:00 - Track: Strategy and Architecture
The database-as-a-service paradigm in the cloud (DBaaS) is becoming increasingly popular. Organizations adopt this paradigm because they expect higher security, higher availability, and lower and more flexible cost with high performance. It has become clear, however, that these expectations cannot be met in the cloud with the traditional, monolithic database architecture. This paper presents a novel DBaaS architecture, called Hyperscale. This session will cover the key ideas and features of Hyperscale, as well as comparing it to traditional deployment options.
Event Date: 14-09-2019 - Session time: 13:00:00 - Track: Congo
In this session, we will use Python in an easy to understand layout by using Notebooks as our Interface and pandas as our data manipulation library in Python. This session is for everyone that is just starting off in Python. We will learn how to import/export data into Python as well as manipulate and analyse data. Finally, we will look at how to bring this back into our SQL Server world.
Event Date: 14-09-2019 - Session time: 13:00:00 - Track: Application Database Development
Here we look at the SQL Server Extensibility Framework, and we see how we can call out to external languages from inside SQL Server. We look at R, Python and Java, and what we can do from SQL Server having access to those languages.
Event Date: 14-09-2019 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 14-09-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
The session is intended for someone who would be interested in moving their current on-prem/hosted SQL Server environments to AWS. They will gain basic information related to the difference between the options and have the opportunity to talk to some of the AWS engineers at the event before and after the session.
Event Date: 14-09-2019 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 14-09-2019 - Session time: 14:00:00 - Track: Orange
Event Date: 14-09-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment
In this presentation I’m going to take you through the basics of what CosmosDB is, show how to create and configure a database. Once we've got a database, we'll look at the the gremlin api, including how to create and query the graphs.
Event Date: 14-09-2019 - Session time: 14:00:00 - Track: Information Delivery
Event Date: 14-09-2019 - Session time: 14:00:00 - Track: Application Database Development
○ Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance), and hybrid ○ Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc) "
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: Application Database Development
This session gives you an overview of what a SQL Server Big Data Cluster is, and what you can do with it. We look at the various components, (Kubernetes, Spark, HDFS, PolyBase, etc.), and what you can do with them.
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
In this session, we take you on the journey of building such a model from the ground up with lots of tips, tricks and best practices that you can use in your models.
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: Professional Development
You don't need to be a mobile developer to create a quick, clean and useful app.
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: Other
Event Date: 14-09-2019 - Session time: 15:00:00 - Track: BI Information Delivery