Experience the basics of Azure IoT, Time-Series, dashboarding … and beyond! en nl

Internet of Things (IoT) is hot and happening. Many companies benefit from their machine data by optimizing their processes with remote monitoring and predictive maintenance.

,,But I don't know anything about IoT. How should I start? How do I get value from incoming raw telemetry?''

The best way to learn it is to experience it!

Within this workshop, you'll follow the scenario in which a remote coffee machine is connected to Azure for monitoring and management of issues. You can monitor device telemetry such as water temperature and water level, observe the state of your machine, set the optimal temperature, and send commands. Next to that, you learn how to query the data using KQL and use that for building simple but effective dashboards.

With this introduction, you will get an idea of the basic IoT principles by hands-on experience with a simulated device, Azure IoT Hub, Azure Data Explorer and Visual Studio Code. So, bring your laptop and prepare yourself for future IoT related cases and telemetry exploration within your organization.

Meanwhile, you will turn your laptop into a coffeemaker.

Check out the prerequisites at https://github.com/sandervandevelde/Experience-the-basics-of-Azure-IoT/

How to improve data quality in Azure Stream Analytics en nl

Azure Stream Analytics is known as a rule engine and is designed to analyze and process large amounts of streaming data. Because the dynamic nature of Azure Stream Analytics it's hard to guarantee the quality of the data. Especially when using multiple inputs, references and outputs.

But is it possible to improve the data quality of your solution by applying unit tests?

Yes it is, by creating test scenarios in Visual Studio Code for an Azure Stream Analytics project, data quality will improve even before deploying your solution to the cloud. It is also possible to integrate these test scenarios into your Azure DevOps CI/CD pipeline.

During this session, we will cover the basics of Azure Stream Analytics and demonstrate how to set up your own test scenarios in Visual Studio Code.

Afterward, you will be ready to improve your data quality for your future project...

Test-driven database development en nl

Test-driven development is a known approach in software development, where you write the tests first before you write your production code. Using this approach will result in writing better test coverage and better-quality code. Test-driven database development (TDDD) is a term that is less well known. But it is basically the same, only for database development.

We will walk through the concept of test-driven database development, open source framework tSQLt, setting up scenario's & more.

Language: EN or NL

Experience the basics of Azure IoT, Time-Series, dashboarding … and beyond! en nl

Internet of Things (IoT) is hot and happening. Many companies benefit from their machine data by optimizing their processes with remote monitoring and predictive maintenance.

,,But I don't know anything about IoT. How should I start? How do I get value from incoming raw telemetry?''

The best way to learn it is to experience it!

Within this workshop, you'll follow the scenario in which a remote coffee machine is connected to Azure for monitoring and management of issues. You can monitor device telemetry such as water temperature and water level, observe the state of your machine, set the optimal temperature, and send commands. Next to that, you learn how to query the data using KQL and use that for building simple but effective dashboards.

With this introduction, you will get an idea of the basic IoT principles by hands-on experience with a simulated device, Azure IoT Hub, Azure Data Explorer and Visual Studio Code. So, bring your laptop and prepare yourself for future IoT related cases and telemetry exploration within your organization.

Meanwhile, you will turn your laptop into a coffeemaker.

Check out the prerequisites at https://github.com/sandervandevelde/Experience-the-basics-of-Azure-IoT/

Explore an ocean of data with Kusto en nl

The Kusto Query Language (KQL) is available in many Microsoft Azure products, like Azure Data Explorer, Azure Log Analytics, Azure Monitor, and Microsoft Sentinel.

You get the right insights from these time series databases when you know your way around, using KQL as a powerful query language tool.

In this session, you get help getting started with this new and exciting query language!

We start with a short introduction to Kusto and the engine that is behind it. Then, we deep dive into a wonderful ocean of data.

We will explore the possibilities that Kusto offers to explore typical data formats and see how these can be transformed into value.

This session is packed with demos based on actual database examples, going beyond the basics to get you started by adding value like a true explorer.

Explore an ocean of data with Kusto en nl

The Kusto Query Language (KQL) is available in many Microsoft Azure products, like Azure Data Explorer, Azure Log Analytics, Azure Monitor, and Microsoft Sentinel.

You get the right insights from these time series databases when you know your way around, using KQL as a powerful query language tool.

In this session, you get help getting started with this new and exciting query language!

