My blog of techy stuff, ranging around SQL (SQL Server, that is), C# and .net, JavaScript and a smattering of stuff about the Orchard CMS (that powers my site) as I get more familiar with it. There's the occasional non-technical post when something is of interest to me that I feel is worth sharing, but they should be few and far between
When the AAD account that owns a Power Automate flow (or Cloudflow, or whatever the name is by the time you read this....) is disabled it sometimes causes the trigger for the flow to stop working, even if you've changed the owner of the flow. Helpful, I know. It looks like this is caused by the trigger being still owned by the disabled user, which you can check by connecting via SQL to your…
If Visual Studio gives you the error "There is no Functions runtime available that matches the version specified in the project." then you'd, reasonably, think that the answer would be to either check for an updated version of Visual Studio or install an additional component. Neither of these are the solution. In this instance the Azure Functions project has a target framework of net9.0 which is…
For reasons best known to Microsoft, you can't change the secret used to authenticate a Microsoft Dataverse connection using a service principal (If you're not familiar with setting these up there's a good guide by Matthew Devaney ). That's a bit of a pain when the secret expires, to say the least. There are some workaround for this, like having a very long lived secret , but that doesn't resolve…
I've been using the HMRC provided 'Basic PAYE Tools' to run payroll and it does the job adequately. The one gap is that, whilst it performs periodic backups, backups are to a location that cannot be changed. Ideally it would be possible to configure the backup location so it could be somewhere that One Drive covers automatically, but at the time of writing the configuration is static. The quickest…
I've just finished upgrading all the project references in a CRM solution I built a while ago, which was using the Microsoft.Graph v4 .NET SDK (via the Microsoft.Graph v4.35.0 NuGet package , to be precise), which meant I took an upgrade to the latest version (v5.37.0 at the time of writing) which comes with some breaking changes. The changelog and upgrade guide is a good starting point but the…
I've been working on a few ASP.NET Core applications recently which has given me cause and opportunity to gate some functionality access behind feature flags whilst it's a work in progress, rather than having it gated behind if (app.Environment.IsDevelopment()) or similar where I then have to make code changes to enable the functionality. I've been doing this by using the…
Well... Somehow it's ended up being two years since I last posted (and that was a brief one about resetting your password via the command line ) on the blog here - hopefully with the amount of stuff that's been going on from a techy perspective I'll be able to put pay to that for the forseeable future as there's plenty I have to write about in the .NET (Core), Dynamics 365 CRM and Azure space from…
If, like me, you're working remotely at the moment you might be spending a non-trivial amount of time using Remote Desktop to hop on and off various machines. It might be that, also like me, you have to access machines that are in a DMZ using machine specific logins. If that's the case you can't just hit CTRL-ALT-END to change your password for the DMZ machine when it's multiple levels of remote…
If you're running Pi-hole (which you should if you can, it's awesome - you can even run it on a virtual machine ) and also happen to be running it in an Active Directory environment, there are various recommendations regarding how to configure it dotted around on the internet. Even having followed everything I've read, I was seeing some very unusual traffic where there would be regular incredibly…
We've recently had reports that some scheduled reports that are emailed out haven't been sent/received, looking at SSRS the error that was showing was: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent. It turns out that the active directory account for the owner of the subscription was recently deleted. Re-creating the subscriptions with the…
It's happened to most all of us at one time or another; an instance of SQL Server has been inherited where no one knows the sa password, or is a member of the sysadmin role, it's annoying when it's a SQL Server instance on a Development or Test server, but becomes far more problematic when it's on a production system. Fortunately, there's a way to solve this.
Back in 2017 I wrote about bootstrapping a carousel onto my homepage (was it really that long ago!?) and ever since then I've been adding, removing and modifying items in the carousel by copying, pasting and editing chunks of HTML. Needless to say this is something that's been somewhat error prone, brittle and has made me quite reluctant to modify the carousel unless I absolutely had to . A little…
This is an aide-memoire which may be of use to others, though it's old news and almost certainly won't be relevant unless you've got some relatively old codebases that need to be maintained and supported.. According to a post on the RavenDB google group , Reactive extensions announced that: The NuGet packages have changed their package naming in the move from v2.x.x to v3.0.0 Rx-Main is now…
There's a database here that I've been meaning to get into source control for a long time. Luckily we have regular backups of it (that have been restore proven) and it never changes so it's been pretty low down the priority list. Along comes today and I need to make some changes so, time to get it all scripted. I do this using SQL Server Management Studio, scripting one object per file and…
Having done some work against a local branch that's associated with a remote for a certain piece of work I've decided I want to keep the work (it's given me some proof-of-concept ideas) but start again on the actual task at hand. Keeping the current branch with all my commits but being able to "reset" back to the branch as it is on the server is the ideal outcome, which I've noted how to do below.…
In my current role I've spend some time working with the FIX protocol , which is: an electronic communications protocol initiated in 1992 for international real-time exchange of information related to securities transactions and markets. I'm pretty lucky in that there's an awesome library called QuickFix/n that takes care of doing the grunt work for me, but it's never a bad idea to have some…
I've been doing a bit of VM Host upgrading recently and being able to mainpulate VMs on said hosts via the command line makes things go a lot quicker! Here's two PowerShell commands I've executed more times than I'd care to mention over the past few days: Get-VM | Start-VM Get-VM | Save-VM The first command iterates over all VMs on the current machine (or another one if you've used Enter-PSSession…
One of the irritations of Windows 10 and its accompanying server editions is that there's no user interface surfaced to re-scan for available updates. The ability to do this comes in handy if, say, you've forgotten to approve all the relevant updates in WSUS before machines have scanned for them, or, a fresh install of Server 2016 has arbitrarily decided that the most recent cumulative update…
I inherited a couple of AngularJS applications that are built using gulp scripts when I started in my current role. Putting to one side the swathes of repeated code both within the build scripts for the same application (literally huge swathes of code copied and pasted from the script for building the desktop version into the script for building the mobile version) and that had subsequently been…
I just updated to the latest and greatest version of Visual Studio Code, but alas my taskbar was still showing the old icon: From this GitHub comment , here's a quick way to force the shell to refresh its icon cache, [Win]-[R] > ie4uinit.exe -show and there it is: