BCP in Azure Functions

Here is sample code to execute BCP in Azure Functions In this sample code, Azure Function will download a zip file from Azure Storage unzip this file using System.IO.Compression.ZipFile upload it to Azure SQL using System.Data.SqlClient.SqlBulkCopy Here is the complete source code Run.csx code is #r “System.Data”#r “System.IO.Compression.FileSystem” using System; using System.Data; using System.Data.SqlClient;using System.IO;…

0

How to determine the installed .NET version in Azure App Services

We have had a few questions about this so I figured I would create a quick blog covering how to determine the installed .NET version in Azure App Services (Azure Web Apps, Azure Mobile Apps etc…). The quickest way to do this is to open the Kudu console for your Azure App Service.  You can…

0

Azure ServiceBus Queue–reading query results from Stream Analytics

This blog is part of IoT Series, where I am trying to build few IoT devices that push events to Azure EventHub.  From the EventHub, Azure Stream Analytics will execute my query to calculate average values for each individual device and publish these average values to Azure ServiceBus. From Azure ServiceBus, I am going to…

0

Azure Function Apps – reading events from ServiceBus and writing to Redis Cache

This blog is part of IoT Series, where I am trying to build few IoT devices that push events to Azure EventHub.  From the EventHub, Azure Stream Analytics will execute my query to calculate average values for each individual device and publish these average values to Azure ServiceBus. From Azure ServiceBus, I am going to…

0

Azure Stream Analytics–reading events from EventHub, running query and saving results to ServiceBus

This blog is part of IoT Series, where I am trying to build few IoT devices that push events to Azure EventHub.  From the EventHub, Azure Stream Analytics will execute my query to calculate average values for each individual device and publish these average values to Azure ServiceBus. From Azure ServiceBus, I am going to…

0

Azure ServiceBus Queue–reading query results from Stream Analytics

This blog is part of IoT Series, where I am trying to build few IoT devices that push events to Azure EventHub.  From the EventHub, Azure Stream Analytics will execute my query to calculate average values for each individual device and publish these average values to Azure ServiceBus. From Azure ServiceBus, I am going to…

0

Azure EventHub–sending IoT device events to EventHub

This blog is part of IoT Series, where I am trying to build few IoT devices that push events to Azure EventHub.  From the EventHub, Azure Stream Analytics will execute my query to calculate average values for each individual device and publish these average values to Azure ServiceBus. From Azure ServiceBus, I am going to…

0

Azure IoT

This blog is part of IoT Series, where I am trying to build few IoT devices that push events to Azure EventHub.  From the EventHub, Azure Stream Analytics will execute my query to calculate average values for each individual device and publish these average values to Azure ServiceBus. From Azure ServiceBus, I am going to…

0

Adding Custom API routes with Node SDK

Azure Mobile Apps use a new SDK and there is a change in the way you can add custom routes to your API.  The Easy API interface allows you to quickly stub out a function for an API like http://mymobileservice.azurewebsites.net/api/Health for example, but documentation on how to add another route like http://mymobileservice.azurewebsites.net/api/Health/Databases is a little…

0

Backup Migrated Mobile Service (Node.Js backend)

You may have gotten this error when trying to backup a Migrated Mobile Service built with a Node.Js backend: Database connection string not valid for database MS_TableConnectionString (SQLAzure). Keyword not supported: ‘driver’. Reason: Backup is using ADO.NET internally. The Backup feature uses the Database Connection Strings to configure the Database backup and the setting: MS_TableConnectionString…

0