Category Archives: Azure

Enable Azure Invocation Log at Web Job function Level for PnP Provisioning

Hi, Few months ago I posted about enabling log and trace information for PnP Core Provisioning when using Console Application. Recently, I have been working in several projects with PnP Partner Pack Provisioning and some custom Web Jobs using PnP Core Provisioning bits as well. And there is one annoying thing in common, not having Read More →

Enable SQL Azure access from Azure WebJobs by adding firewall rules using PowerShell

Hi, When we are developing custom Azure Web Apps or WebJobs, likely we will need access to Azure SQL database. Depends on the needs you will use Entity Framework, or direct Queries using Stored Procedures, but this is not the topic of this post. The topic today is how to allow our Azure WebJob to Read More →

How to Unzip Azure Blobs programmatically using Memory Streams in Azure WebJOBs

Hi, Recently I had to extract files from a .zip file stored on Azure Blob Storage in Azure WebJob process.   This is what I did from scratch: 1. Create WebJob project: https://azure.microsoft.com/en-gb/documentation/articles/websites-dotnet-webjobs-sdk/ 2. Create Non-continuous Azure WebJob: https://github.com/Azure/azure-webjobs-sdk-samples/blob/master/BasicSamples/TableOperations/Program.cs static void Main(){    var host = new JobHost();    host.Call(typeof(Functions).GetMethod(“MyMethod”));} public class Functions{       [NoAutomaticTrigger]        public static void Read More →

How to provide SharePointContext to a Web API Action (ApiController) in a Provider-hosted SharePoint ADd-In

Hi, Recently I have been played with Azure Web Apps, and its integration with SharePoint. In this post we will see how to provide Authentication to Web API REST actions using SharePointContext, which means that we only will be able to invoke our REST actions if we are behind the context of SharePoint Provider-hosted App. Read More →

Where Azure SQL Database Management Portal is in V12?

I don’t often post things related with SQL because isn’t my core expertise. But nowadays, with the advent of Azure-hosted or provided-hosted apps (aka SharePoint Add-ins), all developers in one way or another, we are involved in a SharePoint developments could have external databases. This afternoon I was deploying one Office 365 App in Azure, Read More →