| Mo Valipour mvalipour

Install Teamcity
Go to /conf/server.xml and find <connector> node
set the following attributes on it

  <Connector port="8080" protocol="org.apache.coyote.http11.Http11NioProtocol"
    connectionTimeout="60000"
    redirectPort="8543"
    useBodyEncodingForURI="true"
 socket.txBufSize="64000"

Step 1. Deploy to Azure

Pre-Deploy
- Log octopus parameters -- A
- Transform package: Run service definition, service configuration, web/app config and file transformations/replacement bundled into the package. -- B
Post-Deploy
- Log deployment -- C
- Ensure/Add diagnostics extensions -- D
- Wait loop for /healthcheck endpoint -- E
- Notify Slack/Skype -- F
Deploy-failed

This configuration allows having pre-authenticated URLs.

-- i.e. mapping /auth/xyz/some/resource to /some/resource?token=xyz

NOTE: This DOES preserve other querystrings on the URL.

pre-authenticated urls were useful for our elasticsearch reverse proxy to allow us use authentication with sense.

	public class RequireDatabaseToBeUpToDate<TContext, TMigrationsConfiguration> : IDatabaseInitializer<TContext>
	where TContext : DbContext
	where TMigrationsConfiguration : DbMigrationsConfiguration, new()
	{
	public void InitializeDatabase(TContext context)
	{
	var migrator = new DbMigrator(new TMigrationsConfiguration());
	var migrations = migrator.GetPendingMigrations().ToList();
	if (migrations.Any())
	{

	<?xml version="1.0"?>
	<ServiceDefinition name="Cloud" xmlns="http://schemas.microsoft.com/ServiceHosting/2008/10/ServiceDefinition" schemaVersion="2015-04.2.6">
	<LoadBalancerProbes>
	<LoadBalancerProbe name="healthcheck" path="/healthcheck" protocol="http" port="80" intervalInSeconds="30" timeoutInSeconds="61" />
	</LoadBalancerProbes>
	<WebRole name="Web" vmsize="Large">
	<Sites>
	<Site name="Web">
	<Bindings>
	<Binding name="Endpoint1" endpointName="httpIn" />

	DECLARE @sql nvarchar(MAX);
	SELECT @sql = (SELECT 'UPDATE STATISTICS [' + DB_NAME() + '].[' + rtrim(sc.name) + '].[' + rtrim(so.name) + '] WITH FULLSCAN, ALL;' + CHAR(13) + CHAR(10)
	from sys.sysobjects so
	join sys.schemas sc
	on so.uid = sc.schema_id
	where so.xtype = 'U'
	FOR XML PATH(''), TYPE).value('.', 'nvarchar(MAX)');
	PRINT @sql
	EXEC (@sql)

	param([Parameter(Mandatory=$true)] $subscriptionId)

	Import-Module Azure

	Set-AzureSubscription -SubscriptionId $subscriptionId
	Select-AzureSubscription -SubscriptionId $subscriptionId

	function Do-Server($serverName) {
	Get-AzureSqlDatabase -ServerName $serverName \| ForEach-Object { Do-DB $_ }
	}