PS

This artcle is just example how to use GATEWAY but in real app avoid using gateway. Read more

Intro

Few weeks ago i started playing with Azure. My task was simple how to configure Asp.Net Mvc Application and connect to database which is on other server in same network. The main reason why i spend lots of time is that i was using preview portal and as i understood its not yet ready and there is still some bugs and not finished features, but generally i like what Azure team did, new design is cool and allow to customize dashboard so you can easily configure what you want to see.
I would suggest to start from configuring network

Network

Lets start our configuration from network. Click on New -> Networking -> Virtual Network -> Deployment model -> Classic
NOTE: Dont choose Resource Manager deployment type because then you will not be able to connect with WebApp

Configure Address space

Address space CIDR block: 10.0.0.0/16 

Subnet name: Db

Subnet CIDR block: 10.0.1.0/24

So settings will look like 

Click create and wait. Azure will add icon to your dashboard after you hit create.

After its done network details will be opened.

Next step would be to create gateway where we will be able to connect via vpn and connect our web app. Click on gateway icon and select point to site connection type, I default address spaces since 256 addresses in range 10.1.0.0 is enough for me since i will have one web app scalable from 1 to 10 and 1 vpn connection at time.

after you hit ok it will start deployment and generally it takes up to 30 mins. so we have time to start with webapp

As soon as gateway is created root certificate should be uploaded so it will be possible to connect to this network with vpn.

Start command line as Administrator

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.1A\Bin\

makecert -sky exchange -r -n "CN=BetaRootCertificate" -pe -a sha1 -len 2048 -ss My "BetaRootCertificate.cer"

makecert.exe -n "CN=ClientBeta" -pe -sky exchange -m 96 -ss My -in "BetaRootCertificate" -is my -a sha1

WebApp

Database

---------------------------

Microsoft Visual Studio

---------------------------

The imported project "PATH\*.wpp.targets" was not found. Confirm that the path in the <Import> declaration is correct, and that the file exists on disk.  C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v12.0\Web\Microsoft.Web.Publishing.targets

---------------------------

ОК 

---------------------------

  <PropertyGroup>

    <VSToolsPath Condition="$(SkipWebPublish) == '' Or $(SkipWebPublish) == '*Undefined*'">$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion)</VSToolsPath>

  </PropertyGroup>

@echo off
reg.exe query "HKLM\SOFTWARE\Wow6432Node\Microsoft\MSBuild\ToolsVersions\12.0" /v MSBuildToolsPath > nul 2>&1
if ERRORLEVEL 1 goto MissingMSBuildRegistry

for /f "skip=2 tokens=2,*" %%A in ('reg.exe query "HKLM\SOFTWARE\Wow6432Node\Microsoft\MSBuild\ToolsVersions\12.0" /v MSBuildToolsPath') do SET MSBUILDDIR=%%B

IF NOT EXIST "%MSBUILDDIR%msbuild.exe" goto MissingMSBuildExe



"%MSBUILDDIR%msbuild.exe" /version



"%MSBUILDDIR%msbuild.exe" Source/SolutionName.sln /t:rebuild /p:configuration=Debug /p:Platform="Any CPU" /p:VisualStudioVersion=12.0 /p:SkipWebPublish=true

ng-repeat="dancer in dancers | filter: filterDancers(criteria) | orderBy: 'FullName'"

app.filter('orderByCustom', function () {

    return function (items) {

        return items.sort(function (a, b) { return a.FullName.localeCompare(b.FullName) });;

    };

});

ng-repeat="dancer in dancers | filter: filterDancers(criteria) | orderByCustom"

var deleteLabelName = "Delete me";
var acrhiveDates = "2d";
var removeDates = "90d"
function archiveInbox() {
  // Every thread in your Inbox that is read, older than two days, and not labeled "delete me".
  var label = GetDeleteLabel();
  var threads = GmailApp.search('label:inbox older_than:'+acrhiveDates+' -label:* -is:starred');
  for (var i = 0; i < threads.length; i++) {
    threads[i].moveToArchive();
    label.addToThread(threads[i]);
    Utilities.sleep(1000);
  }
}

function GetDeleteLabel(){
  var label = GmailApp.getUserLabelByName(deleteLabelName);
  if(!label){
    label = GmailApp.createLabel(deleteLabelName)
  }
  return label;
}

function cleanupItems() {
  var batchSize = 100 // Process up to 100 threads at once
  var threads = GmailApp.search('label:"'+deleteLabelName+'" older_than:'+removeDates);
  for (j = 0; j < threads.length; j+=batchSize) {
    GmailApp.moveThreadsToTrash(threads.slice(j, j+batchSize));
  }
}