petevb

Examples

This would get things US that need estimating (based on Feature's state):

?not Tags.Contains('OnHold') and (Feature.EntityState is 'Estimated' or Feature.EntityState is 'Defined')

However, if Calum tags them we might prefer this:

?Tags.Contains('estimate') and not (Feature.EntityState is 'Create' or Feature.EntityState is 'Initial')

petevb

Minutes of CivComm meeting, 24 April 2019

• Present: Robert Cottrell, Peter Barnes, Val King, Rachel Woollett, Dan Cecil
• Apologies: Pete van Blerk

Actions

• Dan to initiate BPSS for Peter Barnes and Val King, and ask Pete van Blerk if he wants to do it.
• Val to try to book RBL for AGM (26th June)
• Val to ask Suzanne Brown for venue contacts for summer party

petevb

delete branches no longer on remote (Windows console)

for /f "tokens=1,2,3*" %i in ('git branch -v') do @if "%k"=="[gone]" git branch -d %i

petevb

try this

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

NB I tried this first

petevb

Using Azure CLI to add cert and hostname to web apps

These notes assume that you already have an app service plan running a number of sites (web apps) that ALL want the same wildcard cert.

The problem being solved was how to point a number of sites to a company domain.

The aliases (e.g. alias trainer.foo-uk.com onto CNAME pvb-live-eun-trainer-as.azurewebsites.net) MUST already be configured in DNS -- Azure will check!

First, how to get the interesting App Service Plan

petevb

Delete Timers from Storage on Deployment to a Staging Slot.

This stops Functions running its overdue timers when you deploy to a staging slot. You need to define the variables, per the comment in the yaml.

The task is simple:

az storage blob delete-batch --account-name $(StorageAccount) --source azure-webjobs-hosts --pattern timers/$(AppServiceName)-staging/*

petevb

az cli samples

• Using Azure CLI to add cert and hostname to web apps
• List Appsettings in every slot of every webapp and function app for a given sub
• List cosmos DBs in every resource group of a subscription and see their failover locations
• List cosmos DBs in every resource group of a subscription and find their current thoughput, etc.
• <19f1b72775e8bae45636ff1b0b529d57#Set-ApplicationInsightsRetention.ps1>

petevb

boxstarter

1. If you're using a Chromium browser, enable click-once via (e.g. for Edge) edge://flags/#edge-click-once.

Install the stuff below (i.e. my boxstarter.txt):

WARNING: Clicking these links will install apps on your machine; Please review the scripts before you do that!

1. Install the apps that PvB wants.
   • View script: https://gist.githubusercontent.com/petevb/67f78762537e742015da018a33558119/raw/pvb.ps1

petevb

# some more ls aliases
alias ll='ls -alF'
alias la='ls -A'
alias l='ls -CF'

# Add an "alert" alias for long running commands.  Use like so:
#   sleep 10; alert
alias alert='notify-send --urgency=low -i "$([ $? = 0 ] && echo terminal || echo error)" "$(history|tail -n1|sed -e '\''s/^\s*[0-9]\+\s*//;s/[;&|]\s*alert$//'\'')"'

# twotime: https://www.npmjs.com/package/twotime

petevb

#############################################################################
# This script will enable preview for a given extension in Windows Explorer.
# Based on original by Bhargav Shukla http://www.bhargavs.com
# 
# DISCLAIMER
# ==========
# THIS CODE IS MADE AVAILABLE AS IS, WITHOUT WARRANTY OF ANY KIND. THE ENTIRE 
# RISK OF THE USE OR THE RESULTS FROM THE USE OF THIS CODE REMAINS WITH THE USER.
#############################################################################
param (