Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 25
The new release of SQL Server; SQL Server 2019 includes Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage. This new architecture that combines together the SQL Server database engine, Spark, and HDFS into a unified data platform is called a “big data cluster.”
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 14

Time: 3:00 PM - 4:00 PM

Room: Congo

In the Information Age, tools such as Power BI play pivotal roles in helping to gain an understanding of the world through data. Here I will show you how you can make your data sing and dance with Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Advanced

Session Code:

Date: September 14

Time: 3:00 PM - 4:00 PM

Room: Kai

With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.

In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:

1)  Defining what questions we want answered and how to go about this in an effective and efficient manner.

2)  Creating the data model.

3)  How to gather the necessary data, discussing the training and testing aspect.

4)  Processing the model.

5)  Extracting information from our finished model, discussing the implications of this information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: September 14

Time: 9:00 AM - 10:00 AM

Room: Berg

In this session we will be covering SQL Server on AWS architecture. We will be looking at SQL Server on EC2 and also more on SQL Server on RDS and the benefits of both.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 14

Time: 1:00 PM - 2:00 PM

Room: Zambezi

In this session we shall take a look at Azure Machine Learning Studio. We will import data sets, create models and train them. We will go over the fundamentals of Azure Machine Learning and what it has to offer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Congo

These days .NET can be found running almost anywhere!  Let's have a look together at what's new in Xamarin and Xamarin Forms and also how to leverage your existing .NET and C# skills to create beautiful native cross platform mobile apps in Visual Studio 2019.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 2:00 PM - 3:00 PM

Room: Congo

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I can't tell you how many times I've heard these phrases.  This session will help you understand why choosing the correct data type for your data is so important.  It affects data quality, storage and performance.  It can even produce incorrect query results.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Berg

As we engage with users in ever varying geographies the laws and regulations around where your data resides becomes more and more complex. In this session we look at the challenges around Data-Sovereignty in Africa and some of the strategies and technologies being put in place to remain compliant.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: September 14

Time: 3:00 PM - 4:00 PM

Room: Berg

So you've built a flashy new Data Warehouse and deployed it to production. 

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 14

Time: 9:00 AM - 10:00 AM

Room: Congo

You’re comfortable with picking the right visualization for a specific data set, and making it look good. You know the basics of design and can craft a report that is pleasing on the eye. Now it’s time to take your data presentation skills to the next level.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Orange

Level: Intermedia

Session Code:

Date: September 14

Time: 9:00 AM - 10:00 AM

Room: Zambezi

What is the majority of applications without a database? The focus has been on developer practices and code quality, but the database has been long forgotten. In this session, I will show you how the database becomes a 1st class citizen in the development/DevOps processes. We will look at how to go about evaluating, testing and deploying databases for quick turnaround and continuous deployment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Tugela

Scalar functions have a bad reputation in SQL Server, and for good reason. In this presentation I’m going to show the problems that scalar functions cause, in terms of performance and why they’re so hard to see in many cases.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Zambezi

This session will focusing on providing a  SQL/BI developer with the basics to rapidly getting started working with data generated from Internet of Things(IoT) devices using  Windows 10 IoT core running on a Raspberry Pi as an IoT source collect data and send data to Azure IoT hub. Some of the aspects that will be looked at is getting the development environment setup, getting Windows 10 IoT core running on a Raspberry Pi , connecting IoT device to Azure and the challenges faced, then we will move on to getting an app running that sends data to IoT hub and visualizing this data in Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 14

Time: 9:00 AM - 10:00 AM

Room: Kai

This session will be presented by the Microsoft Azure SQL Database Product Group and will cover a deep dive into the architecture for Azure SQL Database Hyperscale. 

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: September 14

Time: 1:00 PM - 2:00 PM

Room: Kai

Get ready for the MCU IoT revolution

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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 14

Time: 10:00 AM - 11:00 AM

Room: Kai

The world of Data Science brings with it new terms and jargon. However, some of these terms have real, defined differences, and as a data professional, you should know the differences. Buck Woody, an Applied Data Scientist from the SQL Server team at Microsoft, will show you the math, languages, technologies and processes used in Artificial Intelligence (AI), Machine Learning (ML) and Deep Learning (DL), the use-cases for each, and the options you have to leverage and implement each technology, included those in the SQL Server platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: September 14

Time: 2:00 PM - 3:00 PM

Room: Tugela

At the heart of every Power BI report lies a data model and to build great reports, one needs a great data model that allows flexibility while still providing fast and accurate results.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 14

Time: 3:00 PM - 4:00 PM

Room: Tugela

In this session you will learn about use cases for paginated reports, working with sub-reports in SSRS to  build reusable sections which will form part of a dynamic which can be used to create a structured invoice or statement. We will then dive into the paginated report functionality in Power BI and learn more about SSRS features that are now available in Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Orange

Level: Beginner

Session Code:

Date: September 14

Time: 2:00 PM - 3:00 PM

Room: Kai

Microsoft PowerApps is a suite of apps, services, connectors and data platform that provides a rapid application development environment to build custom apps for your business needs. Using PowerApps, you can quickly build custom business apps that connect to your business data stored.

You don't need to be a mobile developer to create a quick, clean and useful app.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: September 14

Time: 3:00 PM - 4:00 PM

Room: Zambezi

Have you ever started a warehouse or ETL project and realized that the data wasn't as "clean" as you were told?  If only you had profiled your data before you started then you wouldn't have to rework design elements, change code or redesign your database.  In this session we will talk about what data profiling is, why you should do it and how you can do it with tools that are already included in the SQL Server BI stack.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 14

Time: 1:00 PM - 2:00 PM

Room: Berg

Sessions Found: 25
Back to Top cage-aids
cage-aids
cage-aids
cage-aids