SSL Connection Error on Azure

Added app settings in the web job.

DOTNET_SYSTEM_NET_HTTP_USESOCKETSHTTPHANDLER

to false.

Retrieve or set function app version on Azure

$funcName = "function-name-func"
$resourceGroup = "resource-groupname-rg"
$funcVersion = "~1"


az functionapp config appsettings list --name $funcName --resource-group $resourceGroup --query "[?name=='FUNCTIONS_EXTENSION_VERSION'].value"

or

az functionapp config appsettings set --name $funcName --resource-group $resourceGroup --settings FUNCTIONS_EXTENSION_VERSION=$funcVersion

Format pound and pence currency javascript

 function formatCurrency(num) {
            num = num.toString().replace(/\$|\,/g, '');
            if (isNaN(num))
                num = "0";
            sign = (num == (num = Math.abs(num)));
            num = Math.floor(num * 100 + 0.50000000001);
            pence = num % 100;
            num = Math.floor(num / 100).toString();
            if (pence < 10)
                pence = "0" + pence;
            for (var i = 0; i < Math.floor((num.length - (1 + i)) / 3) ; i++)
                num = num.substring(0, num.length - (4 * i + 3)) + ',' + num.substring(num.length - (4 * i + 3));
            return (((sign) ? '' : '-') + '£' + num + '.' + pence);
        }

function CheckNumeric() {
            return event.keyCode > 47 && event.keyCode < 58 || event.keyCode == 46;
        }

function FormatOtherAmount() {
            var anotherAmount = document.getElementById('mainContent_txtOtherAmount');
            document.getElementById('mainContent_txtOtherAmount').value = formatCurrency(anotherAmount.value);
        }

Octopus production config transformation

Additional transforms

Web.Release.config => Web.config
*.Production.config => *.config

You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server

USE 
GO
ALTER DATABASE SET TRUSTWORTHY ON
EXEC sp_changedbowner 'sa'

http://support.microsoft.com/kb/918040

TFS to Git migration

http://il-adan.blogspot.com.tr/2013/11/tfs-to-git-migration-step-by-step.html

MongoDB: Update a field in collection

db.foo.update({filter}, {$set: {fields}}, { multi: true }) 

db.foo.update({Title: "Test"}, {$set: {PublishedTime: new ISODate("2014-11-19T16:29:00Z")}}, { multi: true })