Import Database schema in Azure SQL DB from .SQL files programmatically with SQLCMD

Introduction – This blog post illustrates the method through which you can import your database schema and tables into empty Azure SQL DB ( PaaS ) programmatically. Currently azure SQL DB support import from BACPAC file in PowerShell and GUI but not from .SQL files. Assumptions  – Here we assume that you already have .SQL…

0

Azure Logic App – Lessons Learned – Part 2

Building on from the Part 1 post of a few weeks ago, let’s extend the treasure hunt with some additional functionality.  To find our next set of hidden gems, let’s transform the received message after having validated it, then use the transformed message to call a web service, and finally save the result into a…

1

Azure Logic App – Lessons Learned – Part 1

At present the logic app workflows, API apps and the syntax for the template language expressions are, at best, a well-kept secret, with precious little documentation on their definition and even less on its usage.  Since I have not yet been able to discover the hidden treasure chest that contains these nuggets of golden information,…

11

Azure Caching – Windows Azure SDK 2.0

Caching is one of the ways to achieve performance gains by serving request from a temporary location instead of calling backend resources for consequential requests. It is especially critical when considering most of the response times –throughput – take place during backend processes. In this post, I will explain how-to caching for cloud services with…

0

Diagnostics of Cloud Services – Windows Azure SDK 2.0

In this blog, I will demonstrate new diagnostics features of the new SDK (April 2012, v2.0) in a sample application. All the diagnostics instrumentation will be done on built-in features by modifying configuration settings.  This is well aligned with “Configure before Customize” approach.   Requirements: Windows Azure SDK v2.0, Windows Azure .NET Developer Center. This…

2

Diagnostics of Cloud Services – Custom Trace Listener

In this part of the series, I am going to talk about instrumenting diagnostic features for cloud services (web and worker roles) with a custom trace listener implementation in respect to new Windows Azure SDK for .NET (April 2013, version 2.0). Before starting the implementation, I would suggest you to get an overview of the…

3

Securing Dynamic Data ASP.NET SQL Azure Published Web Site with ACS and Facebook as an Identity Provider

The Scenario I wanted to implement an Azure web site that is using the Azure Access Control Service and integrates with an external identity provider to authenticate and authorize users. At first I thought of using Windows Live ID but it has a problem that the only claim offered by WLID is the unique identified…

2

Diagnostics of Azure Web Sites – Custom Logging

Introduction In the first part of these series, I talked about built-in diagnostics features of Windows Azure platform and mentioned that it gives high-level diagnostic information; for detail troubleshooting information a custom logging capability is recommended. In this post, I will propose a solution that writes custom/detail logs to Azure storage tables.  Please note that…

2

Diagnostics of Windows Azure Web Sites – Built-in Diagnostic Features

Introduction I have been developing an MVC 4.0 web application that is hosted in Azure platform. In this first part of 2-blog post series, I will talk about leveraging built-in logging and tracing features of Windows Azure platform.   Context Use of built-in diagnostic features requires 3 main steps: Step 1: Activation of built-in Windows…

1