Posts
An Excel VBA multiple decrement model of IFoA membership (v1)
by Patrick Lee on 10 Sep 2022 in categories actuarial with tags Excel modelling VBA
Here is the first version of an Excel VBA program to model the membership of the Institute and Faculty of Actuaries (or any similar professional body). It may be freely used by others under the Creative Commons License. I have produced this in an attempt to help actuaries and others ...
No Application Insights requests or exceptions showing for .NET 5 and 6 app services? Need to configure the project within Visual Studio
by Patrick Lee on 25 Aug 2022 in categories tech with tags Application Insights .NET 5.0 .NET6.0
If App Insights is not showing any data for a .NET 6 (or 5) web app, configure it within Visual Studio
Microsoft Graph: to change user passwords, an app can't use API permissions instead just needs User Administrator role
by Patrick Lee on 25 Aug 2022 in categories tech with tags ActiveDirectory ADB2C Azure MicrosoftGraph
User Administrator (or similar) role is needed for a registered app to change a user's passwords within Microsoft Graph.
A hole in Azure Active Directory: Microsoft ought to list the roles a registered application has
by Patrick Lee on 25 Aug 2022 in categories tech with tags ActiveDirectory Azure
It is very hard to find out what roles an app has been granted. When you add a role, document this within the notes section of the app's blade in the Azure portal. Microsoft ought to fix this.
Running out of disk space on a Windows pc? TreeSize may help, beware OneNote cache and backup folders
by Patrick Lee on 19 Jun 2022 in categories tech with tags OneNote Windows
I have been finding that on several pcs that I use, the free space on the C drive has been reducing constantly over time. The existing tools within Windows 10 didn't help as they don't make it easy to find out where the large files and folders are, and the ...
Want to move large files/large numbers of files to/from Azure Storage? Use AzCopy or Microsoft Azure Storage Data Movement
by Patrick Lee on 20 May 2022 in categories BigData tech with tags AzureFunctions AzureStorage
If you need to move thousands of Azure blobs, or very large ones (many GB) then you can either use AzCopy (a command line tool which you run locally), or if you want to do things programmatically, you can use the Microsoft Azure Storage Data Movement library. That library is ...
How to extend the timeout for Azure functions beyond the default limits - use AzureFunctionsJobHost__functionTimeout setting
by Patrick Lee on 20 May 2022 in categories BigData tech with tags AzureFunctions
By default, Azure functions timeout after 10 minutes (or 30 minutes if running in an App Service Plan, or a Premium plan). The official documentation (see https://docs.microsoft.com/en-us/azure/azure-functions/functions-host-json#functiontimeout) says that you can increase (or reduce) this by adding a functionTimeout value to host.json. But this doesn't seem to work for a ...
Working towards a Pensions Dashboard
by Patrick Lee on 08 May 2022 in categories actuarial BigData pensions tech with tags dashboard pensionsdashboard
I am creating a prototype, suitable for use with the UK's Pensions Dashboard project. Early days, but have made good progress so far! More in due course.
How to trigger and query an Azure Entity Function without using an ordinary function - just use the built in HTTP webhooks!
by Patrick Lee on 08 May 2022 in categories BigData tech with tags AzureFunctions DurableFunctions Functions
A simpler way to create and query Azure Entity Functions (previously called Durable Entities): just use the built in webhooks.
Some Microsoft Professional certifications passed
by Patrick Lee on 01 May 2022 in categories actuarial tech with tags Azure CSharp lifelong learning
Both last year and this year I took (and passed) a Microsoft exam (I suppose the equivalent of CPD - Continuing Professional Development). Last year it was Programming in C# (certification: here ), and this year it was Microsoft Certified: Azure Developer Associate (certification: here ).