Renew AWS SessionToken and store values in Azure KeyVault

Why do you need this? Using temporary session tokens sounds like a good way to e.g. import data from S3 in Azure Data Factory, like it is described here Copy data from Amazon Simple Storage Service (S3) – Azure Data Factory | Microsoft Docs. Azure Data Factory can use secrets stored in Azure KeyVault for authentication (see here Store credentials in Azure Key Vault – Azure Data Factory | Microsoft Docs).

Count provisioned devices by DPS

This post shows a way to find out how many IoT (Edge) devices have been provisioned by a specific enrolment group within the last x minutes. The solution could be much simpler if I just wanted to know how many devices are registering themselves. In this case the build in metrics are enough to get that information.IoT Hub Metrics The use case required a more sophisticated solution that is able to reflect the tenants, identified by tags.

Azure IoT Edge on constraint devices

In this post I would like to show some tweaks you can (and might need to) apply to influence the behavior of your IoT Edge device, when it comes to message retention on devices that are limited in resources. The setup of this scenario is not uncommon, as it uses a module to retrieve telemetry from machines, parses them in another module and sends the messages to an IoT Hub.

Properties for IoT Messages in Azure Stream Analytics

In this post I want to show how to use properties that are added to messages that IoT devices are sending to Azure IoT Hub in Stream Analytics. And while talking about properties, let’s even use message enrichment 🙂Stream Analytics Architecture Sample Message The green properties will be added by the Message enrichment feature of IoT Hub, as the data is not most likely not known on the IoT device or does not need to be transferred with each message.


With Azure IoT Edge you can deploy modules (also known as Docker Containers) to a server. I’ve created a sample solution on GitHub that deploys a module which monitors the temperature of the harddisk that the server is running on. The repository can be a starting point for further customization.

Azure SQL with AAD authentication

I though this had to be an easy task. Well, actually it is. If you find the right documentation and read it in the correct order 🙂 Basically I wanted to be able to login with my AAD (Azure Active Directory) user. In the first step, the database needs to be configured for Azure Active Directory in order to add users in the second step. Configure an Administrator In the Azure portal go the the SQL server and search for “active directory” to add an Active Directory admin.

Azure Table Storage REST Api not returning data

Today I wanted to query entities of an Azure Table via REST Api and did not get any results. Looking over the query over and over again did not solve the problem. Sometimes I did not get any items back. The “sometimes” depended on the query. I checked each part. Partition Key, string and date columns. Everything looked all right. And then it hit me. I did not get a result, if there was too much data.

Azure Meetup OWL

Am Donnerstag (22.3.) treffen wir uns wieder: Use-Cases für Stream Analytics und Azure Databricks. Bitte meldet euch über Meetup oder direkt bei mir an, damit wir besser planen können und ihr aufs Gelände kommt 😉

No Default Subscription?

Set-AzureWebsite : No default subscription has been designated. Use Select-AzureSubscription -Default to set the default subscription. *doh* Again I’ve used PowerShell comandlets for Azure classic instead of Resource Manager 🙁 Reminder: Always check for the magic “Rm” chars in the command, if a resource cannot be found.

Azure Meetup OWL

Nicht vergessen. Morgen findet das Azure Meetup zum Thema Build, Test und Deployment mit Azure in Bielefeld statt. Meetup #2 – Build, Test und Deployment mit Azure <p style="margin:5px 0;font-size:16px"> Wednesday, Oct 11, 2017, 7:00 PM </p> <p style="margin: 0 0 5px;"> <span style="font-size:14px">Arvato Bielefeld / Sennestadt</span><br /><span style="font-size:12px;">Fuggerstraße 11 Bielefeld, DE</span> </p> <p> <span style="color:#4F8A10;font-size:16px;">17 Mitglieder Went</span> </p> <div style="margin:5px 0 10px" class="mu_clearfix"> <div class="photo"> <img src="" /> </div> <div class="photo"> <img src="https://secure.

HowTo use Azure cmdlets in Azure Schedule

A Runbook schedule can be triggered every hour. If you need a smaller interval, like every minute, you can use the Azure Scheduler to do so. So I went to the Azure Portal, created an Azure Schedule instance (with a job collection tier of at least basic, to be able to create schedules that are triggered every minute) and called a Runbook via webhook. The Runbook contains a cmdlet that results in an error 🙁

Azure SQL – Standard Tier IDs

In case you need the ServiceObjectiveId for SQL standard tiers, here is the list for you. Tier name ServiceObjectiveId Standard (S0) f1173c43-91bd-4aaa-973c-54e79e15235b Standard (S1) 1b1ebd4d-d903-4baa-97f9-4ea675f5e928 Standard (S2) 455330e1-00cd-488b-b5fa-177c226f28b7 Standard (S3) 789681b8-ca10-4eb0-bdf2-e0b050601b40 Standard (S4) 3cf14e1a-0a5d-408c-bbc7-f63c5282f735 Standard (S6) ab69b4e3-d7cc-4aa5-87a6-f8b50615a03c Standard (S7) b6ca0894-d2f0-4e40-99f5-0f8a93cc2437 Standard (S9) 0efa88e9-99ff-4e36-a148-8c4b20c0826c Standard (S12 98100e8b-2f8a-4a81-9eb5-4d1e675c5a29 Usually you could change the tier within the Azure Portal.

Connection Problems to a Secure Service Fabric Cluster

To be able to connect to a secure Service Fabric Cluster via PowerShell, you need to import the certificate specified into your personal certificate store. Otherwise an Exception will be thrown. Unfortunately the Exception does not point into the right direction 🙁 So in case you get an Exception like this Connect-ServiceFabricCluster : An error occurred during this operation. Please check the trace logs for more details. At line:1 char:1

Azure Meetup OWL

Am 13.7. wird das erste Treffen des Azure Meetups OWL stattfinden. Wir sind derzeit noch auf der Suche nach einem Ort und den Themen 🙂 Vermutlich wird es um Chatbots und Machine Learning gehen. Wir werden aber auch auf euer Feedback eingehen um Themen für die nächsten Treffen zu finden. Wenn ihr dabei sein möchtet, meldet euch bitte über die Meetup Seite an. Update: Ort: Arvato Systems, An der Autobahn 100, Gütersloh, Tower I