We start with a short introduction to Kusto and the engine that is behind it. Then, we deep dive into a wonderful ocean of data.

We will explore the possibilities that Kusto offers to explore typical data formats and see how these can be transformed into value.

This session is packed with demos based on actual database examples, going beyond the basics to get you started by adding value like a true explorer.

How to improve data quality in Azure Stream Analytics en nl

Azure Stream Analytics is known as a rule engine and is designed to analyze and process large amounts of streaming data. Because the dynamic nature of Azure Stream Analytics it's hard to guarantee the quality of the data. Especially when using multiple inputs, references and outputs.

But is it possible to improve the data quality of your solution by applying unit tests?

Yes it is, by creating test scenarios in Visual Studio Code for an Azure Stream Analytics project, data quality will improve even before deploying your solution to the cloud. It is also possible to integrate these test scenarios into your Azure DevOps CI/CD pipeline.

During this session, we will cover the basics of Azure Stream Analytics and demonstrate how to set up your own test scenarios in Visual Studio Code.

Afterward, you will be ready to improve your data quality for your future project...

Test-driven database development en nl

Test-driven development is a known approach in software development, where you write the tests first before you write your production code. Using this approach will result in writing better test coverage and better-quality code. Test-driven database development (TDDD) is a term that is less well known. But it is basically the same, only for database development.

We will walk through the concept of test-driven database development, open source framework tSQLt, setting up scenario's & more.

Deploy IoT Edge modules at scale with layered deployments en nl

At some point in your IoT project, you will need to create or update the modules of the IoT Edge devices. When you only have one or two devices, it is possible to do this by hand. But when more and more devices are added, it becomes impossible to do this by hand. This problem can be solved with IoT Edge automatic deployments.

In this session, I will explain the different possibilities, walk you through the steps and explain how to integrate the (layered) deployments into Azure DevOps.

Deploy IoT Edge modules at scale with layered deployments en nl

At some point in your IoT project, you will need to create or update the modules of the IoT Edge devices. When you only have one or two devices, it is possible to do this by hand. But when more and more devices are added, it becomes impossible to do this by hand. This problem can be solved with IoT Edge automatic deployments.

In this session, I will explain the different possibilities, walk you through the steps and explain how to integrate the (layered) deployments into Azure DevOps.

Asynchronous message processing with SQL Server Service Broker en nl

Suppose you have a web portal for booking holiday homes. After booking a holiday home, a process must be started for invoicing. However, it is not the intention that the billing will affect the performance of the web portal. We therefore want to start this process asynchronously in another instance.

In this session, I will cover how to solve this problem by using asynchronous message processing with SQL Server Service Broker.

Asynchronous message processing with SQL Server Service Broker en nl

Suppose you have a web portal for booking holiday homes. After booking a holiday home, a process must be started for invoicing. However, it is not the intention that the billing will affect the performance of the web portal. We therefore want to start this process asynchronously in another instance.

In this session, I will cover how to solve this problem by using asynchronous message processing with SQL Server Service Broker.

Kusto Detective Agency: Exciting interactive big data contest en nl

In this workshop we start with an introduction to Azure Data Explorer and Kusto Query Language (KQL). Then, we will cover the first couple of cases of the Kusto Detective Agency, an interactive big data contest developed by Microsoft. In which you have to solve various mysteries cases by using KQL. We start easy finding a missing book within a library, but the cases quickly become a lot more difficult.

We will provide hints but without any spoilers, you have to do it yourself.

Come and show your detective skills and prove that you are the crème de la crème of detectives.

Pre-requisites: A laptop and either a Microsoft account (MSA) or an Azure Active Directory (AAD) identity.

Kusto Detective Agency: Exciting interactive big data contest en nl

In this workshop we start with an introduction to Azure Data Explorer and Kusto Query Language (KQL). Then, we will cover the first couple of cases of the Kusto Detective Agency, an interactive big data contest developed by Microsoft. In which you have to solve various mysteries cases by using KQL. We start easy finding a missing book within a library, but the cases quickly become a lot more difficult.

We will provide hints but without any spoilers, you have to do it yourself.

Come and show your detective skills and prove that you are the crème de la crème of detectives.

Pre-requisites: A laptop and either a Microsoft account (MSA) or an Azure Active Directory (AAD) identity.