Azure

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).

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.

Configure Azure IoT Edge for downstream devices

A lot of documentation and posts are available to setup an Azure IoT Edge to act as an IoT Hub for downstream devices. In order to get it up and running in a dev environment, I had to do some more research. My setup is a RaspberryPi 3 with Raspbian stretch and an Azure IoT DevKit which looks like this. And please remember the setup I used is for development only.

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="https://secure.meetupstatic.com/photos/member/8/e/6/b/thumb_268416459.jpeg" /> </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